The 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:
You’ll find the Google Drive integration in the Integrations 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.
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.
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 Notes
To change both the label names and the order of the columns in your spreadsheet, you’ll need to follow these steps: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.
Related articles
Your email address will not be published.
Here is a list of the most frequently asked questions. For more FAQs, please browse through the FAQs page.
Is there any way to backfill the google sheet? I set up the sheets connection after people completed the form.
Hello Tyler, any application added to a form will start sending the information submitted only after the integration has been enabled. We cannot send the data of the submissions made prior to that. What we can recommend in this case would be to export your submissions to CSV, copy the older submissions, and paste them into your spreadsheet. However, please make sure that you add the information to new empty rows and avoid adding any new columns, as this might break the integration. I hope this helps and please feel free to contact us at customercare@123formbuilder.com if you have further questions.
The article is really impressive as I didn’t know about it but I really appreciate you for this great article.
Thank u soo much for the useful informations for the beginners like me
My Google Drive was working very well. By the way, today it’s not submit anymore. I deleted the aplication, also the googlesheet from my google drive, and I tried it again, but it’s not work anymore. Is there any error with google drive aplication today?
Hello Rafael, we encountered an issue with our Google Drive integration but our developers fixed it right away. Now your spreadsheet should be populated with new entries. If not, please contact us at customercare@123formbuilder.com to further check your connection.
Have a great weekend!
Is there a way that the form report will automatically be generated to a pdf or google docs format and uploaded? Sometimes the excel/spreadsheets format is cumbersome and doesn’t show certain elements such as signatures and special characters. I understand the spreadsheets format is useful for reporting and sorting information, but is there another report format that isnt spreadsheets?
Hi Tyler! You can create custom reports, save them as PDF, publish them on your website, create many reports filters, etc. Unfortunately, in reports we can not display signatures because they are images. Please check our knowledge base category on reports for more details: Reports
I have used this application for a few years and I have never had a problem (or very little). So, I built my order system based on this link between forms and google sheets. Unfortunatly, everything to stoped working this morning … Customer service tell me that effectively, there is a problem but that it does not know what is the problem, the causes and strategies to fix the whole thing. .. This causes me a lot of worries since I have to fall into manual mode for an indefinite period. It’s really frustrating!
Hello David! First, let me apologize for this unfortunate inconvenience. For a few hours, the integration had a technical issue. Our developers fixed the problem and now the integration is working properly. For the submissions that weren’t imported, you can manually insert them on a new row. This action will not mess up the integration. After that, the new entries will be automatically added after.
CAN I UPLOAD FILES TO GOOGLE DRIVE?
Hello, the files uploaded through our file upload fields will show up in the spreadsheet as hyperlinks. Fromm there you can download them.
This is the great information about Google Docs, I was facing the problem because my account did not sync to the google docs. after reading your blog and comment section I solved my problem.
If you are facing issue in Juno Email Error Code 17 don’t hesitate to check the visit. http://www.emailhelpdesk.co/juno-email-error-code-17/
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.
Your article is very useful and has good knowledge. I appreciate your efforts and all the best. It’s very useful information. I will be waiting for your next post.
We’re glad you find our website helpful.
Thank you for taking the time to share your experience with us!
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)
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.
If I put that new spreadsheet that was just created into a new folder, will 123 still send the data to it correctly?
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.
Hey Olivian ,
I ‘m getting problem in sync my Google drive with smart phone which sometimes get automatically sync but sometimes it doesn’t.
Hello,
Thank you for reaching out to us.
You will need to be logged in your Google Drive account when integrating the form with it or log into it at that time. Here you can find more details about our Google Drive integration: https://www.123formbuilder.com/docs/google-docs/
If you need further assistance, please do not hesitate to contact us at support@123formbuilder.com.
Thanks,
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
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.
Good morning,
Can I attach a .pdf file?
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 page.
Thanks!
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.
Hello!
The form data is sent within a 5 minute-period. Have you later checked your spreadsheet to see if the information is there? If not, please contact our support specialists at support@123formbuilder.com or via our contact page. Specify your browser, operating system and device to help the investigation.
Thanks!
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
Hello Lee!
Please follow our documentation highlighted below:
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 page and provide details.
Thanks!
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?
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 https://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.
Thanks!
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
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 page.
Thanks!
i can´t connect my google drive with my surveys. i just got a blank document.
thanks
Hello Rodrigo!
Have you tried removing and adding the app again on your surveys? Please contact our Support Team via our contact page for assistance. They will get back at you as soon as possible to fix the issue.
Thanks!
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?
Hello Matias!
Please contact our Support Team regarding this problem at https://www.123formbuilder.com/contactus.html. They will help you right away.
Thanks.