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.
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 Docs for your forms is quick and easy. On the Form Builder, click on Integrations button on the toolbar, and then to the Google Docs 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 Docs 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:
68 Comments:
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.
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
Hi, Does the while form submit to the google sheet, or can you control which data is pushed to the sheet?
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?
Can you send the Jotform data to automatically update more than one Google Drive Spreadsheet?
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!
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?
I have tried to edit the sheet in google to add custom charts etc.
However Jotform resets the sheetWe 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.
I've integrated google spreadsheets successfully in the past, but I'm currently unable to click on "integrations." Please advise.
Thank you
The date is not reporting on my google doc all the info is.
can we have the attachment link pointing towards the google drive instead of jot form?
e.g.instead of...'{link removed due to JotForm Blog rules}can we have:
{link removed due to JotForm Blog rules}
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.
Can I receive or send text to any cell phone if someone edit Google spreadsheet instead of email notification?
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?
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...
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.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?
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?
There is a big need to make calculations inside forms?
Does Jotform has any way to give numbers to multiple choices.
bf. MRB
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?
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.
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.
Plz help my integration with google drive spreadsheet is not working .
all fields are stills empty but submissions are added in jotform.plz help
Can I send automatic receipt confirmation to the person using the booking form that their entry has been received?
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.
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?
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?
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?
Wonderfull!
But only one Google Spreadsheet for FORM??
Can I have 2 GS view for one FORM?
Thank you
Marco
Hi,
I appreciate you to shared such a nice and very knowledgeable blog.Now i am trying to use and exploring the tools and testing out your services.Its very interesting and useful.You are great.Keep it up.