Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Google Docs (Google Drive)

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 SettingsApplications 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).

Google Docs Integration

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.

Google Drive integration for web forms

Our integration works very well with event registration forms and online surveys, when you need to share form entries quickly with other interested parties.

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.

Related documentation:
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?


  1. I connected my survey to google drive and got my spreadsheet… But users are allowed to come bak to the survey to change some infos and when it’s submitted again, infos doesn’t update in the drive spreadsheet… Could you help me with that please ? (I ran many tests)

    1. Hi Laurane,

      The Google Drive integration only sends information over to the spreadsheet on the initial submission. Editing an existing submission will not trigger a new one, so that updated information will not be sent over through the integration.

      The form would need to be submitted with the update info in order to generate a new row in the spreadsheet.


  2. If I put that new spreadsheet that was just created into a new folder, will 123 still send the data to it correctly?

    1. Hi Ryan,

      The spreadsheet can be moved into another folder. However, the Spreadsheet Name that is automatically generated based on the form name, will need to remain unchanged in order to correctly receive submissions.


  3. Hey Olivian ,
    I ‘m getting problem in sync my Google drive with smart phone which sometimes get automatically sync but sometimes it doesn’t.

  4. Hello,

    Some fields are missing in the googledocs sheet. For instance the field “comment” of my form does not appear in the googledocs. How to select field that will be updated in the googledocs?


    1. Hello,

      Thank you for reaching out to us.

      After integrating your form with Google Drive, all its fields should be sent to a spreadsheet automatically created in your Google Drive account.

      In case you encounter difficulties with this app, feel free to send us an email at support@123formbuilder.com and we will assist you on this matter.


    1. Hi Diego.

      Are you referring to a PDF file directly displayed on the form, or are you referring to PDF file uploaded through the form by the users?

      A PDF file can be attached to a form by using the Adobe PDF option of the Widget field form the Other Fields section of the editor. If you want users to upload a PDF file through the form you will need to add a File Upload field form the Basic Fields section of the editor.

      If you have any other questions, please don’t hesitate to contact our Support team at support@123formbuilder.com or via our contact form.


  5. Hello! Can you please help us.

    People who registered on our site, appeared in our google docs (excel doc). Now this doesn’t happen. Can you help with it, and tell why is it so, please?


  6. HELLO

    I had a nicely arranged Contact form that worked very well and the columns were all very nicely arranged to coincide with some other spreadsheet. I have since renamed the google spread sheet and deleted the old one. Unfortunately now I have a spreadsheet that the columns are now very different and there is one column for every option in the fields. Is there any way I can get back to the original format (of the columns). Can I just rearrange them in the google drive.

    Thanks for your time


    1. Hello Lee!

      Please follow our documentation highlighted below:

      The Google Docs (Drive) 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?

      Are you facing a similar case in any of the presented posts? If not, contact our support specialists at support@123formbuilder.com or via our contact form and provide details.


  7. I successfully connected 123form with my google doc and they worked about one year. But now my google doc stopped be updated. Why did it happen?

    1. Hello!

      We have updated the Google Docs application to Google Drive, meaning that the application needs to be removed and installed again on the form, as we no longer support the older version of the app. We have announced via email and our blog regarding these changes, but perhaps the message got spammed. May we suggest using whitelists as explained in our documentation at http://www.123formbuilder.com/docs/how-to-create-email-whitelists-to-save-important-messages/.

      This way, you will not lose any message coming from 123FormBuilder.

      For assistance or questions, don’t hesitate to contact our Support Team at support@123formbuilder.com or via Live Chat (9:00 AM – 5:00 PM GMT+2)

      We apologize for the inconvenience.


  8. i just install the google drive app. but in one of my forms i do have a four answers values(not only yes or no), but when i connected with the google drive app i only got yes or no values, need to to know why this is happening.

    1. Hello Rodrigo!

      If you use the Checkboxes field with 4 choices, each choice will represent a column in the Submissions section, as well as in your Google Drive account. The value Yes means the choice was selected by the form user, while No means that it hasn’t been selected. For Radio button and Dropdown fields, you’ll have a single column with the name of the field (header) and the name of the choice that has been selected by the form user.

      For more questions or assistance, please contact our Support Team at support@123formbuilder.com or via our contact form.


  9. I´ve recieved an email tha says “There was an error while sending data from the following submission to your (Google Drive) account. Form ID: 981087.” Idon´t khow which is the error. Can you help me please?

Leave a Reply

Your email address will not be published. Required fields are marked *