📌 Google Sheet Configuration:
With public access:
Log in to Google Sheets and create the spreadsheet where you want to receive the data (https://www.google.com/intl/pt/sheets/about/).
Click on Share > Copy Link > Change and then set it to "Anyone with the link > EDITOR".
Click on "Copy Link".
With private access:
We understand that data security is extremely important in certain processes and, even due to internal company policies, it is necessary that data is not shared. For this reason, we offer the possibility of carrying out the integration without the need to grant editing access to anyone who has the link.
Log in to Google Sheets and create the spreadsheet where you want to receive the data (https://www.google.com/intl/es/sheets/about/).
Click on Share > Add people and groups and then set it to "datascope-sheets@datascope-io.iam.gserviceaccount.com > Have EDITOR permissions.
📌 Configuration at DataScope:
Log in to DataScope and enter the Integrations tab
Click on "Google Spreadsheet Beta"
And then on New Google Spreadsheet.
Select the form you want to integrate with Google Sheets.
Paste the shared link from the Google Sheets spreadsheet that you have copied.
Save the configuration.
TIPS:
If you need to export your data into a Google Sheet, it is necessary to integrate your form with the sheet before you start sending answers to that form. Only the new data sent after the integration will be reflected on your Google Sheet document.
When integrating Google Sheets, your Repeatable Fields type of questions will be loaded onto individual Sheets, within the same Google Sheet file.
It is possible to integrate several forms in the same Google Sheet file, each sheet will be identified with the name of the form and the ID:
If you have doubts the ID can be found in the Configure> Modify App, according to the image below to obtain it's URL:
*On this example, the Form ID is 492821.
In order for the changes of the modified answers to be automatically updated in your sheet, you must check the "Send Modifications" option when you are doing the integration:
📌 Data visualization:
You can see the information sent to Google Sheets directly in Data Scope, by clicking on the link of the form in the Integrations tab.
You will also be able to see the History of changes (Audit Log), to accompany that your data is being synchronized correctly, in case any response is not linked it will be reflected in this option.
It can have 3 colors, according to the progress of each answer:
Green: the response was successfully synced to Google Sheets.
Yellow: the response has not yet been synced to Google Sheets, it is pending.
Red: the response was not synchronized, some error occurred in the process. To know more details check the information icon 🛈
----------------------------------------------------------------------------------------
Related Articles
----------------------------------------------------------------------------------------