Google Sheets Integration

QuestionPro's Google Sheets integration allows you to easily export your survey responses directly into Google Sheets, helping you manage and analyze your responses in real time. With this integration, you can automatically create new sheets, streamline your workflow, and maintain up-to-date records of your survey responses without manual data entry.

This guide will walk you through setting up the integration, managing your data exports, and navigating recent updates to Google’s authentication policies to ensure a smooth experience.

As part of Google’s recent updates to its drive access policies, QuestionPro will no longer support the /drive scope for Google Drive integration. Instead, we’ll be using the more secure /drive.file scope, which limits access to only the files created through the integration.

Starting October 17th, 2024, your current setup will work for another 60-90 days. After that, to keep your integration running smoothly, you’ll need to follow these easy steps:

1. Reconnect your Google account to QuestionPro.
2. Create a new Google Sheet directly from the QuestionPro platform.
3. Export your existing data into this new sheet.

This process ensures your data remains accessible in Google Sheets. However, please note that once you reconnect, pushing data into your existing sheet will no longer be possible. You'll need to use the new sheet for future exports.

These changes are designed to improve your data security by following Google’s latest guidelines on file access.

To connect your Google Sheets account and automatically push survey responses in real-time, follow the steps outlined below:

• Go to Login » Survey » Edit
• Click on the Integration tab:

• Click on the Google Sheets tile under the Integration tab.

• Click on the Sign in with Google button.

• In the pop-up window, select the Google account you want to connect or login to a new one.

• Click on the Continue button.

• Click on the Allow button.

• Your Google account will be connected to QuestionPro. Now you'll need to select and existing sheet or create a new one by click on the Create New Sheet button

• On the next screen, provide the name for your Google sheet, select the toggles based on the requirement, and then click on the Create button.

• The integration is complete. You'll see the following screen displaying the details of the integration:

• Once a sheet is created, existing response data will be added to the sheet if you have enabled the toggle for the same. The new responses will be updated in the selected sheet in real-time after every response is submitted on the survey.

You can connect only 1 Google account with QuestionPro. The connected Google account will be avaialble for all of your surveys to allow you integrate different surveys with your Google sheets account.

Yes, you can connect multiple surveys with 1 Google sheet. But this is not recommended as this interrupts the simultaneous data flow to multiple sub-sheets. The ideal way would be integrating a single survey with 1 Google sheet.