Google Sheets Integration

The Google Sheets connection is one of our popular integrations for sending form responses automatically to a spreadsheet, each time your form is submitted.

Note: We do not take responsibility for your data if you choose to send it to Google Sheets. Data hosted by Google may not be stored within Australia. Google Sheets templates and MS Excel are not supported.

How does the Google Sheets integration work?

When a respondent submits a completed form, their responses are automatically added to your Google Sheet. A new row is created for each submission.

For more advanced integrations with Google Sheets, we recommend you use Snapforms’ Power Automate integration.

How to set up a Google Sheets integration

Before you start

This guide assumes you’ve already created your online form using the drag-and-drop form builder. 

Your Google spreadsheet must contain column headings that exactly match your form fields. Blank sheets or mismatched headings will cause the integration to fail.

Tip: A quick way to get all the form fields is to export responses to CSV (Comma-Separated Values) file and copy/paste the header row into the Google spreadsheet.

If you want to sync the date of each form submission, you will need to include a ‘Date’ column heading in your Google spreadsheet.

Enable Google Sheets integration and link account

1. Open your form in edit mode.
2. Navigate to the Form Settings tab > Integrations.
3. Select the Google Sheets checkbox.
4. If this is the first connection, click the click here link and follow the prompts to authorise Snapforms to access your Google account.
5. To connect to a different Google account, click + Add New Connection.

Configure the Google Sheets integration settings

1. Using the information in your Google spreadsheet, enter the Spreadsheet ID, Tab Name, and Header Row Number.
2. Check the column headings in your Google spreadsheet matches your form fields. Blank sheets or mismatched headings will cause the integration to fail.
3. To start syncing all submissions to your Google spreadsheet, scroll to the top and click Save.

The following image is an example only. Please obtain the required information from your Google spreadsheet.

(Optional) Use conditional logic to run integration

Instead of syncing every submission, you can apply conditional logic that triggers the integration only when specific criteria are met. This allows you to filter syncs based on responses, or completion of workflow steps.

To control when the integration runs:

1. Tick the Run only when responses match these conditions.
2. Choose to run the integration if All or Any conditions match.
3. Select a form field, or a workflow step (if configured).
4. Select an operator, e.g. is, is blank, greater than, etc. Note: This list will vary depending on the selected field type.
5. Enter a specific answer required to trigger the integration.

Once finished, scroll to the top and click Save. Response data will automatically sync to your Google spreadsheet upon form submission, subject to any conditional logic rules.

Troubleshooting

If your data isn’t appearing in Google Sheets as expected, check the Response Activity Logs for errors and retrigger the sync.

Deleting a Google account connection

Your Google account connection is saved so it can be used across different forms. If you delete an existing connection on a form, this may cause other forms to fail to sync with their configured Google Sheets. 

To delete a Google Sheets connection:

1. Open your form in edit mode.
2. Navigate to the Form Settings tab > Integrations.
3. In the Connections section, click Delete Connection (red link) on the connection you want to delete.
4. The system will run a check to find forms that are using this connection.
5. Click Confirm Delete.

If you have any issues, please feel free to get in touch with us for support.