All Collections
Automation
Workflows
Google integrations
Set up an “Add Form Data to Your Google Sheet” Workflow recipe
Set up an “Add Form Data to Your Google Sheet” Workflow recipe

Add Form data as a new row at the end of your existing Google Sheet.

Updated over a week ago

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.

  1. Select the Add Form Data to Your Google Sheet recipe.

    Screenshot displaying the Add Form Data to Your Google Sheet recipe in the Workflow Recipes Library in the GoFormz web app.



    You’ll navigate to the Workflow Recipe Builder.

  2. Click the pencil icon.

    Screenshot displaying the location of the pencil icon in the Workflow Recipe Builder in the GoFormz web app.



    Enter a Workflow name.

    Note: GoFormz recommends that you include the Template name used in the Workflow in your Workflow name.

  3. Establish your Form Completed trigger by configuring your Completed By & Template details.

    1. Select the appropriate user-based trigger with the Completed By drop-down menu. Options include Anyone, Specific User, or Group.

    2. Select the appropriate Template from the Template drop-down menu.

  4. Establish your Add Row to Sheet action.
    This action requires that you configure your Connection, Spreadsheet, Sheet, and Column Mapping.

    Screenshot displaying the Add Row to Sheet configuration details in the Workflow Recipe Builder in the GoFormz web app.


    1. 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.

    2. The Spreadsheet drop-down menu indicates the Spreadsheet Workbook where your new rows are added.

    3. Sheet indicates the specific sheet tab where your new rows are added.

    4. 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.

  5. Click the Activation slider if you want your Workflow active immediately.

    Screenshot displaying the Activation slider’s location in the Workflow Recipe Builder of the GoFormz web app.



    The Workflow Activation status displays as Active or Inactive.

  6. Click Save.

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.

Screenshot displaying the location of the View Jobs link on Workflows page in the GoFormz web app.

Here you’ll see if your Workflow succeeds.

Did this answer your question?