How To Trigger Automations Flow Or WhatsApp Messages For All Or Selected Rows in Google Sheet ?

How to Set Up and Use Google Sheet Automations

1. Install App Script: Get the app script code from- https://pastebin.com/iJkLWvhX and install it into your Google sheet. Ensure you replace the webhook URL in the app script with yours.

2. Reload the Sheet: Refresh your Google sheet page to see the new menu option "Trigger Automations".

3. Authorize Email: To test the automation, click on "Send Selected Rows" from the new menu and authorize your email.

4. Enter Data in Automations Builder:

   • Input two or three rows of data.

   • Click "OK".

5. Map Webhook Data:

   • Use the data received in the webhook to perform actions like sending WhatsApp messages or adding time delays.

6. Save and Enable Workflow: Save the workflow settings and activate the automation.

7. Trigger Automations:

   • Use the "Trigger Automations" menu to send all or specific rows to the webhook. Specify the row numbers if needed.