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

Before you can utilize this trigger, you will need to perform some additional setup in your Google Sheet.

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":

3. Prepare the Script

• Clear any existing code in the Editor section:
• Paste the script found in the following link into the editor: Trigger Script

4. Add Webhook URL

• Go to your Flows Google Sheets connection in the "Linked Apps" section.
• Copy the webhook URL:
• Paste this URL into the endpoint variable on line 14 of the script:
  
  

5. Save and Configure the Script

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

6. Grant Permissions

• Click "Review permissions":
• Select your Google account and click "Allow".
• You will see at the bottom under "Execution log" that the execution was completed:

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:
• 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":

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