We are very excited to announce the new integration with Google Docs. You can now get Jotform to send form responses to a Google Docs spreadsheet instantly.
What I love about this integration is that it is so unbelievably fast. When you submit a form, the entries show up on your Google Docs spreadsheet before the thank you page is rendered fully on the other window.
Pro Tip
Already use Google Sheets? Create a powerful online form with Jotform and connect it to your Google account to keep all your submission data in one place.
Jotform development team uses Google Docs daily to track things and discuss ideas. So, we are very excited about this integration. I have personally stopped using Excel/Word many years ago and I’ve been using Google Docs instead. It is fast, simple and available on any device I use.
This integration is especially great for Jotform users who wanted to create advanced reports with their form submissions. Google Spreadsheets has many great features such as gadgets, charts and calculations from data.
Setting up an integration with Google Sheets for your forms is quick and easy. On the Form Builder, click on Integrations button on the toolbar, and then to the Google Sheets option.
On the first screen of the wizard, you will be asked to authenticate Jotform to access your Google Docs account.
Next, choose a folder name where you would like this new Google Spreadsheet document to be created. You may also change the name of the document on this step.
That’s all. Your integration is all set, and a file should be created on your Google Sheets already!
When you receive submissions on your form, they will be instantly pushed to this file.
Give it a try today! And let us know if you have any comments, questions or suggestions.
Send Comment:
75 Comments:
More than a year ago
This article is confusing due to the writer using “Google Docs” instead of Google Sheets. The function being described is connecting forms to capture submissions into a Google Sheet (not a Google Doc).
More than a year ago
This is great! Can you tell me if this can be done with a CSV file. I'd like to end with a CSV file in Google Docs that gets added to every time our JotForms get submitted.
More than a year ago
This is not working for me. Can someone help? I am following exact instructions - the Title of Questions is showing in Google Sheet but none of the answers.
More than a year ago
The form gives us very usefull information to collet from the field itself.
However if some gues have filled the jot form and entries are listed into the google sheet.
and on the other side if I have already a data into the excel sheet and I wanted to update the same also in same response sheet, and the same validation which I have set while creating Jot Form wants to apply in the whole data which I have inserted at one go in the response sheet without entering anything into Jot Form,
Not finding any solution on this
More than a year ago
IT IS NOT SHOWing me the form answers in google sheet it is only giving me submission date ip submission id. what am i doing wrong?
More than a year ago
Disregard my last comment - I just realized the link is at the end of the sheet.
More than a year ago
Is there a way to have the Jotform update link added to the submission in the Google Sheet?
EX) Columns across the top: "Name", "Email", "Phone #", etc..., "Update Link"
More than a year ago
Hello, i tried to using addons autocomplete in jotform and then extracting it to google spreadsheets. When i tried to extract it the value for that autocomplete text become blanks and doesnt collect the email address. Can somebody help me to solve this?
More than a year ago
let say we modify the form in jotform . how can we make the updated fields reflected in the googlesheet?
More than a year ago
Hi, when I set up the integration, I only get "submission date" "IP" "Submission ID" and "Edit Link" but no additional information such as responses from the survey takers. Anyone?
More than a year ago
Hello. If I've deleted several form submissions from Jotform (we deleted test forms that we were trying out), will it remove the info from the deleted forms from the integrated Google Sheet? I just deleted about 6 submissions from Jotform, but my Google Sheet still contains the deleted information. Please advise.
More than a year ago
Hey, after adding my products on the form the submission data doesn’t fill into the google spreadsheet. If you ignore the product field, it does. I’m confused what the issue is
More than a year ago
Hi, Does the while form submit to the google sheet, or can you control which data is pushed to the sheet?
More than a year ago
Hi, I'm currently building a sheets app to organize the Jotform data onto a formatted document and I had a question regarding how the Jotform Spreadsheets Integration API works. I plan on the sheets app organizing the Jotform data automatically through triggers (onEdit) as it comes in, but that may not work if the Jotform API uses Google Spreadsheets API to edit the form directly. Can you briefly explain how the Jotform API inputs data into spreadsheets?
More than a year ago
Can you send the Jotform data to automatically update more than one Google Drive Spreadsheet?
More than a year ago
I had a working google doc integration which broke (I think because I moved the Google Folder). I am trying to reintegrate and am now getting a failed integration message or it is telling me it is integrated to an undefined spreadsheet. Help!
More than a year ago
I have integrated the form with google docs. However, if I add a column, future submissions are not posted to the right column. How can I have my submissions data map to the correct fields?
More than a year ago
I have tried to edit the sheet in google to add custom charts etc.
However Jotform resets the sheetMore than a year ago
We have been integrated with google spreadsheets for some time. The integration seems to have broken a bit in the past week however, as the form no longer passes the date of submission to our spreadsheet. All other data is still being uploaded to our sheet however. We just have a blank column for the dates of forms submitted in the past week or so. Please advise.
More than a year ago
I've integrated google spreadsheets successfully in the past, but I'm currently unable to click on "integrations." Please advise.
Thank you
More than a year ago
The date is not reporting on my google doc all the info is.
More than a year ago
can we have the attachment link pointing towards the google drive instead of jot form?
e.g.instead of...'can we have:
More than a year ago
What if we already have a Google Doc that we would like to start incorporating this into? Is it possible to do that or is the only way to create a new doc? The reason I ask is that we have some analysis logic in the spreadsheet that helps us analyze responses we get.
More than a year ago
Can I receive or send text to any cell phone if someone edit Google spreadsheet instead of email notification?
More than a year ago
Hello thank you I figured all of that out.. BUT now how can I re-submit all these forms so that they are now in my new email address? Because now that all the things are on the new email drive, the forms are of course empty!!
The only thing I can think of doing would be to share from my old email address?
More than a year ago
Hi!! So, I originally made a Wedding contract, and intergraded it with Google Docs ( worked perfect) I then went a step futher and duplicated ( made a copy) of the wedding contract and then Changed it and its contents to my "Boudoir" contract.. It is now sending all of my boudoir contracts to the wedding documents Google Doc Folder and stressing me out!! HELP? Also I would like to change it from the current email to my new business email...
More than a year ago
The Google Drive and especially Google spreadsheets integration is very useful. However is there anyway to get a submitted image to actually display in the Google spreadsheet instead of having only a link? (Perhaps in a thumbnail format?)
Thanks.More than a year ago
My form is currently connect to a Google Doc folder, but I can't figure out where this folder exists. It is possible it is connected to someone who no longer works here. I need to be able to manage the responses through Google Docs. Is there any way you can un-integrate it, then re-integrate it to my Google Drive?
More than a year ago
Can I have a check box with multiple selections trigger multiple submission in order to generate multiple submission lines in the google spreadsheet, each with only one of the selected options showing?
More than a year ago
There is a big need to make calculations inside forms?
Does Jotform has any way to give numbers to multiple choices.
bf. MRB
More than a year ago
How may I have the data that is filled through a particular form to go to multiple spreadsheets according to the input, or to different sheets in the same spreadsheet?
More than a year ago
Hi guys,
Not sure what the above problem was (might be that I was working via Remote Host), but have switched PCs and the authentication has now gone through. Very impressed with the initial results, especially considering Jotform is free - have to commend you for your good work.
More than a year ago
Hi there,
I started compiling a form and am impressed with how user-friendly your tool is. However, when I go to authenticate my Google accounts (Drive and Spreadsheet)and Accept Jotform's request for access permissions, I'm greeted with a blank page. I've tried all my browsers (IE, Chrome, Firefox, Safari), both signed in and out of my Google accounts, but with the same result. Could you please help me discover what is going wrong, as it is enormously frustrating to have such a potentially-useful tool fall short at the last minute.
More than a year ago
Plz help my integration with google drive spreadsheet is not working .
all fields are stills empty but submissions are added in jotform.plz help
More than a year ago
Can I send automatic receipt confirmation to the person using the booking form that their entry has been received?
More than a year ago
I'm getting a lot of Chinese text/graphic. How do I get rid of it. The table is in English, but the headings above the table are in some kind of language.
More than a year ago
Hi,
I'm also getting the problem that it does not bring submissions to the google doc after the initial set up. The first time I open it, I see the submissions in the excel. But after that, it doesn't refresh instantly.
Can you please help?
More than a year ago
Is it possible to have a user fill out the form, then make a payment while in the form - and have the form determine if the paypal payment was successful, and then record all the data and the approval/failure of the payment into a google doc?
More than a year ago
I need clients to "lookup" old data and display the form with the data so they can check it, make revisions and RE-save the form data. How can I create something that does this lookup and then displays the form with the existing data?
More than a year ago
Wonderfull!
But only one Google Spreadsheet for FORM??
Can I have 2 GS view for one FORM?
Thank you
Marco
More than a year ago
The integration worked...I think...but the answers are not showing up in my Google doc.
http://form.jotformpro.com/form/23299010988967More than a year ago
I am trying to collect visitor contact information with my jotform and transfer it to my Google contacts. Is there a way to get my jotform contact list into my Google contacts? Or, am I able to setup the Google docs spreadsheet created from my jotform to import cleanly into my Google contacts? I used the created Google docs spreadsheet and exported to a .csv file then imported to my Google contacts. It got the first & last names and emails in the correct fields but it dumped just about everything else into the "notes" field in my Google contacts?!?
More than a year ago
Google doc form -Is it possible mail has to trigger to user when i edit concern row of spread sheet.
More than a year ago
Google Docs Integration is great!!
But when I use the submissions data to create a googleMap widget, it can't be publish in Free text with html codes.Any suggessions?
More than a year ago
Jotform is pretty neat. This is complementary to what we have done at delighta.com. You can enter data in your Google spreadsheet via SMS from as many mobile phones as you want. We believe we are the first company to successfully integrate SMS with Google spreadsheet and calendar.
More than a year ago
Would I be able to send responses from multiple forms to the same spreadsheet?
More than a year ago
One of the advantages of the google integration "workaround" you proposed in an earlier post (Jotform HTML report updated every n minutes) is that the first row of the spreadsheet is empty, the form header starts on row 2 and the spreadsheet fills from row 3 down. This very convenient as I can test for the number of entries in a column at the head of the column and use conditional formatting to indicate that I've exceeded capacity in a class.
Can the starting row of the Jotform Google Docs integrated report be specified to allow the same functionality without interfering with the subsequent automatic data entry?
More than a year ago
Also, is there some sort of settings I have to adjust to the Google spreadsheet. When I fill out the Jotform, the data is not pushing to the Google spreadsheet.
More than a year ago
Can you move the folder that is created (i.e. I want to place the Jotform folder for registration for our golf outing into the Golf Outing google docs folder)? Or, does it have to remain outside any subfolder to map the data correctly?
More than a year ago
Great..i just tried it and it works great~ Make sure you are already logged into your gmail account..i think this might help some.
More than a year ago
this is phenomenal! thank you! i have been transferring manually to my excel spreadsheet and it can be tedious. awesome!
More than a year ago
This is halfway working for me. It only fills out some of the questions on my G Docs spreadsheet. The Jotform email I get has everything filled out but multiple fields don't go through to the spreadsheet.
More than a year ago
Umm... can't authenticate for google docs. Click on the green Authenticate button and I get this:
Error: redirect_uri_mismatch
The redirect URI in the request: https://www.jotform.com/api/google/ did not match a registered redirect URI
More than a year ago
I want this service
More than a year ago
Is it possible to link multiple forms to a single Google Docs Spreadsheet, but on different sheets? this comes in handy when people use google apps script, and need the same code for multiple spreadsheets
More than a year ago
Very Good !!! Excellent.
More than a year ago
Google drive is part of google docs... two different things... I'm still wanting support for google drive to have form attachments go to google drive, just like they do for dropbox.
More than a year ago
Great!
Still would love to see a Calendar sync option. Where the customer can pick time slots and it would update google calendar.More than a year ago
This is GREAT news!! Nothing better than integration all in one place none stop rock in shop. I Love it.
More than a year ago
I love that this integrates with Google Docs! Thanks for adding that feature!
Since integrating, I've added some new sections to my form, which are not showing up in my Google Doc. I'd rather not reintegrate because I spent a lot of time personalizing the Google Doc, so I'm wondering if there's something I need to do to for the new sections of the form to show up.
thanks!
More than a year ago
Not getting any results here either. All I see is submission date
More than a year ago
LO NECESITABA HACE TIEMPO.
Justo lo que buscaba Gracias DIOS
TE AMO
More than a year ago
can you integrate several forms into one google doc? I have a form for Canadian payments and one for US would love to itegrate these into one google doc.
More than a year ago
Hi,
I am exploring the options of using jotform on a professional level and are testing out the service before I purchase a business account for 50 dollars a month.
I created the form ( very surprised how easy it was) and after the google docs integration (that went through as well) the responses dont get parsed to my google docs account. (only once!)
I tried linking it to a different google drive account but with both instances the result of the form only gets registered once.
Again, please let me know if I can help or I am doing something wrong!
//Peter
So when I re-use the link and fill in new data the data doesnt show up in google docs.
Is am happy to present some examples and invest time in fail searching and (as I explained earlier), when stable and functional I am going to use this service on a professional level.
More than a year ago
I've connected my form to google. When I did it, the submissions I had appeared on my google spreadsheet but I'm not getting any of the new submissions on it. Did I do anything wrong?
More than a year ago
i am testing this right now. i am editing a submission using the edit link sent from an autoemail email. but it seems that the edits of an already submitted are not reflected in gdocs. any steps i missed out? thanks
More than a year ago
love it, no more downloading the files. yeaaaaah
More than a year ago
really really nice!! You guys just keep adding features. Awesome. Thanks a lot!!
More than a year ago
Can we customize this at all? I have an order tracking spreadsheet that I currently use. It uses a Google query in the URL to show only rows based on client information they submit. As orders come in through jotform I manually enter them into my Google spreadsheet. Users can then enter their account number and see all active orders they have submitted.
I would love to be able to customize the way Jotform integrates with the spreadsheet and even better, have it add to my current document.thanks.
More than a year ago
It is still Google Docs for me. :) Mine is not upgraded yet but I'm happy with it.
More than a year ago
When viewing the submissions in the google "drive" spreadsheet view, can you edit them and then see the changes reflected on the Jotform site when viewing there? Or is the information flow only one direction?
More than a year ago
EGGGGSSSactly what I was hoping for...more advanced reporting!!!!
More than a year ago
I'm getting an error message that says "Error: redirect_uri_mismatch" when I click the "Authenticate" button. I accessing my forms through the Jotformpro.com url.
More than a year ago
Great! Though Google Docs is not with us anymore. Has become "Drive" now.
More than a year ago
This is very cool, but it's not working for me.
I Click Authenticate and then Click the Blue Google Allow button.
Then it asks for Folder and Filename which I leave as default and then press next.
It sits there for 10-15 seconds then comes back with this error.