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

Please ensure your Google spreadsheet contains column headings that match each of the field names/questions contained in your form. The integration will fail if your spreadsheet is blank or column headings are not an exact match.

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

Configure the form integration settings

1. Open your form in edit mode and select the Form Settings tab.
2. Select Integrations > Google Sheets.
3. Click the click here link and follow the prompts to authorise Snapforms to access your Google account.
4. Once the connection is created, you need to complete the three fields in the Google Sheets integration settings using information found in your Google spreadsheet. The following image is an example only. Please obtain the required information from your Google spreadsheet.
5. Save your form.

Form submissions should now automatically appear as a new row in the configured Google spreadsheet as they are received.

Troubleshooting

If the integration fails to create records in your Google spreadsheet, please check the integration result and logs in the form responses:

1. In the Forms List, on the form click Actions > View Responses.
2. Mouse over the information icon to see the result.
3. To see the integration logs, click the View/Download button.

Delete Google account connection

Your Google account connection is saved so it can be used across different forms. Deleting a connection on one form 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 and select the Form Settings tab.
2. Select Integrations > Google Sheets.
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.

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