Author

Profile Image Aytekin Tank is founder of JotForm. He currently leads the JotForm development team. He loves to hear from Jotform users. Feel free to shoot him an email to him at aytekin at jotform.com.

The companion blog to JotForm, the easiest web form builder.

Google Docs Integration: Send Responses to Google Spreadsheets. Instantly.

May 07, 2012
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. 

JotForm google docs integration

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. 

jotform google docs integration




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.

google docs integration with jotform


On the first screen of the wizard, you will be asked to authenticate JotForm to access your Google Docs account. 

google docs wizard


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. 

google docs wizard


That’s all. Your integration is all set, and a file should be created on your Google Docs already! 

google docs wizard


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. 

You have already voted for this item. Your vote was: 1

42 Comments...
   
Jonathan Hinchliffe (May 07, 2012 at 11:46 AM)

Great news, just one question tho.......

Can the submission still be e-mail to specific users aswell as adding to the google docs spreadsheet.

thanks

kind regards,




Jonathan

View Answer

   
DarkUFO (May 07, 2012 at 11:48 AM)

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.

http://img802.imageshack.us/img802/514/screenshot2012050716471.png

View Answer

   
Adrian (May 07, 2012 at 12:01 PM)

Great! Though Google Docs is not with us anymore. Has become "Drive" now.

   
DJ (May 07, 2012 at 12:32 PM)

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.

View Answer

   
robertgo (May 07, 2012 at 12:37 PM)

EGGGGSSSactly what I was hoping for...more advanced reporting!!!!

   
CTSemAdmis (May 07, 2012 at 12:39 PM)

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?

View Answer

   
aytekin (May 07, 2012 at 01:18 PM)

It is still Google Docs for me. :) Mine is not upgraded yet but I'm happy with it.

   
chiseled_images (May 07, 2012 at 02:44 PM)

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.

View Answer

   
diaconaalsteunpunt (May 08, 2012 at 02:29 AM)

really really nice!! You guys just keep adding features. Awesome. Thanks a lot!!

   
mskrock (May 08, 2012 at 08:53 AM)

love it, no more downloading the files. yeaaaaah

   
felipe_sasa (May 09, 2012 at 06:32 AM)

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

View Answer

   
murriza (May 09, 2012 at 12:38 PM)

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?

View Answer

   
Verhoop (May 09, 2012 at 02:58 PM)

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.


View Answer

   
region1convention (May 09, 2012 at 04:57 PM)

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.

View Answer

   
TGianmarcoT (May 11, 2012 at 05:54 PM)

LO NECESITABA HACE TIEMPO.

Justo lo que buscaba Gracias DIOS

http://jotformz.com TE AMO

   
internetweek (May 11, 2012 at 06:51 PM)

Not getting any results here either. All I see is submission date

View Answer

   
tampopo (May 12, 2012 at 07:12 PM)

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!

View Answer

   
wpdmedia (May 12, 2012 at 10:57 PM)

This is GREAT news!! Nothing better than integration all in one place none stop rock in shop. I Love it.

   
cychorus (May 14, 2012 at 02:13 PM)

Great!
Still would love to see a Calendar sync option. Where the customer can pick time slots and it would update google calendar.

View Answer

   
405media (May 15, 2012 at 02:52 AM)

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.

   
Станислав (May 15, 2012 at 06:19 AM)

Здорово!
Давно пора =))

   
victorataide (May 15, 2012 at 08:29 AM)

Very Good !!! Excellent.

   
sander_j4s (May 15, 2012 at 08:59 AM)

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

View Answer

   
darnold953 (May 15, 2012 at 10:04 AM)

I want this service

   
kl.vanw (May 15, 2012 at 02:35 PM)

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

View Answer

   
Kevin Pierce (May 17, 2012 at 08:27 PM)

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.

View Answer

   
Laura Bowman (May 20, 2012 at 09:32 AM)

this is phenomenal! thank you! i have been transferring manually to my excel spreadsheet and it can be tedious. awesome!

   
shay3624 (May 23, 2012 at 06:06 AM)

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.

   
geneseepharmacists (June 05, 2012 at 09:52 AM)

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?

View Answer

   
geneseepharmacists (June 05, 2012 at 10:10 AM)

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.

View Answer

   
halh (July 11, 2012 at 04:42 PM)

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?

View Answer

   
Mo Nabil (July 19, 2012 at 07:58 AM)

Would I be able to send responses from multiple forms to the same spreadsheet?

View Answer

   
Suyog Bhobe (August 03, 2012 at 08:09 PM)

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.

   
guppyd (August 17, 2012 at 01:00 AM)

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?

View Answer

   
Ankush (August 25, 2012 at 04:44 AM)

Google doc form -Is it possible mail has to trigger to user when i edit concern row of spread sheet.

View Answer

   
LBCTruth (August 29, 2012 at 02:27 PM)

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?!?

View Answer

   
nhankwitz (November 26, 2012 at 04:59 PM)

The integration worked...I think...but the answers are not showing up in my Google doc.
http://form.jotformpro.com/form/23299010988967

View Answer

   
Dissertation Writing Service (December 07, 2012 at 05:20 AM)

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.
Dissertation Writing Service

   
guest_30133310276036 (January 17, 2013 at 05:33 AM)

Wonderfull!

But only one Google Spreadsheet for FORM??
Can I have 2 GS view for one FORM?
Thank you

Marco

View Answer

   
sbrand (March 20, 2013 at 05:38 PM)

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?

View Answer

   
Bill Lincoln (March 28, 2013 at 01:52 AM)

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?

View Answer

   
jeweloh (May 20, 2013 at 11:01 AM)

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?

View Answer

Send Comment