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.
Make sure you tick the box: "See, edit, create and delete all your Google Sheets" or the system will return a "code: 403" error with "status: PERMISSION_DENIED".
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.
Triggering Google Sheets integration manually. In case the Integration is configured but the Opt-in checkbox was not checked or not configured, or if the submission was only partial, you can still trigger that integration from each individual submission from the Analytics, responses menu.
Note: To trigger the integration on a partial submission, the submission must have been revealed.
When clicked, you will be presented with the option to trigger the Integration for all submissions for which the integration was not executed.
If you have any questions, please contact support.