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 immediately.
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, go to Settings at the top.
- Select Integrations on the left.
- Select and authenticate Google Sheets.
- Choose whether to create a new spreadsheet or use an existing one.
Note
The “Use an Existing Spreadsheet” option allows you to select an existing spreadsheet from your Google Sheets or Drive account, but it works a little differently. Instead of adding new submissions as a new row to the selected spreadsheet, it creates a new worksheet to store your form data.
- Specify the spreadsheet and worksheet to use.
- Choose the form fields to send to Google Sheets and save your configuration.
Submission ID is selected by default and cannot be removed. You can show, hide, or remove it later in Google Sheets. To include your existing form entries before the integration, turn on Send existing submissions to the sheet.
Send Comment:
211 Comments:
14 days ago
I would love to have the option to create a new Workbook for every unique entry in one form field (this option exists with the Google Drive integration to make a new folder in this way)
37 days ago
Is there any way to pull data from a sheet? Example where I enter an employee name and it would autofill the employee data instead of entering it every time?
95 days ago
I need to create an event registration form, and need to create a form that can register multiple individuals, such as two spouses. Is it possible to create a Jotform that can integrate with Google Sheets and transfer information to multiple lines on the spreadsheet? Need one line for Don and the information for him and another line for Bette and the information for her.
129 days ago
This was super helpful! What a great function to have! However, when I try to find my existing spreadsheet, it's not there. I'm guessing at what the problem might be. If another team member created the Google sheet on her individual Google drive and shared it in the Foundation drive, will that person have to be the one to authenticate and allow the integration? If so, I'm not sure how that would work, because it defaults to the Foundation gmail address to select the sheet and it doesn't look like I can change it. Maybe the problem is something else?
205 days ago
When connecting my form to Google sheets again, the dropdown menu shows all my past connections of Google account. How can I remove my past record of google authentication from the dropdown menu?
220 days ago
I have a Google Sheet set up but how do I create a column with a downloadable version of the forms created? I want to be able to download the completed form into patients' profiles.
245 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?
284 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?
316 days ago
Hola no me permite abrir en la hoja de google el hipervinculo de las imagenes agregadas en el formulario
339 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.
352 days ago
You are super amazing guys!
More than a year ago
I am not able to see Google Sheets integration in the Integrations menu.
More than a year 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?
More than a year 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.
More than a year 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.
More than a year ago
can I create multiple separate integrations into google sheets with one form?
More than a year 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?
More than a year 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?
More than a year ago
Can jotforms integrate to google sheets specific tabs in the google sheet
More than a year 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?
More than a year 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!
More than a year 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.
More than a year ago
Is it possible for entries to be sent to different worksheets in the Google Sheet depending on how they responded in the form?
More than a year 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?