You can add Data automatically into Google Sheets using the native integration.
Not entirely sure how to set up the integration? Make sure to learn about it in our dedicated article first.
You can connect the integration either by navigating to the "Integrations" tab in the navbar or by opening the dropdown menu of your project's card and selecting "Connect" - then just click "Connect" on Google Sheets' card.
If you're not currently logged into your Google account, you'll be prompted to do so. Once you're logged in, you will be asked to grant permission for involve.me to connect to your Google account.
Make sure you tick the box: "See, edit, create and delete all your Google Sheets spreadsheets." or the system will return a "code: 403" error with "status: PERMISSION_DENIED".
After granting permission, you'll be able to see the name and email address of the Google account that you're using.
When connecting this integration to a project, create a new Spreadsheet or enter the URL of the Google Sheet you want to use:
Good to know:
The integration will send all data automatically (answers and personal data) into the "Sheet1" tab of your google sheets. Submission data is inserted after the last used row.
Since this is an automatic process, it is not possible to choose which data will be sent over to the Google Sheet. If you don't want certain data to show on the sheet, you can try hiding the column with the data in question.
If you have configured a Google Sheets integration on a project and you duplicate said project, your integration settings will duplicate as well.
Important: Make sure to not delete any columns in your sheet. Doing so will cause formatting issues next time you receive a new submission, which in turn will not allow you to correctly view the data you have collected.
When dealing with formatting issues, you can either manually fix it by putting the sheet back the way it was before the changes were made, or you can create a new sheet and start from scratch.
Opt-in Checkbox and GDPR
In order to be fully GDPR compliant, you will need to tick the option "Only trigger integration when opt-in checkbox element was selected" on your integration's settings and add a dedicated opt-in checkbox that sends data over to the integration, to your involve.me project.
Here's a step-by-step guide on how to set it up.
If GDPR is of no concern to you, then you can skip this step.
Testing your integration
Once the integration has been set up and connected to your project, it will be time to test it in order to ensure everything is working as intended, learn how to do it here.
If you still have any questions, please feel free to contact support.