📌 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.

Each Google Sheet file can be integrated with one form (it cannot integrate with multiple forms).

*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.

📌 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?