...
| Tip |
|---|
It is recommended that you set the Share permission for your Google Sheet to private then until you run the Save to Google Spreadsheet wizard. Change the share permission to public once the wizard is completed. |
...
The final step is to use the wizard to connect the form's submission to your Google spreadsheet.
- Ensure the Share permission for your Google Sheet is set to private.
- Click the
what happens to my data icon in the form designer's toolbar.
- The wizard launches and you will see three tabs labeled "Doc Actions", "Additional Email" and "Doc URIs".
- Select the "Doc URIs" tab.
- Click the "Save Submission to a Google Spreadsheet" button
...
- Enter your Google account username and the access token for your account, Click the login button. If you see the message "Invalid Credentials" click here for the solution.
- A Spreadsheet dropdown appears listing all the spreadsheets in your Google account
- Select the Birthday List
- Finally select the worksheet Sheet1
- Click Finish on the Wizard
- Set the Share permission for your Google Sheet to public.
Test the form
Now you are ready to test your form. Click the save and exit icon in the form designer. You’re back to the Forms Home Page. Click the “Test” button.
...