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.
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.
10. Click SAVE.