...
...
...
...
...
...
...
...
...
...
...
...
| Section | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Step 1 - Obtain the Google Account Access token
...
Make sure the column header names match the Name property of each control. You can view the spreadsheet we created for the form above at this link (it’s read-only).
See how the column names are Name, Email, Street, City etc. The Name property of the corresponding control in the form is set to match exactly.
| Tip |
|---|
Google sheet column names are not case sensitive. So a column name “First Name” is equivalent to a column named “first name”. Also The column name on a Google sheet must match the control name. The matching is case-insensitive and any spaces in the column name are ignored. So “first name” is equivalent to "firstname".A control named "FirstName" matches a column header "first name." |
Step 4: Connect your form to your spreadsheet using the Save to Google Sheets wizard.
| Excerpt |
|---|
|
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.