JotForm User Guide / Advanced Features /

How to integrate JotForm with Google Sheets

How to integrate JotForm with Google Sheets

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. Click on the SETTINGS panel (at the top of the Form Builder) and then INTEGRATIONS (from the menu on the left). Select the Google Sheets integration.



2. Click AUTHENTICATE to connect your Google account. If you have already authenticated your account, you can select your Google account from the dropdown.




3. Once you've connected your account, you can choose one of two options; create a new spreadsheet or use an existing spreadsheet.




4. To create a new sheet, please enter names for your spreadsheet and worksheet, and then select the form questions that you want to use to create columns.




5. To use an existing sheet, please select a spreadsheet from your Google account and enter a worksheet name, then select the form questions that you want to use to create columns.



6. When you select Select All to send all form fields to Google Sheets, every form field you add to your form will automatically create a new column.



Submission ID is selected by default and cannot be removed. However, it will be displayed as a hidden column in your spreadsheet. You'll able to show, hide, or remove it in the sheet.



7. If you don't want to send your existing submissions to this sheet, please click the checkbox to deselect this option. Then click SAVE to complete the integration.



P.S.: You can always edit the form questions you want to use.




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

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


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:
Contact JotForm Support: https://www.jotform.com/contact/

Send Comment

9 Comments...

  • Bakery_PattiCakes

    When I try to integrate google sheets it says I'm not authorized. Could someone help me with that?

    Thank you

  • hockeyvictoria

    Can you integrate the data into an existing Google Sheet that is already sitting in a folder in your Google Drive?

  • hockeyvictoria

    Hi, can forms be integrated to different Google Drives/Google Accounts or must all forms be integrated into the same Google Account?

  • Havert

    when i click save, it says that you are not authorized. How can I fix this?

  • SunbridgeInstitute

    Is it possible to make edits on the resulting spreadsheet that can be saved even though more submissions come in and update the spreadsheet? For example, can I add more columns to the right side where I can note a phone call with a registrant, or other post-submission data? Thank you!

  • ElevateTheArts

    I love the update to this integration... a great improvement.
    It seems, however, that we can't integrate multiple forms into the same actual WORKSHEET... eg. if i'm collecting identical fields from multiple forms (so each team member has a unique form link & hidden source field) this would be super-amazing if ALL the data ended up in the same worksheet, not different sheets that I now have to merge together... (even if the fields weren't identical, having the option of a SINGLE worksheet to collect data from multiple forms as needed would be really helpful in a lot of cases).

    can this happen? it would make this updated integration really really really helpful and time-saving.

  • NOVAWorkforce

    Is it possible to save or created the spreadsheet for a Google team drive?

  • fshaykis

    Hi,

    Is it possible to change the destination folder in your Google Drive that the new google sheets gets placed in? Previously this was possible (with the old version of this integration).

  • ColoradoStars

    My form's Last Name & First Name fields no longer populate the data to my integrated Google sheets. How can I correct this?