Through the Google Sheets Integration feature, you can instantly sync survey responses to Google Sheets spreadsheets, facilitating subsequent analysis and sharing, eliminating the hassle of manual export.
The Google Sheets Integration feature supports creating new files, and it will create a dedicated folder in your Google account for centralized management. Even if data is missing midway, it can be replenished through the re-sync function, ensuring complete and accurate records.
How to use Google Sheets Integration
Enter the "Build" page, click "Integration" in the left sidebar and open the "Google Sheets" Integration field.
Click the enable button, then select the account you want to connect.
The system will guide you through Google authorization, please click "Continue".
When binding your account for the first time, please remember to check the box to agree to the authorization scope and then click "Continue".
After successful authorization, the settings window will open. The system will create a new Google Sheet for you. The default file name is: {Survey ID}_{Survey Title}, or you can enter your own file name.
After clicking save, the system will automatically:
Create a "SurveyCake Responses" folder in your Google Drive
And create a survey-specific folder within that folder. The folder naming convention is: {Survey ID}_{Survey Title}
Create a new spreadsheet file in the survey folder, with the survey title as the default name.
After completing the above settings, the Google Sheets Integration feature will show as enabled, which means the integration is complete!
Next, you can fill out the survey, and the responses will be automatically written to Google Sheets!
When survey responses are imported via webhook, the timezone is automatically adjusted to +0. Therefore, there will be a discrepancy between the response times displayed in Google Sheets and the SurveyCake backend. SurveyCake backend displays the correct response time, but the response time in Google Sheets will be 8 hours less than Taiwan time. Therefore, you will need to manually adjust the timezone in Google Sheets using a formula to account for the time difference.
Common Questions
What if the survey receives a large number of responses in a short period?
Due to Google Sheets API usage limits, SurveyCake needs to control the writing speed to ensure data stability. Google official documentation for details
Under normal circumstances: Responses will be synchronized to your Google Sheets in real-time, usually within a few seconds.
During high traffic: If a large number of surveys are filled out in a short period, the system will write responses to the spreadsheet at a rate of approximately 1 response per second. So if your survey suddenly receives a large number of responses, it may take some time to complete the synchronization.
Some responses in the survey are not in the integrated spreadsheet, what can I do?
In extremely high traffic situations, individual responses may occasionally be missed. In this case, you can go to the "Integration" page, and under the Google Sheets function column, click "Resync responses". The system will re-import all responses (including those that may have been missed before).
What if the data volume exceeds the Google Sheets file limit?
A single Google Sheet file can have a maximum of 10 million cells or 18,278 columns. When the data volume exceeds this limit, the system will automatically create a new file in the original file path's folder. File naming rule: {Original file name}_part{number}, where the number starts from 02 and increases sequentially. File name examples:
Original file: a83fjk2d_Customer Satisfaction Survey
Second file: a83fjk2d_Customer Satisfaction Survey_part02
Third file: a83fjk2d_Customer Satisfaction Survey_part03
Summary
Through Google Sheets Integration, your survey responses can be instantly synchronized to spreadsheets, facilitating centralized management and subsequent analysis.
