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.
❗️ Please note that Google Sheets integration is available on some of the paid plans. If you are interested in testing this integration contact firstname.lastname@example.org, or reach out to our team from live chat.
Step 1. Go to the Connect tab of your survey, find, and pick Google Sheets from the list of integrations.
Step 2. Click the Connect button to set up the authorization.
Step 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.
Step 4. After authorization, move on to the Settings tab of Google Sheets integration, and select how you'd like to connect the sheet. You can 1️⃣ use an existing sheet, or 2️⃣ create a new sheet
1️⃣To send your responses to a new sheet, click "create new sheet". You will see a green notification that your survey is connected to a new sheet.
2️⃣ If you already have a spreadsheet you'd like to pass the survey responses, you can paste the URL of the sheet by clicking "Use existing sheet".
❗ If you are using an existing sheet, make sure to have editor permissions on the sheet you are trying to connect.
Go to the sheet you'd like to pass the responses, copy the URL from the access bar:
Paste into the URL field, click "Connect". You will see a green notification that your survey is connected to Google Sheets.
Step 5. If your survey already has collected responses, here you can decide whether or not you'd like to pass your past responses to the newly created sheet.
Step 6. Your survey is not successfully connected to Google sheet. You can go to the selected or created sheet by clicking "View Sheet", and disconnect the sheet anytime by clicking "Disconnect Sheet"
If you select to send your past response, you'll see them in the sheet in a brief moment. If you didn't send the past responses, the moment you start collecting new responses, you'll see them flowing into the sheet.
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.