How to Integrate Forms with Google Sheets

March 3, 2022

Google Sheets is a powerful data management tool that helps you organize important data and collaborate with others. Integrate Jotform with Google Sheets to automatically sync form submissions to your spreadsheets and update your data in real-time.

Automate your workflow and cut out manual data entry with Jotform’s Google Sheets integration. New form data will be sent to your spreadsheets instantly so you and your team can view and analyze it right away.

Setting up an integration with Google Sheets for your form is quick and easy. Just follow the steps below.

  1. Open the Settings tab in the Form Builder.
  2. Click Integrations on the left.
  3. Search and select the Google Sheets integration.
form-builder-google-sheets-integration-min-png
form-builder-google-sheets-integration-min.png
  1. Click Authenticate to connect your Google account.
form-builder-google-sheets-authenticate-button-min.png

If you have already authenticated your account, you can select your Google account from the dropdown.

  1. Once you’ve connected your account, you can choose one of two options:
form-builder-google-sheets-choose-option-min.png
  • Create a new spreadsheet – enter the names for your spreadsheet and worksheet.
  • Use an existing sheet – select a spreadsheet from your Google account and enter a worksheet name.
  1. Select form fields to send to Google Sheets.
form-builder-google-sheets-select-all-min.png
  • When Select All is ticked on, every form field you add to your form will automatically create a new column in Google Sheets.
  • Submission ID is selected by default and cannot be removed. However, it will be displayed as a hidden column in your spreadsheet. You’ll be able to show, hide, or remove it in the sheet.
  • If you don’t want to send existing submissions to this sheet, uncheck the Send existing submissions to the sheet option.
  1. Click the Save button to complete the setup.

And that’s it! When you receive submissions to your form, they will instantly be sent to your spreadsheet.

How to Edit or Delete an Existing Google Sheets Integration

  1. Go to the Settings tab in the Form Builder.
  2. Click Integrations on the left.
  3. Open your existing Google Sheets integration.
  4. Click Edit Integration to update your setup. Or, click the Remove Integration button to delete the integration.
form-builder-google-sheets-running-min.png

Give it a try today, and let us know if you have any comments, questions, or suggestions.

Was this guide helpful?
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:

  • Erning Kusumaputri
  • DV3 Citrine
  • Martin Luck
  • Moisés Duek
  • Marius
  • Kristi
  • WTSDA Region 8
  • Rosman
  • Jazz Arts Project
  • Jazz Arts Project
  • Dawn Moore
  • Francisco Ortiz
  • Grace
  • Kristine
  • JSC Admin
  • Duta Bahasa Sumatra Barat
  • Sunshine Horses
  • Sphynx Capital LLC
  • Talega Gallery
  • Katie Roth
  • Jay Kumar
  • Glenn Grubb
  • Kari Fagin
  • CJA-DST
  • RICARDO_G TENIS COACH GARZON
  • Henrik Funch
  • SeabaNikki
  • prctennis
  • bethmckinney74
  • lgariboldi
  • Mulligan_Scarlett
  • siouxmaeb
  • mtl_tech_admin
  • bussookaa
  • gleninneswaste
  • mneville
  • krodgers4874
  • MMarilyn
  • GioBoi
  • dc4622ne
  • TREF_forms
  • tucksdesign
  • 16general
  • petraccafer
  • jopitos
  • wildsftours
  • watamutreehouse
  • restaurantesyapp
  • deepakthakuria
  • gourdonjeannick
  • RocModQuiltGuild
  • kmackroy
  • comunicacion.anpaxanela
  • Pawan Rawal
  • jaydarji
  • cygnetclinic
  • paulsachse
  • popschool
  • Benson_Kathy
  • ybedregalv
  • digitechdrivers
  • Grunblattpc
  • luz Aguirre Moore
  • Nycaplocal
  • mayrhyphysnt
  • Pratik Vyas
  • 6PBC
  • Kai
  • goldenexecutivepartnerregistra
  • Timothy Law
  • kevin.f3c
  • kellyelizabethharrison
  • teodora.kotseva
  • Paul Thompson
  • learningpoint
  • atlantisfestlv
  • ABCSupplyWestRegion
  • cbibleway
  • theoddcatsanctuary
  • Corkspace
  • jaymeyb
  • christophschemel
  • olyakushnir
  • pennpotter
  • irisasht
  • andrea.bandiera
  • lynnephelps
  • Sheila Fetter
  • Sheila Fetter
  • andoverbeacon
  • andoverbeacon
  • TWHC
  • coinmo99d
  • Pawsibilities
  • Burgmann
  • bjohnson_connections
  • bjohnson_connections
  • Sergey Po
  • kristinambs
  • Galiker
  • PeterNoblesse
  • jotnoah
  • John Solomon
  • Advking
  • Advking
  • CPSM_CarSeatCheck
  • Iz Flores
  • xad
  • OI_Forms
  • fausto
  • elgabriello
  • FFPool
  • EllsworthSales
  • Yabi
  • mjjmk
  • ArtHop
  • Emma L
  • Mobi
  • ashutoshjaihind
  • Creadores
  • cllana
  • SOFTAZ_ERP_SOLUTIONS
  • ElysiaT
  • john doe
  • NRS108
  • KemitGMan
  • garyandbeth
  • DormsDirect
  • AnkitPatni
  • AnkitPatni
  • AnkitPatni
  • WYAcademy
  • XHD
  • danielmedeirosmoreira
  • Ceh
  • Vinicius
  • csquare
  • fwcontent
  • ehardman
  • Unhappy previous Customer
  • hydrastrail
  • ServiceCulturel_ParisSorbonne
  • nzhoodieco
  • hoosiercuse
  • RichmondProLab
  • euney.kim
  • dapao
  • Evan
  • colleen tomko
  • mflanagan
  • Carol
  • Yeahdawgvegan
  • gowri
  • uclamusicstage
  • Ibrahim John Kamara
  • minoxcz
  • aberadvisors
  • aberadvisors
  • pteo
  • LCaraccilo
  • events296
  • kyocera
  • onurtikle
  • sptportuguesa
  • M732burke
  • daniellewis
  • Ted Parker
  • rafiqkhas
  • npp
  • schaefer76
  • Devin Quinn
  • salmanvadsarya
  • Betsy Modglin
  • QualityFoodWorld
  • pckingpankaj
  • jaegi
  • laurahoots
  • tigerbluelacrosse
  • ogrrecruitmentmgr
  • stveri