Save results to Google Sheets

Free trial
All Features

Google Sheets integration made easy

Publish results for use with other applications or partners, providing them limited access to your data in a convenient format, including the ability to leverage Google's features by sharing your spreadsheet
Insert results from Formsite into your Google Docs spreadsheets or a G Suite Shared Drive
Apply our results views and results filters to only insert the data you want
Easy setup—once your form is connected to Google Docs, Formsite will start inserting results automatically
Automatically inserts results into spreadsheets in real-time
Result updates are handled live and show up in your spreadsheet instantly

Save your form results into Google Sheets. Easily create an extra backup of your results or use the Google Sheet to share your results with others.

Simply connect your Google account and your results will automatically fill into the Sheet you choose. You can also customize which results and items on the form will be saved.

Share your Sheets using your G Suite Shared Drive for great team collaboration.

Another helpful feature to try is the ability to import export data with online forms.

Common Questions

How does the Google Sheets integration work?

Enabling the Google Sheets integration sends every new result to a Google Sheets spreadsheet as a new row.

Can I send the results to a different sheet in the spreadsheet file?

No, the integration will always update the first sheet (the first tab) in the connected spreadsheet file.

Can I reorganize or style the data in the spreadsheet?

Customizing the first sheet is discouraged because it makes the file larger and may cause problems with syncing data. The recommendation is to make a 2nd sheet (a 2nd tab) and reference the first sheet’s data, then style or reorganize the data on the 2nd sheet.

What happens if the columns don’t line up anymore?

If the form items change (new ones added, old ones deleted, or labels change) the columns won’t line up correctly. The column headers are added when the file is first made, but once there are headers in the file then new results are added as new rows. You can make a new sheet (new tab) and move the empty sheet to the first position, then the column headers will be remade when the next result is received.

I sometimes get an error message. What does that mean and how do I fix it?

The first thing to do when an error is received is to edit the result in the Results Table and click the Update button. That retriggers the integration and if the error does not appear then the transfer was successful. You can manually set the result’s Status to ‘complete’ by clicking the icon and choosing the correct one.

If you still see the error, you need to follow the instructions for verifying the authorization on the Form Settings -> Integrations -> Google Sheets page. If the error is ‘read timed out’, that means the Google Sheets file has become too large and you need to enter a new file name in the integration settings to create a new file.