> For the complete documentation index, see [llms.txt](https://helpdocumentation.gitbook.io/user/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://helpdocumentation.gitbook.io/user/automations-builder/how-to-trigger-automations-flow-or-send-whatsapp-messages-from-google-sheet-particular-column-change.md).

# 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/1ECWZucWLUa4CcjJFORDkYRDHkwpgzDFQHBeDWo-MQhI/edit?tab=t.0>

* 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.

5. Save the script.
6. Enter some dummy data in the Google Sheet.
7. 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.
8. Click on **Editor > Capture incoming webhook** to test the script.
9. Update the monitored column in the Google Sheet and verify if the data is received in the Automation Builder.
10. Implement further integrations such as time delays, WhatsApp messages, etc., based on the column change.

{% embed url="<https://youtu.be/OCuZ1yzTbak>" %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://helpdocumentation.gitbook.io/user/automations-builder/how-to-trigger-automations-flow-or-send-whatsapp-messages-from-google-sheet-particular-column-change.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.