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?