Google Sheets integration allows you to send responses in real-time to a specified Sheet of your choice. With the integration enabled you can organize and analyze results the way you desire.

The integration allows you to: 

  • Connect Google Sheet to data visualization apps like Google Data Studio or Geckoboard to create interactive dashboards & beautiful reports based on data from multiple surveys
  • Easily access & share your survey real-time data.

Depending on the survey type you are enabling the integration, the steps will be different. Please chose which survey type you'd like to enable the integration for:

  1. How to enable for a link, email or website survey
  2. How to enable for a mobile app or Intercom messenger survey

❗️ Please note that Google Sheets integration is available starting from the Essential plan. If you are interested in testing this integration contact sales@survicate.com, or reach out to our team from live chat.

1. Go to the Connect tab of your survey, find, and pick Google Sheets from the list of integrations.

2. Click the Connect button to set up the authorization.

3. A pop-up window will appear for you to log in to your Google account. If you don't see the pop-up window, you may need to allow pop-ups in your browser - please look for the settings in your browser URL bar, or use instructions for Chrome, Firefox, Opera, Edge, or Safari.

4. After authorization, move on to the Settings tab of Google Sheets integration, and click Connect a sheet button

5. Then select the spreadsheet you'd like to connect your survey from the opened window.

❗️ Also please make sure that the account you have integrated has the ownership of the spreadsheet you'd like to choose.

The moment you start collecting new responses, you'll see them flowing into the automatically created sheet in your selected spreadsheet.

Enable Google Sheets integration for a mobile app or Intercom messenger survey

1. Go to ⚙️Settings > 🔗Integrations from the upper right of the panel, find Google Sheets on the list, and click Authorize button:

2. To send responses to Google Sheets go to the ⚙️Settings, or Survicate Settings tab of your survey and open the Google Sheets Integration tab.

3. Click Connect sheet button and select the spreadsheet you'd like to connect your survey from the opened window.

❗️ Also please make sure that the account you have integrated has the ownership of the spreadsheet you'd like to choose.

The moment you start collecting new responses, you'll see them flowing into the automatically created sheet in your selected spreadsheet.

Here is an example of how a spreadsheet will look like:

Why is my Google Sheets integration not working?

If you are having problems with your Google Sheets integration, it's likely to be due to two causes: 

1. You've made modifications to your sheet name.
Please never change the sheet name which is automatically created. This will distort the integration.

2. You've reached the maximum row limit on your sheet.
Make sure that you've not reached a maximum row limit in your sheet - in that case, data would not be sent. See the official guide here

If none of the above applies to your case, please reauthorize integration in the Settings - Integrations. Then, try to answer your survey and check if the data is sent to Google Sheets. If not - please contact our Support team right in the panel.

Did this answer your question?