---
updatedAt: 2026-03-03T21:49:51.000Z
agentTools:
  projectIndex: https://docs.knack.com/v3/llms.txt
---

# Flows: "Watch for cell change and send the row" Trigger

### Overview

Before you can utilize this trigger, you will need to perform some additional setup in your Google Sheet. This article outlines the necessary steps to successfully activate this trigger.

### Step-by-Step Process

#### 1. Open Your Google Sheet

* Navigate to the Google Sheet you will be utilizing in your Flow.

#### 2. Access Apps Script

* In the top navigation section of your sheet, select "Extensions".
* Select "Apps Script":![](https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94ae478a00f0291397f61/original/watchforcellchange1.png)

#### 3. Prepare the Script

* Clear any existing code in the Editor section:![](https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94aec2d9007027fc929d5/original/watchforcellchange2.png)
* Paste the script found in the following link into the editor: **[Trigger Script](https://docs.google.com/document/d/1lwDvQFhRQrQliIeACiPGSVCjVwhoz9vTIHPtQrKnqkA/edit?usp=sharing)**

#### 4. Add Webhook URL

* Go to your Flows Google Sheets connection in the "Linked Apps" section.
* Copy the webhook URL:![](https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94af42d9007027fc929d9/original/watchforcellchange3.png)
* Paste this URL into the endpoint variable on line 14 of the script:![](https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94afb78a00f0291397f66/original/watchforcellchange4.png)

**Note:** Ensure that you have removed the `< >` symbols from the endpoint variable. Your webhook URL should be within double quotation marks.

#### 5. Save and Configure the Script

* Click the Save icon.
* Select the "createSpreadsheetOpenTrigger" option.
* Click the "Run" button.

<Image alt="runscript" border={false} src="https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94b0378a00f0291397f6c/original/watchforcellchange5.gif" />

#### 6. Grant Permissions

* Click "Review permissions":![](https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94b1a78a00f0291397f7f/original/watchforcellchange6.png)
* Select your Google account and click "Allow".
* You will see at the bottom under "Execution log" that the execution was completed:![](https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94b2278a00f0291397f8b/original/watchforcellchange7.png)

#### 7. Handle Security Warnings

If you see a warning:

* Click "Advanced".
* Select "Go to (Project name)".
* Click "Allow" to grant necessary permissions.

#### 8. Verify Triggers

* Navigate to the "Triggers" section in Apps Script:![](https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94b292d9007027fc929f5/original/watchforcellchange8.png)
* Confirm only one trigger is saved.
* If you make any mistakes during the setup process, several triggers may be saved. Delete the extras by selecting the trigger > vertical ellipses > and "Delete trigger":![](https://s3.us-east-1.amazonaws.com/assets.knackhq.com/assets/68d3f1eacc1b6802878d52ba/68e94b1378a00f0291397f74/original/watchforcellchange9.png)

#### Final Step

Your spreadsheet is now ready to use with Flows! You can proceed to create your Flow scenario using the "Watch for cell change and send the row" trigger.

#### Troubleshooting

* Ensure you've copied the webhook URL exactly.
* Double-check that you've selected the correct Google Account when granting access.
* If you encounter any persistent issues, please reach out to our support team for help: **[Create Support Ticket](/docs/tickets/new#/)**

**Pro Tip:** Keep your webhook URL confidential and do not share it publicly.