Google Sheets Action

The Google Sheets Action creates and deletes records from Google Sheets spreadsheets. Use it to store data or log submissions.

Create Record

Creates a spreadsheet record.

Setting	Description	Required	Dynamic
Account	The Google account used to connect to Google Drive via OAuth.	✓
Spreadsheet	The Google Drive Spreadsheet to which to connect.	✓
Sheet	The Spreadsheet Sheet to use as the data destination, defaults to the first sheet.
Value Input Option	Defines how the data will be interpreted when saved to the spreadsheet. Raw, the values will be stored as-is, or User Entered, the values will be parsed as if were typed into the UI.
Advanced
Action Name	The name to reference this action.
Status	Defines if the action is enabled or disabled.
Execution	A composed condition that must be met in order for the action to be executed.		✓

Once the basic configuration has been set, the resource fields will load for mapping. The mapping will determine the value that each resource field will be created or updated with. Each field can be mapped to a static or dynamic value.

Most mapping is optional

In fact, mapping is disabled by default and must be enabled for each field by clicking on the last toggle icon.

Delete Record

Deletes a spreadsheet record.

Setting	Description	Required	Dynamic
Account	The Google account used to connect to Google Drive via OAuth.	✓
Spreadsheet	The Google Drive Spreadsheet to which to connect.	✓
Sheet	The Spreadsheet Sheet to use as the data destination, defaults to the first sheet.
Column	The column that will identify the record to be deleted.	✓
Value	The value that will identify the record to be deleted.	✓	✓
Advanced
Action Name	The name to reference this action.
Status	Defines if the action is enabled or disabled.
Execution	A composed condition that must be met in order for the action to be executed.		✓