How to Integrate Forms with Google Sheets
May 31, 2021
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.
Thank you for helping improve JotForm's user guides. 🎉