JotForm User Guide / Advanced Features /

How to Integrate Forms with Google Sheets

How to Integrate Forms with Google Sheets

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.

Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Contact JotForm Support: https://www.jotform.com/contact/

Send Comment

130 Comments...

See all comments
  • comunicacion.anpaxanela

    Buenos días,
    desde hace un par de días no se pasan automáticamente los datos del formulario a la hoja Excel integrada. ¿A qué puede ser debido?
    Gracias ,
    un saludo.
    Rosa.

    Good Morning,
    for a couple of days the form data is not automatically passed to the integrated Excel sheet. Which may be due?
    Thank you ,
    Greetings.
    Rose.

  • Pawan Rawal

    Hi,

    As I am able to integrate the JoT with Google drive, My question is , if I want to select my own drive link in JOT, how can i achieve it. Currently Jot created the file on Google sheet, but i want to use my file amd upload the data in that excel sheet.

    Thanks

  • jaydarji

    I tried to integrate a template form into google sheets and it keeps saying integration failure. Please advise. Thank you!

  • cygnetclinic

    Hi, I've set up a questionnaire with choice (e.g. rarely, sometimes, always) with the calculation options enabled (rarely = 0; sometimes = 1, always = 2). When I export this to Google Sheets, I wanted the numbers to prepopulate the fields, but instead, I still get the word label "eg, sometimes" in Google Sheets or Excel. Am I missing a step?

  • paulsachse

    I tried removing a column that I did not integrate and now the form isn't adding new submissions. Is it possible to make in not export all columns?

  • popschool

    Hi,
    I love your product. I have multiple forms and want the outcome to be combined in 1 google sheet file. Is that possible?

  • Benson_Kathy

    I integrate my JotForm with google sheets. The form has a table. The table data appears in the Jotform submission but not in the google sheet. Are tables supported with the Jotform / google sheets integration?

  • ybedregalv

    Hola al abrir el archivo en Google drive no lo abre como hoja de cálculo lo abre como un pdf a pesar de que tiene la ext de excel

  • digitechdrivers

    when i open google sheet from google account i can see it but when i click on this submission icon it shud show you the google sheet but its not.
    image.png

  • Grunblattpc

    I wanted to use google sheets amongst the providers in the practice but make it hippa compliant - is that possible?

  • luz Aguirre Moore

    Thanks for your help.

  • Nycaplocal

    This integration is not sending the email address field to the form and there is no option to edit it. Please advise. Thanks

  • mayrhyphysnt

    I'm actually new to all these, is there a way to send confirmation emails to both me and the respondents?

  • Pratik Vyas

    Any condition we are already data of google form and jot form data add in google form spreadsheet it is possible or not? And one spreadhseet data automatically insert two ways one is google form and other is jot form?

  • 6PBC

    Why would only some of the information go into my spradsheet? its missing the column with the product data?
    thanks

  • Kai

    Is it possible to set a complex path to a google sheet, so the sheet ends up in the right subfolder in my google drive? I tried using '/' 'berlinhistory_bla/blub/form' but it only created a folder with the whole string as name including all the '/' characters.

    Thanks!

  • goldenexecutivepartnerregistra

    You have deleted my form that I created, and now I fear working with you, because I don't trust you

  • Timothy Law

    Hi Jotform Team,

    I currently have a form with 2 tables where the end-user could populate with numbers - however the google sheet integration for the first table is buggy whereas the second table's results are fine. Any idea how I could fix this? Thanks.

  • kevin.f3c

    My form has a "Configurable list" segment with several fields in each line, and submitter can add as many lines as needed. I would like the resulting list to be exported into a google sheet with each list box in its own field in the sheet so that I can perform calculations on the list. Is this possible?
    Currently all list boxes are in one cell as text.

  • kellyelizabethharrison

    Hey does this stop forwarding survey responses to the Google Sheets spreadsheet if you edit the Google Sheets spreadsheet (e.g., add other columns working with the populated data)?

    Thanks!
    KellyElizabethHarrison@gmail.com

  • teodora.kotseva

    Why Integration between my Form and Google Sheet cannot happen successfully ? I have a Jot form with 10 questions/ labels and 3 submissions already. But after the integration, in Google sheets appears as a field, column only these below and no any data from the submissions. As far as I understand submission information should be received instantly:
    Submission Date IP Submission ID Edit Link

  • Paul Thompson

    I have two sheets (tabs) on the Google Sheets filem which Jotforms integrates with. One to receive data from the form and the other to process it and format cells differently, for users to function with. I want to hide the integration sheet so that users only see the sheet they are to use.
    Is it possible to do this and still receive the data from Jotforms to the hidden sheet?

  • learningpoint

    Okay, unfortunately, it didn't come through. If I reintegrate, will it populate all of the sumbissions? or only the future submissions that I receive?

  • atlantisfestlv

    How do I take an existing from and send it to google?

  • ABCSupplyWestRegion

    That is a step closer! We were hoping we could do a key word search in the responses - so for example, if someone types "chicken" in their text response, we can pull just the forms that have that keyword.

  • cbibleway

    When I first integrated my form to google sheets the registration payment amount was on it. But now the registration payment amount is not noted on the google sheet. What happened and how do I correct it?

  • theoddcatsanctuary

    I just added a question to our Cat Adoption Application form, but the answers for the new question aren't populating in the Google Sheet (the answers to the old questions still populate). Do you have any suggestions to get this to work? Thanks!

  • Corkspace

    Hi, I have authenticated my account but I can't create a spreadsheet and therefore complete integration. Can you help with why this may be?

  • jaymeyb

    Ive set up my integration successfully, but one of my question fields is not showing up in the data dump into Google sheet. It is a drop down selection question - how can I fix this?

  • christophschemel

    Hi,
    is there a possibility to send data to different sheets depending on conditions? I guess not, but this would be very helpful, please escalate.

    Thanks!

  • olyakushnir

    How can I edit the fields that need to be captured on the google spreadsheet after the form was updated?

  • pennpotter

    We integrated Jotform with Google sheets when we set up new form (2019 Summer Show...). It worked for a while but suddenly stopped sending submissions. Why? What happened? Jotform problem, Google problem, person problem?
    pennpotter

  • irisasht

    hi, If im adding new question to the form it not added as a column automatically ? how can we hanldle this usecase?

  • andrea.bandiera

    I would like to add a combo-box with a predefined list and the possibility to insert a new one, that the into the next time I compile the form the word are added to the list.
    is possible?

  • lynnephelps

    The jotform created the Google Sheet just fine, but I'm having problems with the way the Name field is populated. I used the Name element in the form builder.
    First name contains the first AND last name.
    Last name contains the last name.
    HELP!

  • Sheila Fetter

    After reading more in other comment strands here is more info that may be helpful:
    - My form link is:
    https://form.jotform.com/91067931342254
    - I have made no changes to the form since it showed up in Google Docs automatically upon integration.
    - I set up a new gmail account specifically for this task so the integrated spreadsheet is the only sheet in my docs (ie the info is not getting dumped into a different sheet within my account).
    - I tested the form, twice, by pasting the link in a new tab, filling in the form and submitting it
    Hope that helps!
    Sheila

  • Sheila Fetter

    I set up a Jot Form and integrated it with Google Sheets per directions above. I have a sheet now with all the headings. I filled in the Jot Form myself, twice, to test the integration. When I submitted the forms, they did not populate the sheet with my test information. Is there a reason it is not integrating? From other comments this should happen instantly.
    Thanks,
    Sheila

  • andoverbeacon

    By experimenting, I think I've learned the following, all of which it would be great if you could add to this user guide.

    - When you create a Google Sheets integration, JotForm will try to find the folder name you give it wherever it may exist in your Google Drive account, even if it is a subfolder, a sub-subfolder, etc. This can cause unexpected results, so be careful!

    - If Jotform can't find a folder (or subfolder, sub-subfolder, etc.) with the folder name you specify, it will create a folder with that name as a folder in your My Drive folder.

    - When you give JotForm a name for the sheet to contain the form's submissions, it does NOT search for a sheet with that name. Rather, it CREATES A NEW SHEET (in the folder you specified) and assigns the name to that new sheet.

    - The integration between form and sheet is based entirely on the unique URL of the new "integrated" sheet. That means you can move the integrated sheet to a different folder and your form will still find it (because its URL doesn't change when you move it). You can rename the sheet, and your form will still find it. You can create a new sheet with the same name you gave the integrated sheet, but the form will NOT pay any attention to the new sheet ... it will still look for the integrated sheet based on its unique URL.

    - You can even Remove the integrated sheet (which just moves it to Google Drive's Trash folder), and your form will still find it and update it with new submissions.

    - Only if you move the integrated sheet to the Google Drive Trash folder and then find it there and click "Delete Forever" will its unique URL cease to exist. Once you do that, all subsequent form submissions will simply not be sent to a Google sheet (and there will be no error message). If you edit your form, go to Settings, go to Integrations, go to Google Sheets, it will say your Google Sheets integration is up and running, but if you click on the unique URL that JotForm displays, you'll get an error message from Google saying, "Sorry, the file you have requested has been deleted." To fix the problem, you'll have to Remove Integration and create a new Google Sheets integration for your form.

  • andoverbeacon

    This document needs to describe the integration step where you pick a folder and a spreadsheet name. It needs to explain what happens if you specify the name of a folder or a sub-folder that already exists, and what happens if you specify the name of a sheet that already exists in the folder (or sub-folder) that you named.

    That would be very helpful, and hopefully would cut down on the questions you have to answer!

  • TWHC

    Why Cant I import using my spreadsheet?

  • coinmo99d

    When I do this is creates a new Form to be sent to the Google Doc. I already have a Form that I would like to begin sending the incoming submissions to Google Doc. How do I do that?

  • Pawsibilities

    The integration included the most recent submissions 2017/2018. I'd like to know how to include all submissions I've received since I started.

    Thank you!
    Lea
    Your pet's best friend next to you.

  • Burgmann

    Hi, I have set this up and it's great. My form requests documents (pdf) and they appear as a link in the spreadsheet cell in the drive account (wonderful). To open the document from the link you're asked to download the document. I'm wondering if there is a way to view the document in the browser (considering it has a pdf view url)?

    Many thanks.

  • bjohnson_connections

    Yes. I had and saw the information in Jotform but it is not pushing forward to the Google Sheet.

  • bjohnson_connections

    The data is not pushed to the google sheet. Yesterday it was fine. Today nothing. What is wrong?

    thanks

  • Sergey Po

    Where are examples of how form code will be and
    where are results of my submited data
    How can i save those data on a file of table format?

  • kristinambs

    I have a JotForm that I already did a Google Sheets integration with. When I change the Header name, then do a report, the old Header is still there, the link did not pull-in the new name.

    Am I missing something?

  • Galiker

    I have a few forms but need to combine answers in one excel doc with separated it in list of the doc. So what i need to do? I don't see any information about that.
    Thanks.

  • PeterNoblesse

    for an unknown reason, my spreadsheet only contains 21 entries now, instead of 340.
    All the others have disappeared.
    So my question is: when I unlink the Google spreadsheet, and re-link a new one, will all the former entries re-integrate in the new one? Or will only new entries appear?

  • jotnoah

    Can we connect (integrate) to existing spreadsheet I want to pick?