📝 Overview
Yoom integrates with Google Spreadsheets to automate various tasks. This article explains the behavior of Google Spreadsheet app triggers when they are tested.
👉 Details
With Google Spreadsheet app triggers, you can perform two actions:
When a row is added
When a row is updated
For both actions, during testing, the first row under the column headers will be retrieved. However, in the actual operation, the trigger will fetch the data from the newly added or updated row.
For example, suppose you have the following spreadsheet and set the trigger to activate when a row is added:
When you test, the value from the second row is retrieved, regardless of how many rows are present.
In production, the trigger will use the data from the row that was added or updated.
☝️ Note:
Please refer to the "How to set" caution at the top of the settings screen.
📚 Related Guides
App Trigger: Important Notes on Using Google Sheets as a Trigger - View Guide Here
Search Keywords
Search Keywords
Google, Google Sheets, Spreadsheet, GSS, App Trigger, Trigger