Google Sheet row updated

The “A row is updated in Google Sheets” trigger activates whenever an existing row in the selected Google Sheet is modified. This allows you to automate actions in SleekFlow, ensuring seamless data synchronization and workflow efficiency.

The trigger also activates for rows that move to a different position in the sheet, for example when a row is inserted, sorted or deleted above them. 

Here are a few ways you can leverage the “Google Sheet row updated” trigger:

• Send an automated message based on data updates
  • When a row is updated with new information, you can automatically send a personalized message to the relevant contact. This is useful for notifying customers about changes in their orders, appointment rescheduling, or subscription updates.
• Update contact details in SleekFlow
  • If an existing row contains updated customer details, such as a new phone number, email, or status change, you can sync this data directly to SleekFlow’s contact database. This ensures that your records remain accurate and up to date.
• Automate coupon and voucher tracking
  • If a redemption status is updated in Google Sheets (e.g., from “Unused” to “Redeemed”), SleekFlow can trigger an automated action such as sending a confirmation message, applying loyalty rewards, or reminding the customer about upcoming offers.
     

Set up "A row is updated in Google Sheets" trigger node

You can follow the steps below to set up the “Google Sheet row added” trigger node:

1. Click on the node to open up its form, which will appear on the right side of the screen
   
2. The node form contains the following fields for you to set up the trigger:
   1. Setup tab
      1. Google account: Select the Google account you want to use within this node. If you have not connected to a Google account for your Google Sheets integration, you can refer to the Connect to your Google Sheets integration Help Center article
      2. Google Sheet: Once you have selected the Google account, the “Google Sheet” field will appear. Select the Google Sheet that you want to set the trigger with.
      3. Sheet: If the selected Google Sheet contains multiple worksheets (tabs), you will also need to select the specific sheet (e.g. “10% off”) that should trigger the flow when a new row is added.
         
         
   2. Filter tab
      1. Enrollment conditions: When toggled on, you can set specific conditions at the “Filter” tab that the customer must meet in order to be enrolled into the flow. For example: 
         1. Payment status changes to “Paid” — only rows updated with this value will be enrolled into the flow.

Limitations: inserting, sorting or deleting rows

The trigger identifies each row by its position in the sheet (its row number), not by what the row contains. When SleekFlow checks the sheet, a row counts as updated if the content at that row number is different from the last check.

This means a row can start the flow even if nobody edited it. If a row is inserted above it, its content moves down to a new row number, so the content at the old row number has changed.

What triggers the flow

Keep in mind:

• It doesn’t matter how the rows move. Moving rows by hand, sorting, or letting another tool, form or script write to the sheet all have the same effect.
• A maximum of 250 rows start at once. If more than 250 rows change together, for example when you sort a long sheet, only 250 of them start the flow. The others never start it.
• Filters won’t stop this. Enrollment conditions check what’s in the row now. A row that moved still has real data in it, so it can still match. For example, if your flow only enrolls rows where payment status is “Paid”, every moved row with “Paid” is enrolled.

Example

Your sheet has a header row and data in rows 2 to 10. You insert a new row at row 5, so the sheet now has data in rows 2 to 11.

• Rows 5 to 10 now hold different data than before, so each of them starts this flow. That’s six flow runs, although you only added one row and didn’t edit any existing rows.
• Row 11 is the only new row number, so it starts the “A row is added in Google Sheets” flow, with the data that used to be in row 10.

Avoid unexpected enrollments

• Add new entries only at the bottom of the sheet your flow uses.
• Don’t insert, sort or delete rows in that sheet while a flow that uses it is published.
• To see the data in a different order, use a filter view in Google Sheets, which doesn’t change the row order.
• If a tool or form writes to the sheet, make sure it adds new entries as new rows at the bottom.