How To Trigger Automations Flow Or Send WhatsApp Messages From Google Sheet Particular Column Change

1. Create a Google Sheet and name it.

2. Enter data into the Google Sheet.

3. Navigate to Extensions > App Script > Untitled project.

4. Replace the monitored column and automation webhook URL in the script with your values.

Script: https://docs.google.com/document/d/1WqvyMpAJ04r6LztFCC7wczeCuijdO9rIj90hLxhFFG4/edit?usp=sharing

• To find the automation webhook URL:

  1. Create a workflow in Automation Builder.

  2. Select Webhook > Custom Webhook.

  3. Copy the webhook URL.

Set the monitored column to the column number you wish to trigger the automation for.

1. Save the script.

2. Enter some dummy data in the Google Sheet.

3. In the script editor:

   • Go to Triggers > Add trigger.

   • Select onEdit for the function to run on edit.

   • Choose your Gmail ID.

   • Click on Advanced > Go to the app script name to allow access.

4. Click on Editor > Capture incoming webhook to test the script.

5. Update the monitored column in the Google Sheet and verify if the data is received in the Automation Builder.

6. Implement further integrations such as time delays, WhatsApp messages, etc., based on the column change.