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, navigate to Settings at the top.
- Select Integrations on the left.
- Search for Google Sheets, and click it.
- Choose whether to create a new spreadsheet or use an existing one. Click the Next button to proceed.
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.
- Click the Authenticate button. Ensure to connect the appropriate Google account for the integration, and allow access permission when asked.
For previously authenticated accounts, choose the account to use, then click the Add Action button.
- Now, set up the options accordingly:
- Spreadsheet Name — Enter the name of the spreadsheet that will be created.
- Worksheet Name — Enter the name of the worksheet.
- Fields to Send to Google Fields — The integration selects all fields by default. Uncheck the fields you wish to exclude.
- Send Existing Submissions to the Sheet — If you have existing submissions in the form, you can send them to the spreadsheet by checking this option.
- Finally, click the Save button to complete the integration.
The Submission ID is part of the fields sent to the spreadsheet. You can include Submission Edit URL, Submission Edit Data, Submission URL, Submission Data, and Submission IP.
Once the integration is set, you can see and click the link to open the spreadsheet. If you hover your mouse over the created action, you’ll see the Edit Action (pencil icon) and the More (thee-dotted vertical icon) options to the right. The More option includes the following:
- See Action Logs — This section will display your Google Sheet’s successful and failed runs. It’s useful when troubleshooting issues.
- Rename Action — If you want to personalize the action’s title.
- Disable Action — This option is useful to temporarily stop the integration from sending data.
- Delete Action — If you want to remove the integration from your form.
Send Comment:
220 Comments:
18 days ago
I have a working integration with Google Sheets but I need to make bulk edits to some columns. What is the best way to make bulk edits and have the data automatically updated in both Jotform and Google Sheet via integration?
57 days ago
Hello, I am trying to integrate Googlesheets with a form and I receive the below error:
{ "error": { "code": 403, "message": "Request had insufficient authentication scopes.", "status": "PERMISSION_DENIED", "details": [ { "@type": "type.googleapis.com/google.rpc.ErrorInfo", "reason": "ACCESS_TOKEN_SCOPE_INSUFFICIENT", "domain": "googleapis.com", "metadata": { "service": "sheets.googleapis.com", "method": "google.apps.sheets.v4.SpreadsheetsService.CreateSpreadsheet" } } ] } }
71 days ago
MY PRODUCT ARE NOT GOING ON GOOGLE SHEET , PLEASE HELP
81 days ago
While trying to either create a new sheet or select an existing one, a leyend with error 403 appears. I've been trying to integrate google sheets for a week and it keeps happening
99 days ago
Can i have input data in spreadsheet for the submission but in formatted data same as form
135 days ago
can i send the jotform input data to more than one google spreadsheet?
171 days ago
My google sheet is not updating from the jotform integration. Any idea what could be wrong?
182 days ago
How do I integrate the data from a form into an existing worksheet in an existing spreadsheet?
I would like to be able to select certain data from the jotform form to integrate into already existing columns in an existing worksheet.
Also, how do I make data from multiple jotform forms integrate data into the same worksheet?
197 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?
216 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)
239 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?
297 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.
331 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?
More than a year 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?
More than a year 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.
More than a year 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?
More than a year 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?
More than a year ago
Hola no me permite abrir en la hoja de google el hipervinculo de las imagenes agregadas en el formulario
More than a year 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.
More than a year 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?