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 Recipe Builder.
Click the pencil icon.
Enter a Workflow name.
Note: GoFormz recommends that you 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.
Want to verify that your Workflow is set up correctly?
If you want to verify that your Workflow is correctly set up, complete the Workflow trigger you set up in Step 3 above.
Next, check the Workflow Jobs page in the GoFormz web app.
Here you’ll see if your Workflow succeeds.