Google Sheets Integration
If you want to record, organize, or manage your data effectively, Google Sheets is a great application you can rely on. However, most of the time, it requires you to do some manual work. This is a tiring process, especially if you are entering the data all by yourself. forms.app’s Google Sheets integration will help you record your data in real-time to your spreadsheets.
How to send your submissions to Google Sheets
Whether you want to transfer your data to spreadsheets to have a copy of it, use it for advanced data visualization, or for some other reasons, you can automatically do this by setting up forms.app’s Google Sheets integration. With this integration, you will be able to do all of these and more.
1. Click the Connect tab and scroll down, and find the Google Sheets after completing your form:
An image showing the “Google Sheets integration” button, which you can easily find by accessing the “Connect” tab
2. Press the Connect with Google Sheets button, log in to your Google account, and authorize the access:
An image showing the pop-up appearing where you can start the connection by first logging in to your Google account
3. You can select an existing spreadsheet or create a new one for recording form responses:
An image showing the “Create a new spreadsheet” option, which you can keep or select an existing spreadsheet for your future responses
You can always add already received responses to your spreadsheet by clicking the Sync existing answers option.
4. After selecting a spreadsheet, simply click on Save:
An image showing the “Save” button you need to press once you have adjusted the settings
Once you’ve shared the form with your audience, we recommend avoiding making significant changes to your form. If you need to add or remove fields from your form, we suggest sharing the form again and reconnecting the integration from the beginning to ensure optimal performance.
Now, the responses will be added to the spreadsheet whenever your visitors submit a form. Each form field has its own column, and they are lined up respectively.
You can always find the spreadsheet connected to your form in your Drive by searching for it using your form title. Please note that this applies if you selected the 'Create a new spreadsheet' option when setting up your form.
In case you didn’t select the “Sync existing answers” option when connecting the integration, the spreadsheet will be created automatically in your Drive space as soon as you receive a new form response.