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.

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


Related Articles


Did this answer your question?