Actions
SaveTo GoogleSheet Action
Save data to a Google Spreadsheet.
The SaveToGoogleSheet Action stores each submission data as a new record in the specified Google Drive Spreadsheet. Use it to store or log submissions.
Settings
| Setting | Description | Required |
|---|---|---|
| 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. |
Common Settings
| Validation | Description |
|---|---|
| Action Name | The name to reference this action. |
| Status | Defines if the action is enabled or disabled. |
| Execution | A list of conditions that must be met in order for the action to be executed. |
Mapping
Once the spreadsheet has been chosen, its columns will appear in the Content field ready to be mapped, being the column configuration pre-established by the sheet's first-row schema. The mapping will determine what value will be saved at what column of the record that is being saved or updated.
Not all columns require a value, in fact, mapping is disabled by default and must be enabled for each column independently. Once enabled the value can be inputted manually or dynamically with the use of the Dynamic Workflow.
| Setting | Description | Dynamic |
|---|---|---|
| Value | The value that will be mapped to the column. | ✓ |
Integration
- Create a Form Area and access it Settings Panel.
- Add a SaveToGoogleSheett action and fulfill the required settings.