The Google Sheets - Survicate integration lets you sync survey data to Google Sheets in real time to easily access and share your survey data from the selected sheet.
It's possible to connect each survey to a separate spreadsheet or merge results from multiple surveys into one.
You can further connect Google Sheets to data visualization apps like Looker Studio (formerly Google Data Studio) or Geckoboard to create interactive dashboards & beautiful reports based on data from multiple surveys
🚀 In this guide, we'll explain step-by-step how to achieve it and make the most of the integration.
Note that Google Sheets integration is available on some of our paid plans. If it's not included in your subscription and you want to test this integration, please contact sales@survicate.com or our team via live chat.
Create your survey
In this paragraph, you'll learn how to create, configure, and set your survey live.
1. Click on + Create new survey, select any creation method (a template, using AI survey creation, or adding your own questions), and any survey type:
You can find a brief description of our survey types below.
Email or shareable link survey: Allows you to get shareable survey links or embed surveys directly inside emails.
Website or in-product surveys: Lets you run targeted surveys on websites or in-product.
Mobile app surveys: Enables collecting feedback from mobile app users inside iOS or Android apps.
In-platform surveys: Designed to survey users directly via pop-ups launched from Intercom Messenger surveys or in a Braze in-App message campaign.
For more in-depth instructions on creating your survey, check out this article.
2. You can send a survey via any CRM, show it on your website, in product, or in your Mobile app. The Google Sheets integration works with all survey types.
3. You can decide to collect anonymous feedback or identify respondents. In case of identified users, you'll see their personal information next to their responses in the Google Sheet.
4. After adding your questions and configuring the survey to your requirements, you can connect it to your Google Sheets account.
We'll describe how to set it up in the next sections.
Connect Google Sheets integration
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 select how you'd like to connect the sheet.
Send responses to a new spreadsheet
1. To send your responses to a new sheet, click Create new sheet. We will create a new file in your Google Drive.
2. You can move to your new sheet by choosing the View Sheet button. If you need to replace the file, select the Disconnect sheet option.
Send responses to the existing sheet
1. If you have already created a blank sheet in your Google account, you can now connect the survey to this spreadsheet. In Settings, choose the Use existing sheet option.
Please note that connecting a sheet, that already has data, to the integration, will empty the sheet and clear all the information.
2. Go to the sheet you'd like to pass the responses to and copy the URL from the access bar:
3. Paste into the URL field, and click Connect. You will see a green notification that your survey is connected to Google Sheets.
❗ If you are using an existing sheet, make sure to have editor permissions on the sheet you are trying to connect.
4. You can move to your new sheet by choosing the View Sheet button. If you need to replace the file, select the Disconnect sheet option.
❗ If you connect a filled-out Google Sheet to a survey, we will clear this sheet to start syncing the responses from the first row.
Merge multiple Survicate survey responses into one Google Sheet
If you're running multiple Survicate surveys and want to combine their responses into a single master sheet, here's a step-by-step guide to automate this process.
Prerequisites Steps
Set Up Survicate-to-Sheets Connections:
Open each Survicate survey you want to track
Go to Integrations → Google Sheets
Connect each survey to a separate Google Sheet
Note: Each survey needs its own individual connection to Google Sheets
Gather Your Sheet IDs:
Open each Google Sheet connected to Survicate
Copy the ID from the URL (it's the long string between /d/ and /edit)
You'll need IDs for all source sheets and your target sheet
Setting Up the Merger
Create a Master Sheet:
Create a new Google Sheet that will store all responses
Copy its ID from the URL
Set Up the Script:
Open your master Google Sheet
Go to Extensions → Apps Script
Delete any code in the editor
Paste the code below
function mergeSheets() {
// Get source spreadsheets
var sheet1 = SpreadsheetApp.openById('YOUR_FIRST_SURVICATE_SHEET_ID');
var sheet2 = SpreadsheetApp.openById('YOUR_SECOND_SURVICATE_SHEET_ID');
// Get target spreadsheet and its first sheet
var masterSheet = SpreadsheetApp.openById('YOUR_MASTER_SHEET_ID');
var targetSheet = masterSheet.getSheets()[0];
// Clear existing data
targetSheet.clear();
// Get the actual sheets from the spreadsheets
var sourceSheet1 = sheet1.getSheets()[0];
var sourceSheet2 = sheet2.getSheets()[0];
// Get the data range for each sheet
var data1 = sourceSheet1.getDataRange().getValues();
var data2 = sourceSheet2.getDataRange().getValues();
// Skip header row in data2 by slicing from index 1
var data2WithoutHeader = data2.slice(1);
// Log the data sizes for debugging
Logger.log("Sheet 1 rows: " + data1.length + ", columns: " + data1[0].length);
Logger.log("Sheet 2 rows (without header): " + data2WithoutHeader.length + ", columns: " + data2WithoutHeader[0].length);
// Write data1 (including header) to master sheet
targetSheet.getRange(1, 1, data1.length, data1[0].length).setValues(data1);
// Write data2 (without header) below data1
targetSheet.getRange(data1.length + 1, 1, data2WithoutHeader.length, data2WithoutHeader[0].length).setValues(data2WithoutHeader);
}
3. Replace the IDs:
Replace 'YOUR_FIRST_SURVICATE_SHEET_ID' with the ID of your first Survicate responses sheet
Replace 'YOUR_SECOND_SURVICATE_SHEET_ID' with the ID of your second Survicate responses sheet
Replace 'YOUR_MASTER_SHEET_ID' with your target sheet ID
4. Deploy
Click the Deploy button, select "New deployment"
Select type "Web app"
Click Deploy on the modal window again
Google will ask for permissions
Click "Review Permissions"
Choose your Google account
Click "Allow"
Setting Up Automatic Updates
Since Survicate continuously collects responses, you'll want to set up automatic merging:
In the Apps Script editor, click the clock icon (Triggers)
Click Add Trigger.
Configure the trigger:
Choose function: mergeSheets
Choose which deployment: Head
Select event source: Time-driven
Select type of time: Daily (recommended)
Choose a time of day that works for your reporting needs
Click Save.
Important Notes
Ensure each Survicate survey is properly connected to its own Google Sheet first
The script keeps headers from the first sheet only
The script will clear and update the master sheet each time it runs
Both source sheets should have matching column structures from Survicate
The master sheet will be refreshed daily (or according to your trigger settings)
Troubleshooting
If you encounter issues:
Make sure all sheet IDs are put inside single quotes, example:
var sheet2 = SpreadsheetApp.openById('1KHT0nNCzeDfAW--YYK2cYysPy7iCM11sB6CKfczVr1Q');Verify all Survicate-to-Sheets connections are working
Check that all sheet IDs are correct
Ensure you have proper access to all sheets
Look at the execution log in Apps Script for error messages
Check your Google Sheets quotas if working with large surveys
Analyze your survey results
While your survey collects responses, Survicate syncs them to the connected Google Sheet in real time.
Keep on reading if you're wondering how the data will be presented in your spreadsheet 🚀
Every spreadsheet will include columns informing you of:
The response time (UTC, time zone) and date;
The respondent's unique UUID;
User Agent (to identify the respondent's device and environment);
URL from which the survey was submitted;
The respondent's basic information, if you're collecting it with your survey:
Next, you will see all the survey's questions, either with a provided response, or empty, if a respondent skipped a part of the survey (due to Survey logic, or if they closed the survey):
After the answers, we show:
Information about the language the respondent answered in (if your survey is multilingual)
Date (if your survey has an Expiration date set up)
Additional respondent attributes you passed to Survicate:
Troubleshooting
My Google Sheets integration is not working
If you are having problems with your Google Sheets integration, it's likely to be due to two causes:
You've made modifications to your sheet name.
Please never change the sheet name, which is automatically created. This will distort the integration.You've reached the maximum row limit on your sheet.
Ensure you've not reached a maximum row limit in your sheet - in that case, data will not be sent. See the official guide here.
Some survey answers are missing in the connected Google Sheet
Please don't rearrange or delete columns or rows in the sheet connected to Survicate - our integration operates on column and row order, and when any changes are applied, it can cause problems.
In addition, answers to your survey's Matrix questions will not appear in Google Sheets, as at the moment, this integration does not support this question type.
If none of the above applies to your case, please reauthorize integration in Integrations. Then, try to answer your survey and check if the data is now sent to the Google Sheets spreadsheet correctly. If not - please get in touch with the Support team.
📞 If you have any questions about Google Sheets Integration - feel free to reach out to our team via chat or email: support@survicate.com.
Related search queries: googlesheets