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


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.


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)

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?


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:

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


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?

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.

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

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

ServiceCulturel_ParisSorbonne (February 24, 2017 at 09:38 AM)

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!

View Answer

hydrastrail (March 12, 2017 at 11:55 AM)

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

View Answer

Unhappy previous Customer (March 18, 2017 at 09:44 AM)

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

View Answer

ehardman (March 20, 2017 at 03:51 PM)

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!

View Answer

fwcontent (March 21, 2017 at 03:22 PM)

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

View Answer

csquare (April 10, 2017 at 02:56 PM)

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?

View Answer

Vinicius (May 11, 2017 at 09:59 AM)

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

View Answer

Ceh (May 20, 2017 at 03:54 PM)

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.

View Answer

danielmedeirosmoreira (June 07, 2017 at 06:16 PM)

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.

View Answer

XHD (July 04, 2017 at 09:18 AM)

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.

View Answer

WYAcademy (July 12, 2017 at 08:06 AM)

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

View Answer

AnkitPatni (July 24, 2017 at 09:48 AM)


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.

View Answer

AnkitPatni (July 24, 2017 at 09:51 AM)

Pl find the google sheet path also:

View Answer

AnkitPatni (July 24, 2017 at 12:17 PM)


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

View Answer

DormsDirect (July 29, 2017 at 09:53 AM)

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

View Answer

garyandbeth (August 17, 2017 at 11:24 AM)

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?

View Answer

Send Comment