Google Sheets Trigger
You can set a trigger for a specific workflow by selecting events from the trigger list.
Using Google Sheets Triggers
To use this trigger in your workflow, create a new event for the Google Sheets trigger, and then connect to the flow. To create a new event, do the following:
1. Place the pointer on the start icon , and then click or double-click . A list of triggers appears.
2. Select the Google Sheets trigger, and then create a new event. The Google Sheets trigger configuration window opens.
If a trigger is already created, select an existing trigger, and then click SAVE.
To create a new trigger, click Create a new event for Google Sheets, and then proceed with the steps further.
3. Edit the trigger label, if needed.
4. To add a new authorization, refer to the section Authorize Google Sheets in the Google Sheets connector topic.
If you previously added a Google Sheets authorization, select an authorization from the list.
5. In the Select Trigger field, select New Row trigger.
6. In the Spreadsheet Name, select or specify the spreadsheet name.
7. In the Sheet Name, select or specify the sheet name.
8. In the Custom Filters section, click ADD, and then enter the following details:
Expected—The expected output.
Condition—Condition to apply on the filters such as equals, greater than, less than, contains, does not contain, matches, and so on.
Click ADD to set multiple custom filtering criteria.
For more information on custom filters, refer to the topic Adding Custom Filters.
9. Click SAVE.