How to Integrate Form with Google Spreadsheet

Last Update: December 13, 2015

Google Docs is a freeware web-based office suite offered by Google within its Google Drive service. It also was a storage service but has since been replaced by Drive. It allows users to create and edit documents online while collaborating with other users live. 


Setting up an integration with Google Docs for your forms is quick and easy.  Please follow the steps below!


1. While editing your form into our form builder, just click "Integrations" button



3. Select "Document Sharing" from the dropdown and Choose "Google Spreadsheets Integration"



4. You will be asked to authenticate JotForm to access your Google Docs account. Click the "Authenticate" button:



5. Login to your Google account and click "Allow" button





6. Next, set a folder name where you would like this new Google Spreadsheet document to be created. 



7. Click the "Complete Integration" button to save the integration.



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. 


40 Comments...


   
stveri (April 23, 2013 at 10:24 AM)

We tried that function a week ago. First 3 submissions were pushed to Google Spreadsheet, but next submissions are stay only in JotForm db and are not synchronized to Google. Is that problem, that we changed the file? We added another column.

View Answer


   
ogrrecruitmentmgr (May 15, 2013 at 05:09 PM)

I'm having the same problem as stveri - Help!

View Answer


   
tigerbluelacrosse (May 20, 2013 at 12:47 PM)

Hello-
Can that google spreadsheet be on the same page/website as the jotform they fill in? Will the form be always updated on the site?

View Answer


   
laurahoots (June 06, 2013 at 01:26 PM)

I had the same challenge as well. Only the initial entry appears on the spreadsheet. Did anybody figure it out?

Thanks!

View Answer


   
jaegi (June 27, 2013 at 04:14 AM)

I made the Google spreadsheet integration and everything went fine even after modifying the table (I put some colour in the columns and made some others invisible, but didn't add or clear something or changed the order). Yesterday I recognised that new entries were not pushed anymore to the spreadsheet (what after the formatting worked fine that day). So I tried to cut and reeintegrate the sheet. This was a mistake, because the reintegration opened a new sheet, so I lost all the formattings. Today I see, that the entries of yesterdays test after all found their way to the formatted table over night. So the integration was not broken, it just took a break. My question now: ist it possible to reestablish the connection between the form and the existing formatted table, which is already embeded in other site? And do you think that my (just cosmetic) customizing caused the break?

View Answer


   
pckingpankaj (August 05, 2013 at 11:25 PM)

Awesome way & thanks a lot for all of this


   
QualityFoodWorld (November 11, 2013 at 02:48 AM)

doesn't work!!

View Answer


   
Betsy Modglin (November 26, 2013 at 02:38 PM)

I integrated a jot form with a google doc but now I can find the google doc but can't find the jot form. I signed in to the jot account I knew about but I must have had a different one because the form isn't in there. Can you tell me how I might find it? Thanks!

View Answer


   
salmanvadsarya (January 02, 2014 at 02:49 PM)

integration option not working

View Answer


   
Devin Quinn (January 02, 2014 at 03:09 PM)

Hi, I'd like to send different forms to different spreadsheets, however I'm not getting prompted to enter in a new spreadsheet name. How can I add a second or third one?
Also, is it possible to send two forms with different titles but same content to 1 spreadsheet?

Thanks, Devin

View Answer


   
schaefer76 (March 17, 2014 at 02:46 PM)

Is there a way to auto populate a form from these spreadsheets? For example, I want to use the drop-down to select a customer that I would have in the spreadsheet. Then I would like the other fields to be auto populated with what is in the spreadsheet. Is this possible? Or a another way of doing this? Thanks

View Answer


   
npp (March 21, 2014 at 12:33 AM)

I need to integrate the submitted data to Google Form.

I have been trying it for last two days. Only the initial first few data are pushed into the Google Spreadsheet. The rest are just empty.

Please help. Cos this is the only thing that prevent me from signing up the paid package (USD19.99).

I am still spending time trying to figure how to get it worked.

My form: http://www.jotform.me/npp/kelayakan

View Answer


   
cobair (May 18, 2014 at 10:41 PM)

Hi I am having trouble getting my form data to appear in Google Spreadsheets also. I also have it set up to integrate with Google Docs and a pdf file is created with all entries. The Google spreadsheet file is created but no data appears on submit. please help!


   
cobair (May 18, 2014 at 11:32 PM)

Scrap that - it seems to be working now. I deleted the folders from Google drive, disconnected the account and re-did everything and it now seems to be working!


   
rafiqkhas (May 21, 2014 at 03:28 AM)

above how can do it. to check individual response of form data.

View Answer


   
Ted Parker (July 07, 2014 at 06:29 PM)

Does this integration work with file uploads? e.g., if I'm using for job applications, can it send the resume and cover letter uploads to my Google Drive?

View Answer


   
daniellewis (January 02, 2015 at 01:06 PM)

Hi there,

I need a Google Apps Script to execute upon form submission. When I submit a jotform, the info gets added to a new row of the Google spreadsheet it’s linked to, but the “On Change” trigger I added doesn’t seem to activate. (It triggers properly when I make a manual edit to the spreadsheet). Does anyone have a solution or workaround for this? I think that it’s not triggering because of a bug in Google Sheets; see https://code.google.com/p/google-apps-script-issues/issues/detail?id=4391 . If my assessment is correct and you don’t have a solution/workaround, please star the issue linked to above in order to convince Google to fix it. Thanks.

View Answer


   
M732burke (February 02, 2015 at 07:18 AM)

I want to do the revers...I want to store info in a spreadsheet (like Google sheet) and have the form pull data from the spreadsheet to populate the form.
For example, when I enter an employee name, I want the form to retrieve the employee number, hire date, and rank I've entered on a spreadsheet. How do I create a field that goes to a lookup table and gets the correct line/cell of data?

View Answer


   
sptportuguesa (February 12, 2015 at 04:24 PM)

buenas tardes, tengo una duda. si le cambio el nombre a la carpeta que se genera automáticamente al hacer la integración con google drive, pierde la integración?????

View Answer


   
onurtikle (March 08, 2015 at 05:08 AM)

not working

openGoogleDocsWizard gives ILLEGAL error

View Answer


   
kyocera (March 20, 2015 at 03:05 PM)

The Google Sheet is created but form responses are not populating. The form is titled "KPTI Micro-Tools Regrinding Services Survey". Please help...thanks.

View Answer


   
events296 (July 01, 2015 at 10:12 AM)

I have successfully integrated my form submissions to a google spreadsheet. The problem is that some of my responses are not showing up in the google sheet, specifically the matrix drop downs. I have confirmed that they are being filled out and are being recorded on the form submissions on jotform.

View Answer


   
LCaraccilo (July 15, 2015 at 04:26 PM)

After Jot Form is integrated with Google Sheets, it collects the data from multiple forms into one sheet. I wanted to see if there is a way to have each Jot Form that is integrated with Google Sheets have its own Sheet that it collects the submissions to instead of all going to one sheet.

Or is there another tool I can use that it will do this? Please help!

View Answer


   
pteo (August 21, 2015 at 03:02 AM)

not working.
"sorry we couldn't create the integration"
Please advise

View Answer


   
aberadvisors (September 07, 2015 at 05:36 PM)

First couple 'push to sheet' work then it stops 'pushing'?

View Answer


   
aberadvisors (September 07, 2015 at 05:52 PM)

When I remove integration and then integrate again with the same information the new 'pushes' show up?

View Answer


   
minoxcz (September 10, 2015 at 10:58 AM)

Hi,

I want to use Google spreadsheet integration, but I have a problem with broken "submission date", there is a random number (attach pictures).

Here is complete question:
https://www.jotform.com/answers/658877-Spreadsheet-fails#0

2)Additionally, browser information is displayed in one big cell and occupy much space, it is possible that each data displayed in its own cell (shown in the attached pic) can be set/customize this somehow?

View Answer


   
Ibrahim John Kamara (October 02, 2015 at 05:44 AM)

I want to create a google form, bu i want the form to link to google spread sheets.

View Answer


   
uclamusicstage (October 12, 2015 at 07:40 PM)

If I make changes to the Google Spreadsheet, should those changes stick? Because every once in a while it seems the spreadsheet resets, and looses all the changes I've made.
I kinda need to be able to notate and track the info that comes from the form.
Thanks

View Answer


   
gowri (October 21, 2015 at 08:50 PM)

I am not able to integrate with google drive or with google spreadsheets. I am able to authenticate myself but after that when i click on "Complete Integration", It fails.

View Answer


   
Yeahdawgvegan (November 04, 2015 at 02:55 PM)

I am experiencing the same problem. Is JotForm looking into fixing this?

View Answer


   
Carol (November 05, 2015 at 12:21 PM)

When the form populates to a Google sheet, can I add columns to that sheet for comments, and if so, will that sheet still autopopulate from the jot form with my new columns and my comments? Thank you.

View Answer


   
mflanagan (December 10, 2015 at 03:01 PM)

One of my many forms automatically updated with the addition of more fields. Will all of the forms be doing this as well. I have others that I added fields to that are not automatically updating.

View Answer


   
colleen tomko (April 08, 2016 at 12:39 AM)

Thoughtful writing , Apropos , if someone are searching for a service to merge PDF files , my business partner merged a service here http://goo.gl/SU9g6n.

View Answer


   
Evan (April 26, 2016 at 12:28 PM)

Is there a way to change which columns get exported? i.e. I don't really need/want the IP Address or Submission ID.

View Answer


   
dapao (May 21, 2016 at 09:48 PM)

Cuando se integra al excel online se crea la linea para editar, puedo cambian que automáticamente salga el link y no el texto edit submission

View Answer


   
euney.kim (July 05, 2016 at 10:16 AM)

The form will not update automatically anymore and is very delayed. Any idea why this is happening?!

View Answer


   
RichmondProLab (July 07, 2016 at 12:12 PM)

We've set up our form responses to integrate successfully with Google Docs, but when viewing the spreadsheet in Google Docs, we're constantly getting messages saying "Working" or "Trying to Connect", making the form inaccessible. It pretty much says this constantly now, although it slowly seems to be pulling in new responses. Refreshing the browser only helps for a few seconds after the page reloads. Is there anything we can try to do to fix this? Is it on the JotForms end or the Google Drive end?

View Answer


   
hoosiercuse (August 10, 2016 at 10:11 AM)

I'm using the Orderable List Widget to have coaches rank the top 10 teams in their league. They have 50 schools to choose from. How can I calculate the overall tally so any first-place vote gets 10 points, a second-place vote gets 9 points, etc. Basically I just want to see the top 10 teams based on the scoring. When I open the Google spreadsheet I only get the ranking each team got. I could do this manually, but it seems like it should be easy.

View Answer


   
nzhoodieco (August 16, 2016 at 06:29 PM)

Hi. I have been having a problem with my google sheet integrations recently. The data in the google sheet is only showing the first one or two submissions and not all f the data. An example of this is currently my "Capital BB Orders" form and google sheet. It has had two submissions but is only showing the data for one customer. I originally hid some columns in the sheet so it only showed the Customer Name, but even when I unhide these the sheet doesn't have all the info. I am having similar problems with my other form integrations. Can you please help me work out what I am doing wrong?

View Answer


Send Comment