How to Integrate Forms With Google Sheets

March 11, 2024

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

  1. In the Form Builder, select Settings at the top.
  2. Go to Integrations on the left.
  3. Search and select Google Sheets.
Steps to add Google Sheets integration in Jotform Form Builder

Note: You can perform the same steps above to edit or delete your existing Google Sheets integration.

  1. Next, connect and authenticate your Google account.
The Authenticate button in Google Sheets integration
  1. Once you’ve connected your account, choose whether to create a new spreadsheet or use an existing one.
The  spreadsheet connection options in Jotform Form Builder's Google Sheets integration
  1. Enter your desired spreadsheet name if you chose to create a new spreadsheet.
How to Integrate Forms With Google Sheets Image-1

If you want to integrate with an existing spreadsheet, click Select, then choose your spreadsheet. Click Select again.

  1. Next, choose your form fields to send to Google Sheets.
The form fields selection in Google Sheets integration

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.
  1. Finally, select Save at the bottom to complete the setup.
Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments:

  • Mindi Frankel - Profile picture
  • Jocelyn Pijpaert - Profile picture
  • guillermo carrillo - Profile picture
  • Ashish Jain - Profile picture
  • Kayombo Boarding - Profile picture
  • Anshuman Dixit - Profile picture
  • Jan Berg-Styhm - Profile picture
  • Kathleen Beisly - Profile picture
  • ADG Constitution Committee - Profile picture
  • Davis - Profile picture
  • Tracy Fairman - Profile picture
  • Marc Ferguson - Profile picture
  • Calvin Stein - Profile picture
  • Soumya Jain - Profile picture
  • NXT Solar - Profile picture
  • La'Kisha Williams - Profile picture
  • Scott - Profile picture
  • Sherrynp - Profile picture
  • Michael Coleman - Profile picture
  • Robert - Profile picture
  • Kirk Kleinpeter - Profile picture
  • Alyssa Hutcheson - Profile picture
  • Rigoberto Obregon Tello - Profile picture
  • Jill Robison - Profile picture
  • Julie Todd - Profile picture