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.