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.
Enabling the Google Sheets integration sends every new result to a Google Sheets spreadsheet as a new row.
No, the integration will always update the first sheet (the first tab) in the connected spreadsheet file.
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.
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.
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.