Google Sheets Integration

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.

Select an existing Google Sheet:

Please paste the Google Sheet link in the format https://docs.google.com/spreadsheets/d/{File ID}

For Google Sheets file links, you can directly copy the file URL, or go to the Google Sheets spreadsheet and copy the link from the "Share" dropdown menu in the upper right corner.

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!

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.

Notes on integrating existing Google Sheets

• If you are integrating an existing spreadsheet, the system will clear the content of the first worksheet in that spreadsheet and automatically write the responses to the first worksheet. Therefore, please ensure that you have backed up the existing data in the first worksheet.
• The system will automatically determine and write data to the first worksheet in the spreadsheet. Therefore, if you drag the order of the worksheets, the data will still only be written to the first worksheet in the order, not the original page.
• Please ensure that you have editor or higher permissions for the Google Sheet, otherwise the system will display an error message "You don’t have permission to access this file".
• If there are many responses, and data is missed due to API limitations during synchronization, you can use the "Resync responses" function to fill in the missing data and view the number of synchronized entries.

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