With Yoom, you can integrate with Google Sheets to automate various actions using app triggers.

This guide covers important considerations when using Google Sheets as an app trigger.

When running a trigger test, the system always retrieves the second row (the first data row below the headers), regardless of how many rows are in the sheet.

However, in live operation, the trigger activates when a row is added or updated, not just based on the second row.

👉 For more details: Google Sheets Trigger Testing Behavior - View Article

⚠ Important: If your Google Sheet directly reflects Google Form responses, the trigger will not activate due to system limitations.

👉 For more details: Google Forms & Google Sheets Trigger Limitations - View Article

If you set the trigger to "When a row is updated" it will NOT run when an entire row is deleted.

However, if a value is deleted from only the target column, the trigger will execute.

In some cases, after completing the Flowbot setup and turning the trigger ON, it may automatically turn OFF upon reloading the page.

When enabling the trigger, Yoom saves the original sheet data. If this process fails, the trigger is automatically disabled.

"[Yoom] An error occurred in the app trigger settings."

❌ No columns are set in the sheet

❌ Retrieving data takes too long, resulting in a timeout error

If neither of these apply, please contact the support team!

Even if you set the trigger to "When a row is updated", it may still execute when a new row is added.

If the new row added contains values in both the unique value column and the update detection column, the trigger will execute.

If the new row added contains a value in the unique value column but the update detection column is empty, the trigger will not start.

These are the key points to keep in mind when using Google Sheets as a trigger in Yoom.

For more details or troubleshooting, refer to these related guides: