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

Google Docs (Google Drive)

Google Drive integration allows you to send form submissions to spreadsheets. All submissions for one form will appear in the same spreadsheet.

Before integrating with Google Drive there are a few things that you should be aware of:

  • If you need to add your own spreadsheet column, add it after the last column generated by the form.
  • Do not delete any form columns.
  • Make test submissions after applying changes,  to update on both sides.
  • Selecting a group of cells and sorting/filtering data will break the integration.

You’ll find the Google Drive application in Settings – Applications 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 form, the integration will no longer work properly.

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.

* Important Note 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 test submission made between step 1 and step 2.

If the integration is not working correctly, click on the Remove button and add Google Drive again. A new spreadsheet will be created. The connection with the old spreadsheet can not be restored.

Google Drive integration for web forms

26 comments

    1. Hello Robbin! We are glad to hear that our article helped you solve your problem. Is the Juno Email issue related to our product?
      By the way, the link provided is not working.

    1. We’re glad you find our website helpful.
      Thank you for taking the time to share your experience with us!

  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.

      Thanks.

  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.

      Thanks.

  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?

    Thanks

    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.

      Thanks.

    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.

      Thanks!

  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?

    Thanx.

  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

    Lee

    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.

      Thanks!

  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://wix.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.

      Thanks!

  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.
    thanks

    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.

      Thanks!

  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 *

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?