You can add Data automatically into Google Sheets using the native integration. You can either set it up for your organization (all projects that don't have individual integration settings) or on a project level.
To activate it, connect the organization or the project to your Google Sheets account.
When Connected, create a new Spreadsheet or enter the URL of the Google Sheet you want to use:
On your project, make sure you have an opt-in element to be fully compliant and set the options to: "Sends data to: Google Sheets".
The integration will send all data automatically (answers and personal data) into the "Sheet1" tab of your google sheets. Submission data are inserted after the last used row.
Make sure you are on a paid plan subscription. Data will be sent to your integration once a participant completes the submission and has given consent on an Opt-In Checkbox that triggers the integration.
Integration at the project level is not duplicated with a project. You will need to setup a new Integration on the copy.
Testing the Integration: Once a user completes the survey, check the Analytics of the project -> Select the Responses [ ] menu -> Select a submission. On the right pane, scroll down the page until the "INTEGRATIONS" section.
The Google Sheets icon, along with the other integrations configured, should be displayed with a status: "Successful".
If the Google Sheets icon is not present, it is not integrated with the project. If it is greyed out, the Integration is present but has not been triggered. Other statuses include Pending or an Error description that can be used to further troubleshoot the issue if necessary.
If you have any trouble setting up this integration, please contact support.