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 with others" box.
  4. To choose whether a person can view, comment, or edit the file, click the Down arrow next to "Anyone with the link." .
  5. Note that the link will default to be viewable by your organization accounts only! To expand access to outside of your organization, click the Down arrow next to "Anyone at Your Organization…” and select “More” for additional options.
  6. A file link will be copied to your clipboard. Paste the link in an email or anywhere you want to share it.

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 where the data will uploaded.
  6. Save the configuration.

Did this answer your question?