User Guide

How to Integrate Form with Google Spreadsheet

Last Update: April 22, 2017

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. Click SETTINGS at the top

2.  Click INTEGRATIONS on the left


3. Click GOOGLE SPREADSHEET then AUTHENTICATE 


4. Login to your Google Account and continue the steps to complete the integration.


When you receive submissions on your form, they will be instantly pushed to the provided folder path. Give it a try today and let us know if you have any comments, questions or suggestions.

57 Comments...

  • stveri

    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.

  • ogrrecruitmentmgr

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

  • tigerbluelacrosse

    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?

  • laurahoots

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

    Thanks!

  • jaegi

    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?

  • pckingpankaj

    Awesome way & thanks a lot for all of this

  • QualityFoodWorld

    doesn't work!!

  • Betsy Modglin

    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!

  • salmanvadsarya

    integration option not working

  • Devin Quinn

    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

  • schaefer76

    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

  • npp

    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

  • cobair

    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

    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

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

  • Ted Parker

    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?

  • daniellewis

    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.

  • M732burke

    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?

  • sptportuguesa

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

  • onurtikle

    not working

    openGoogleDocsWizard gives ILLEGAL error

  • kyocera

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

  • events296

    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.

  • LCaraccilo

    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!

  • pteo

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

  • aberadvisors

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

  • aberadvisors

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

  • minoxcz

    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?

  • Ibrahim John Kamara

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

  • uclamusicstage

    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

  • gowri

    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.

  • Yeahdawgvegan

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

  • Carol

    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.

  • mflanagan

    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.

  • colleen tomko

    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.

  • Evan

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

  • dapao

    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

  • euney.kim

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

  • RichmondProLab

    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?

  • hoosiercuse

    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.

  • nzhoodieco

    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?

  • ServiceCulturel_ParisSorbonne

    Hi! Every thing was fine, I had already modified the Google Sheet without trouble with the integration. But since I upgraded to JotForm Bronze, the integration with Google Sheet is not working anymore (no problem with the Google Drive integration). I need help! Thank you!

  • hydrastrail

    I am trying to execute my form submissions with the Google Spreadsheets Integration tool, but the result is an empty datasheet or a data sheet with not all the form submissions.

    Please can you take care of my problem. It is urgent.

    Thank you very much

    https://docs.google.com/spreadsheet/ccc?key=1V7oeR3lk69-za7BV7Wkh-bRVUhe6U_vINi1MctK1igA

  • Unhappy previous Customer

    There has been a constant bug with their google sheets integration throughout years.

    Has flagged it, but after 8 months of waiting on a promised fix, nothing happened.

    So I quit using their service, since they don't seem to take it very serious that people, would like to get data out of the jotform DB

  • ehardman

    I'm also all of a sudden having trouble with Sheets integration. It's been reliable up to this point and that's definitely what we need it to be: reliable!

  • fwcontent

    Is it impossible to change the spreadsheet formatting/colors with this integration? Whenever a new report comes it it gets changed.

  • csquare

    I completed all the steps as indicated above and my google sheets receive NO DATA. I've spent over 3 hours on this.

    I am looking for another form solution. Anyone have one?

  • Vinicius

    Como conectar o formulário do jotform (conta gratuita) com planilha do GOOGLE

  • Ceh

    Is it possible to choose which fields are integrated into google sheets? Basically my form will have around 500 fields and when mapped to google sheets the submissions will quickly eat up their 2 million cell quota.

  • danielmedeirosmoreira

    I am with the same problem: the integration just does not work after a few days.
    I tryed to do another integration, but the problem persists.

  • XHD

    Is there any way I can have responses pushed onto the sheet without the responses sheet being the first one on the document?
    Everything worked fine for my spreadsheet until I moved the tab with the responses on to the 2nd. It begins working again every time it's in front, however this isn't optimal since the 'Main' page is now second and the responses are part of something larger.

  • WYAcademy

    I am using the spreadsheet created by jotform. Then I need another google form to the same spreadsheet BUT IN OTHER TAB. I HAVE THE PROBLEM THAT NOW THE ANSWERS FROM THE JOTFORM FORM AND FROM GOOGLE FORM GO TO THE SAME TAB MIXING EVERYTHING UP!!
    Anybody can help me on this????
    URGENT!!!!!

  • AnkitPatni

    Hi,

    We are getting all data in google sheet only submission date is not coming from last 7-8 days, when I look into the Jotform excel sheet , submission date is visible, but in google sheet it is not visible.
    Earlier it was coming finr.
    Could you pl guide us.

  • AnkitPatni

    Pl find the google sheet path also:

    https://docs.google.com/spreadsheets/d/1vRk1BD-N8JBVodjTaGBt5PIPzutKLxYmIJTqKWxc7NU/edit#gid=0

  • AnkitPatni

    Hi,

    We are getting all data in google sheet only submission date is not coming from last 7-8 days, when I look into the Jotform excel sheet , submission date is visible, but in google sheet it is not visible.
    Earlier it was coming fine.
    Could you pl guide us.

    Pl find google sheet link:-
    https://docs.google.com/spreadsheets/d/1vRk1BD-N8JBVodjTaGBt5PIPzutKLxYmIJTqKWxc7NU/edit#gid=0

  • DormsDirect

    experiencing exact same problem as AnkitPatni, getting all data EXCEPT submission data. Was working fine and then broke about a week ago...

  • garyandbeth

    I have several forms for one project. I would like to keep all the data within one spreadsheet but on different sheets within that spreadsheet. Is this possible?

  • KemitGMan

    Is there a way to link a JotForm to update one or more column(s) in a pre-populated google sheet such that
    1) some fields on form are prepopulated from the sheet
    2) some fields can be updated by the user
    3) the user can click "next" to save their answers and pull up the next row of the sheet to edit
    ??

Send Comment