Form Builder for Google Sheets

You can integrate your online forms with Google Sheets in a few quick steps for seamless data management. Automatically forward form response data to your spreadsheets, and your team can view and analyze it right away.

To integrate your form with Google Sheets, just select Settings at the top of Form Builder, go to Integrations on the left, and select Google Sheets. Next, connect and authenticate your Google account. When you’re finished, choose whether to create a new spreadsheet or use an existing one. Select the form fields to send to Google Sheets, then click Save at the bottom to complete the setup. That’s it!

For more detailed instructions, visit our Jotform + Google Sheets setup page.

Yes, you can import previous submissions to your Google spreadsheets in a few quick steps. In Jotform’s Form Builder, go to the form you want to connect with your Google spreadsheet and click into Settings. Select the Google Sheets integration, and choose to either create a new spreadsheet or add to an existing one.

When the menu pops up, scroll to the bottom, and you’ll see a box that says Send existing submissions to the sheet. When you check the box, all previous submissions for this form will automatically be exported to your spreadsheet, so you don’t have to retroactively upload them.

Yes, you can rename your Google spreadsheet in no time! If you’re working in Google Sheets, click the tab of the sheet you want to rename. Select Rename from the menu, type in your new name, and press Enter.

To name a new spreadsheet from Jotform, navigate to the Form Builder and select the Google Sheets option from the Integrations tab. Choose Create a new spreadsheet, enter your desired name, and click Save.

Yes, there are a few limitations to be aware of when integrating Jotform with Google Sheets. Any changes made in your Google Sheets spreadsheet won’t affect your Jotform form entries, so you can’t edit submissions in Jotform from Google Sheets.

Renaming the column headings in Google Sheets may break the integration — but you can redo the integration in Jotform to fix it. Additionally, adding filters in Google Sheets may stop your spreadsheet from updating. To see the updates, reapply the filters in Google Sheets. Lastly, inline edits in Jotform Tables won’t update entries in Google Sheets, unlike entry edits.

Yes. This is one of the biggest benefits of the Jotform + Google Sheets integration! Once you connect your form to your Google spreadsheet, all submissions will automatically populate the spreadsheet in real time. You won’t have to think about manual data entry, and all your data will be up-to-date when you need it.

Jotform’s top priority is ensuring that all data collected through your online forms is highly secure. Jotform uses a 256-bit SSL connection, offers encryption features, and includes advanced privacy settings. Jotform also follows GDPR and CCPA regulations — so you can rest easy knowing that all your form data is protected.

For more detailed information, please visit our Secure Online Forms page.

These are the supported actions in the Jotform + Google Sheets integration:

• Add new spreadsheet rows with new Jotform submissions
• Update spreadsheet rows with an edited Jotform submissions
• Add new spreadsheet rows with signed Jotform documents