Google Docs (alias Google Drive) integration allows you to send form submissions to spreadsheets. All submissions for one form will appear in the same spreadsheet.
You’ll find the Google Drive application in Settings → 3rd Party Apps section of your form. Add the application and hit the Connect button. You’ll be redirected to a separate page to add your Google account credentials (if not logged in).
When you check your Google Drive account after submissions were made, you will see that you’ve got a new spreadsheet with the name of your form showing each submission’s input on one row. The form data is not sent immediately, but after one to five minutes. If you change the name of the spreadsheet in your Google Drive account, the integration will no longer work properly.
Update July 6th: Until now, you had to type your Gmail address in the Google Drive application box each time you’ve added it to your web form. Starting from now, each Gmail address is saved so that you no longer need to type in the same address again, but rather select it from a drop down list (if more than one Gmail address is saved for the application within the 123FormBuilder account).
The counter displayed next to the name of the Google account specifies the number of times a new token has been created. A new token is created each time you choose the Connect another account option within the dropdown and type in a Gmail address that you already used.
Note: Make sure the first character of the form’s name (as displayed in My Forms) is not a space, otherwise each new submission will become a separate spreadsheet in your Google Docs account.
To change both the label names and the order of the columns in your spreadsheet, you’ll need to follow these steps:
1. First, change the label names and submit your form.
2. Reorder the columns in your spreadsheet and submit the form after you are done.
Following these steps will prevent the integration from failing. Make sure you have at least one submission made between step 1 and step 2.
The Google Spreadsheets integration doesn’t validate my login data. Why?
Submissions are not properly displayed in Google Docs (Drive). What to do?
My 123FormBuilder – Google Drive integration fails to work. Why?