Google Sheets is a powerful data management tool that helps you organize data and collaborate with others. You can integrate your forms with Google Sheets to automatically forward your form entries to your spreadsheet. New form data will be sent to your spreadsheet instantly so you and your team can view and analyze it right away.
Notes
- Changes in your Google Sheets spreadsheet don’t affect your Jotform form entries.
- Renaming column headings in Google Sheets may break the integration. You can redo the integration in Jotform to fix it.
- Adding filters in Google Sheets may stop your spreadsheet from updating. Reapply the filters in Google Sheets to see the updates.
- Inline edits in Tables won’t update entries in Google Sheets, unlike entry edits.
To integrate your form with Google Sheets
- In the Form Builder, select Settings at the top.
- Go to Integrations on the left.
- Search and select Google Sheets.
Note: You can perform the same steps above to edit or delete your existing Google Sheets integration.
- Next, connect and authenticate your Google account.
- Once you’ve connected your account, choose whether to create a new spreadsheet or use an existing one.
- Enter your desired spreadsheet name if you chose to create a new spreadsheet.
If you want to integrate with an existing spreadsheet, click Select, then choose your spreadsheet. Click Select again.
- Next, choose your form fields to send to Google Sheets.
Notes:
- Submission ID is selected by default and cannot be removed. You can show, hide, or remove it later on in Google Sheets.
- Turn on Send existing submissions to the sheet to include your existing form entries, prior to the integration, in your spreadsheet.
- Finally, select Save at the bottom to complete the setup.
Send Comment:
205 Comments:
17 days ago
Hi, We are trying to access our application as a google sheet. We want each jot form application to come to us as an individual google sheet or csv file. Is there a way to do that?
56 days ago
Hello, I have form-fillers take a photo as part of the form. I'd like to be able to see that entry as an actual image rather than a link in the google sheets integrations. Is this possible and if so, how?
88 days ago
Hola no me permite abrir en la hoja de google el hipervinculo de las imagenes agregadas en el formulario
111 days ago
I have integrated a Jotform with a Google Sheet to receive form submissions directly into the sheet. The objective was to trigger a Google Apps Script function upon each form submission using the trigger settings in the associated Google Sheets. However, I am encountering an issue where the form does not appear as an option inside the trigger settings in Google Apps Script. Consequently, the desired function is not triggered automatically upon form submission.
124 days ago
You are super amazing guys!
146 days ago
I am not able to see Google Sheets integration in the Integrations menu.
174 days ago
Can 2 different forms populate the same sheet (same line but different data)? And is it possible for a form connected to the sheet to fetch data from it. Example: one of our customers add an assignment for us, and submits. This data is added in the sheet. Our worker open his form, and it fetches the last entry. He can add hours used and a comment. Is this possible?
188 days ago
In Step 5, when you select Use and existing spreadsheet - Where is Jotform looking? I can't enter my URl for the current Google Sheet and it doesn't find it when I search on the file name.
207 days ago
I added the integration to Google Drive but Jotform is not allowing me to integrate with google sheets. I looged out of all accounts. This has happened before. Seems to be some sort of bug.
210 days ago
can I create multiple separate integrations into google sheets with one form?
242 days ago
Hi! I am setting up this integration but it appears that if I change the format (ie - font) or manually adding a line in Google Sheets the integration is no longer working. Is that correct?
252 days ago
I have been looking for a tool to create a very customizable event planner. From what I am seeing, this is it! As I use a Google sheet, can I retrieve information from the spreadsheet to populate a list based on criteria and then create a form displaying that row of specific information for review or for making changes?
301 days ago
Can jotforms integrate to google sheets specific tabs in the google sheet
302 days ago
Hi... I have older data in some other excel. I want to transfer that data to the integrated excel. Can i move the data by just copy pasting or there is any other way?
342 days ago
Hi! I'm looking to use a template Google Sheets (instead of creating a new blank spreadsheet or using an existing one) in which the data from a Jotform can be prefilled. How can I implement something like that? Or if I need to manually make a copy of the GSheet, how can I connect the data to be input in that automatically? Hope that makes sense. Thank you!
342 days ago
Good afternoon,
The form I created is a questionnaire and I need each submission on to not be grouped with other submissions is this possible? For example if I have Josh and Tom submit I need their answers to be separate.
361 days ago
Is it possible for entries to be sent to different worksheets in the Google Sheet depending on how they responded in the form?
362 days ago
Hello,
I have a jotform integrated with a google sheet. I have several hidden calculated fields on the jotform that use data from tables. During validation of my google sheet I realized that some of the calculations are incorrect. I need to redo the calculations in the jotform. I have 2 questions.
1. Is there a way to make the new calculation apply to all of the submissions already submitted? and will that push over to the google sheet?
2. If the answer is no to #1. Can I edit the data in the google sheet for existing cells and will my edits there stay? Or will they be overwritten when the integration refreshes?
Thank you
Sherry
More than a year ago
I have a question about the integrating a form with Google Sheets which of the following does it do automatically:
1. Send only new submissions?
2. Sends all the data and recreates the Google Sheet?
3. Sends new submissions and any changes to past submissions to the Google Sheet?
More than a year ago
hai.... bagaimana cara menampilkan gambar pada googlesheet dengan link gambar dari jotform?
More than a year ago
What happened to google sheets legacy?
It has always worked great for the past few years and now all of a sudden it is not transferring over.
Thanks
More than a year ago
The steps work, but it's only showing the first 199 responses. How do I fix this?
More than a year ago
Hi,
This is very useful. I've a question, when forms submission is sent to a Google spreadsheet, is it also sent to Jotform's repositories?
More than a year ago
can I add integration to google sheets to current forms
More than a year ago
Hi - I want to send a new jot form to an existing spreadsheet that is shared with me on google drive. (I have full editor rights, but don't own the sheet) When I open google sheets integration - I don't see the form to pick. Does this mean I can't integrate with this sheet??