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.
How to enable integration?
To send survey responses to Google Sheets, you need to do two things:
🔐 Authorize the integration
📊 Choose the sheet you want to integrate in the settings of your survey
1. Authorizing the integration
To connect Survicate with Sheets go to ⚙️Settings > 🔗Integrations, find Google Sheets on the list and click Authorise button:
2. Sending responses to Google Sheets
To send responses to Google Sheets go to the ⚙️Settings tab of your survey and open the Google Sheets Integration tab. There you can choose Spreadsheet within this spreadsheet to sync your survey responses.
You can integrate your surveys with the same spreadsheet.
The moment you start collecting new responses, you'll see them flowing into the automatically created sheet in your selected spreadsheet.
❗️ Also please make sure that the account you have integrated has the ownership of the spreadsheet you'd like to choose.
❗️ Please note that Google Sheets integration is available starting from the Essential plan.
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.