Automatically add data transmitted from Forms to your connected Google Workspace with the "Add Form Data to Your Google Sheet" Workflow recipe.
🗒️ Note: This Workflow does not look for a unique identifier to map new data to existing data.
If you want to map to existing data, use the Upsert Row to Google Sheet recipe.
Before you set up this Workflow, you’ll need to connect Google Workspace. The connection you choose determines your options in the configuration details of this Workflow.
In the Workflows tab of the GoFormz web app click Create to access the Workflow Recipes Library.
Select the Add Form Data to Your Google Sheet recipe.
You’ll navigate to the Workflow Editor.
Click the pencil icon.
Enter a Workflow name.
Note: Include the Template name used in the Workflow in your Workflow name.
Establish your Form Completed trigger by configuring your Completed By & Template details.
Select the appropriate user-based trigger with the Completed By drop-down menu. Options include Anyone, Specific User, or Group.
Select the appropriate Template from the Template drop-down menu.
Establish your Add Row to Sheet action.
This action requires that you configure your Connection, Spreadsheet, Sheet, and Column Mapping.
Connection is a drop-down menu listing your available Google Workspace connections. Select from your connections.
Choose + Add Connection from the drop-down menu to add a new connection.
The Spreadsheet drop-down menu indicates the Spreadsheet Workbook where your new rows are added.
Sheet indicates the specific sheet tab where your new rows are added.
Map your Sheet Column Name from Google Sheets to your Sheet Cell Value with Column Mapping.
Your Sheet Cell Value can be a specific value, or a specific Field from your Template using Workflow Variables.
Click the Activation slider if you want your Workflow active immediately.
The Workflow Activation status displays as Active or Inactive.
Click Save.