Advice and answers from the team

Google Sheets

Export each survey response as a new row in a Google Sheet with the Google Sheets integration.

On Google Sheets:

  1. Visit Google Sheets
  2. Create a new Sheet. Do not add any content to the sheet, this will break functionality. Also, ensure the sheet's first "tab" (bottom left) is named Sheet1, the default. You can name the spreadsheet anything you want.
  3. In the top right corner of your sheet, click the green "Share" button
  4. Paste this email address into the "Share with people and groups" textbox: [email protected]
  5. Make sure "Editor" privileges are selected
  6. Uncheck "Notify People"
  7. Leave message area blank
  8. Click Share
  9. In the URL bar, locate the Sheet ID. This should look something like the bolded text 1KbpKS_kImmTOc2Xr1x3vXlssjqtXLTs_kaUV8L3CkyI /
  10. Copy the Sheet ID, making sure to ignore any extra text like "/edit" and only copying the bolded example above.

On GetReviews:

  1. Visit the Integrations Library
  2. Locate the Google Sheets integration and click "Configure"
  3. Tick the "Enabled" checkbox
  4. Click "Save"
  5. Visit the Surveys page
  6. Click “Edit” next to the survey you would like to export data to Google Sheets from
  7. Scroll down to the "Integrations" section
  8. Tick the “Google Sheets” checkbox
  9. Paste the Sheet ID into the textbox
  10. Click "Save"

Note: Do not add/edit/delete data from the Google Sheet you've linked to GetReviews. GetReviews exports customer data to pre-defined column letters (i.e. first name goes into column A, last name goes into column B, etc.) If you delete Column A, GetReviews would still print first name to Column A even though Column A is now last name. If you would like to modify data, either mirror the data to a new sheet, or export and modify.