Can I integrate DataScope into Google Sheets?

Google Sheet Integration

Aristotle avatar
Written by Aristotle
Updated over a week ago

📌 Google Sheet Configuration:

  1. Open a file in Google Sheets.

  2. In the top right corner, click Share.

  3. Click "Get shareable link" in the top right of the "SHARE" box.

  4. To choose whether a person can view, comment, or edit the file, click the Down arrow next to "Get Link > Change"

  5. Select the option "Anyone with the link" > EDITOR.

  6. Copy the link and click on Done.


📌 Configuration at DataScope:

  1. Log in to DataScope and enter the Integrations tab

  2. Click on "Google Spreadsheet Beta"

  3. And then on New Google Spreadsheet.

  4. Select the form you want to integrate with Google Sheets.

  5. Paste the shared link from the Google Sheets spreadsheet that you have copied.

  6. 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:

Image #1

📌 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

-----------------------------------------------------------------------------------------------------------------------------

Did this answer your question?