| Section | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Step 1 - Obtain the Google Account Access token
If you do not have an access token for your Google Account, perform this one time step.
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
- Edit your form.
- Click the
what happens to my data? icon in the designer toolbar.
- Click on the Doc URI tab.
- Select the Save Submissions to a Google Spreadsheet wizard.
- This launches the Google Sheet Wizard.
- Login using your user id and auth token (from Step 1).
- A Spreadsheet dropdown appears listing all the spreadsheets in your Google account
- Select the Google Sheet from the list.
- Select the worksheet of your Google Sheet that you want to update with new submissions.
Click Finish on the Wizard
- That’s it. When the form is submitted, the data will be saved to the selected Google Sheet. You can perform all the usual operations on the data e.g. see the Graphs Tab in our example sheet and you can see how we have created some sample graphs to analyze our submission data.
Troubleshooting
"An unknown error has occurred" message
You may see the error message "An unknown error has occurred" when selecting your Google sheet from the dropdown after you log into the wizard with your Google account and access code. To prevent this, set the Share permission for your Google Sheet to private then run the Save to Google Spreadsheet wizard. Change the share permission to public once the wizard is completed. Click here for other reasons this error may occur.