JotForm User Guide / Advanced Features /

How to Integrate Form with Google Spreadsheet

How to Integrate Form with Google Spreadsheet

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


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.

Send Comment


See all comments
  • Creadores


    I just created an integration from a form with 1.800 records but I only got the first 500. After 501 only date appears.

  • cllana

    not working :( i cant see the data after i have set up the integration with google spreadsheet, Can someone help me.


    how can i put output data storage location to my google drive spreadsheet instead of as pdf in a folder of google drive

  • ElysiaT


    When I try to integrate an existing form with google spreadsheets, it results in an empty file. Could you please help with this!

  • john doe

    is it possible to delete rows from a google spreadsheet using data from a specific column response in google forms.
    Basically I have a google form which ask the question have you delivered from these places, the options are a list of address
    I want the responses to delete rows in a column called address in my google sheets.

  • NRS108


    Is there a way to connect a form to a private google sheet owned by the person filling in the form? Each time the form would be filled, another row would be added to the sheet.

    Then somebody else filling in the same form could connect the form answers to his private google sheet.

    etc., etc.


  • 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

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

  • DormsDirect

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

  • AnkitPatni


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

  • AnkitPatni

    Pl find the google sheet path also:

  • AnkitPatni


    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.

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

  • 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.

  • 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.

  • 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.

  • Vinicius

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

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

  • fwcontent

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

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

  • 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

  • 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

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

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

  • 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.

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


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

  • 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

  • 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.

  • colleen tomko

    Thoughtful writing , Apropos , if someone are searching for a service to merge PDF files , my business partner merged a service here

  • 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.

  • 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.

  • Yeahdawgvegan

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

  • 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.

  • 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.

  • Ibrahim John Kamara

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

  • minoxcz


    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:

    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?

  • aberadvisors

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

  • aberadvisors

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

  • pteo

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

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

  • 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.

  • 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.

  • onurtikle

    not working

    openGoogleDocsWizard gives ILLEGAL error

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

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

  • 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 . 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.

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

  • rafiqkhas

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

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

Browse Article by Topics