A row is added in Google Sheets

The “A row is added in Google Sheets” trigger activates whenever a new row is added to the bottom of the selected Google Sheet. This allows you to automate actions in SleekFlow, ensuring seamless data updates and workflow efficiency. Rows inserted, sorted or deleted elsewhere in the sheet behave differently. 

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

• Send an automated message based on new data entries
  • When a new row is added with customer information, you can automatically send a personalized message via SleekFlow. This is useful for sending welcome messages, purchase confirmations, or event reminders.
• Sync custom data to SleekFlow’s custom objects
  • Automatically update SleekFlow’s custom objects with new data from Google Sheets, such as leads, orders, and payment details. This allows your team to access a complete view of customer information while chatting, enabling seamless follow-ups, automated messaging, and efficient workflow management.
• Manage coupon and voucher redemptions
  • If a new row is added with coupon redemption details, you can automate actions such as sending a confirmation message, updating the coupon status, or triggering follow-up campaigns. This ensures a smooth and automated redemption process for customers.

Set up "A row is added 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:

• Setup tab
  • 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
  • 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.
  • 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.
    
• Filter tab
• 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:
    • Order status column = “Pending” — only newly added rows with this status 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. A row only counts as new if its row number didn’t exist in the sheet before. In practice, this means a row only counts as added when it’s added below the last row.

What triggers the flow

Keep in mind:

• Inserted rows can cause repeat runs. When you insert a row, the last row of the sheet starts the flow, even though it was already in the sheet and only moved down. The flow can run a second time for a row it already processed, for example sending the same message twice.
• 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 you add more than 250 rows together, for example by pasting a large block, 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.

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.

• Row 11 is the only new row number, so it starts the “A row is added in Google Sheets” flow. It holds the data that used to be in row 10.
• The row you inserted (now row 5) doesn’t start the “A row is added in Google Sheets” flow.
• Rows 5 to 10 now hold different data than before, so each of them starts any “A row is updated in Google Sheets” flow on the same sheet.

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.
• To process a row the flow missed, add it again at the bottom of the sheet.