Google Sheets Trigger
Use Google Sheets events to set a trigger for workflow execution. To create an event for Google Sheets, complete the following steps:
1. Place the pointer on the start icon , and then click or double-click . A list of triggers appears.
2. Select Google Sheets. In the trigger configuration window, do one of the following:
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 following steps.
3. Edit the Trigger Label, if needed.
4. To add a Google Sheets connector type, refer to Supported Google Sheets Connector Types.
If you previously added a connector type, select the appropriate Connector Type, and under Connector Name, select the connector.
5. Click TEST to validate the connector.
6. In the Select Trigger list, select New Row. This event triggers when a row is created in the spreadsheet.
7. In the Spreadsheet Name list, select or specify the spreadsheet name.
8. In the Sheet Name list, select or specify the sheet name.
9. Under the Custom Filters section, click ADD, and then do the following:
a. Map the appropriate fields from the Trigger Data section to the Input field.
b. Select an appropriate value in the Condition list.
c. Set a value in the Expected field.
Click Add to add multiple custom filters. Click to delete any custom filter that you added.
For more information on custom filters, refer to Adding Custom Filters.
10. Click SAVE.
Was this helpful?