- Media library
- Question limits
- Creating a survey from MS Word doc
- How to edit live surveys
- Survey blocks
- Survey block randomizer
- Question randomization
- Scale Library
- What is monadic testing?
- What is sequential monadic testing?
- Extraction Support for Image Chooser Question Types
- What is comparison testing?
- Custom validation messages
- Survey Builder with QxBot
- Testing Send
- Survey Preview Options
- Standard question types
- Advanced question types
- Multiple choice question type
- Text question- comment box
- Matrix multi-point scales question type
- Rank order question
- Smiley-rating question
- Image question type
- Date and time question type
- CAPTCHA question type
- Net Promoter Score question type
- Van Westendorp's price sensitivity question
- Choice modelling questions
- Side-By-Side matrix question
- Homunculus question type
- Predictive answer options
- Presentation text questions
- Multiple choice: select one
- Multiple choice: select many
- Page timer
- Contact information question
- Matrix multi-select question
- Matrix spreadsheet question
- Closed card sorting question
- Flex Matrix
- Text Slider Question Type
- Graphical Rating Scales
- Rank Order - Drag and Drop
- Bipolar Matrix - Slider
- Bipolar Matrix Likert Scale
- Gabor Granger
- Verified Digital Signature
- Star Rating Question Type
- Push to social
- Attach Upload File Question
- Constant Sum Question
- Video Insights
- Platform connect
- Communities Recruitment
- TubePulse
- Open Card Sorting
- Map Question Type
- Answer type
- Reorder questions
- Question tips
- Text box next to question
- Text question settings
- Adding other option
- Matrix question settings
- Image rating question settings
- Scale options for numeric slider question
- Constant sum question settings
- Setting default answer option
- Exclusive option for multiple choice questions
- Validate question
- Bulk validation settings
- Remove validation message
- Question separators
- Question Code
- Page breaks in survey
- Survey introduction with acceptance checkbox
- RegEx Validation
- Question Library
- Embed Media
- Slider Start Position
- Answer Display - Alternate Flip
- Matrix - Auto Focus Mode
- Text validations
- Numeric Input Settings- Spreadsheet
- Answer Groups
- Hidden Questions
- Decimal Separator Currency Format
- Allow Multiple Files - Attache/Upload Question Type
- Text box - Keyboard input type
- Deep Dive
- Answer Display Order
- Alternate colors
- Add logo to survey
- Custom Themes
- Display Settings
- Auto-advance
- Progress bar
- Automatic question numbering option
- Enabling social network toolbar
- Browser Title
- Print or export to PDF, DOC
- Survey Navigation Buttons
- Accessible Theme
- Back and Exit Navigation Buttons
- Focus Mode
- Survey Layout
- Survey Layout - Visual
- Telly Integration
- Telly Integration
- Workspace URL
- Classic Layout
- Branching - Skip Logic
- Compound Branching
- Compound or delayed branching
- Response Based Quota Control
- Dynamic text or comment boxes
- Extraction logic
- Show or hide question logic
- Dynamic show or hide
- Scoring logic
- Net promoter scoring model
- Piping text
- Survey chaining
- Looping logic
- Branching to terminate survey
- Logic operators
- Selected N of M logic
- JavaScript Logic Syntax Reference
- Block Flow
- Block Looping
- Scoring Engine: Syntax Reference
- Always Extract and Never Extract Logic
- Matrix Extraction
- Locked Extraction
- Dynamic Custom Variable Update
- Advanced Randomization
- Custom Scripting Examples
- Survey settings
- Save & continue
- Anti Ballot Box Stuffing (ABBS) - disable multiple responses
- Deactivate survey
- Admin confirmation email
- Action alerts
- Survey timeout
- Finish options
- Spotlight report
- Print survey response
- Search and replace
- Survey Timer
- Allowing multiple respondents from the same device
- Text Input Size Settings
- Admin Confirmation Emails
- Survey Close Date
- Respondent Location Data
- Review Mode
- Review, Edit and Print Responses
- Geo coding
- Dynamic Progress Bar
- Response Quota
- Age Verification
- Tools - Survey Options
- Live survey URL
- Customize survey URL
- Create email invitation
- Personalizing emails
- Email invitation settings
- Email list filter
- Survey reminders
- Export batch
- Email status
- Spam index
- Send surveys via SMS
- Phone & paper
- Adding responses manually
- SMS Pricing
- Embedding Question In Email
- Deleting Email Lists
- Multilingual Survey Distribution
- SMTP
- Reply-To Email Address
- Domain Authentication
- Email Delivery Troubleshooting
- QR Code
- Survey Dashboard - Report
- Overall participant statistics
- Dropout analysis
- Pivot table
- Turf analysis
- Trend analysis
- Correlation analysis
- Survey comparison
- Gap analysis
- Mean calculation
- Weighted mean
- Spider chart
- Cluster Analysis
- Dashboard filter
- Datapad
- Download Options - Dashboard
- HotSpot analysis
- Heatmap analysis
- Weighted Rank Order
- Cross-Tabulation Grouping Answer Options
- A/B Testing in QuestionPro Surveys
- Data Quality
- Data Quality Terminates
- Matrix Heatmap Chart
- Column proportions test
- Response Identifier
- TURF Reach Analysis
- Bulk Edit System Variables
- Weighting and balancing
- Conjoint analysis designs
- Conjoint part worths calculation
- Conjoint calculations and methodology
- Conjoint attribute importance
- Conjoint profiles
- Market segmentation simulator
- Conjoint brand premium and price elasticity
- What is MaxDiff scaling
- MaxDiff settings
- Anchored MaxDiff Analysis [BETA Release]
- MaxDiff FAQ
- MaxDiff- Interpreting Results
- Automatic email report
- Data quality - Patterned responses
- Data quality - gibberish words
- Import external data
- Download center
- Consolidate report
- Delete survey data
- Data quality - All checkboxes selected
- Exporting data to Word or Powerpoint
- Scheduled reports
- Datapad
- Notification Group
- Unselected Checkbox Representation
- Merge Data 2.0
- Plagiarism Detection
- IP based location data
- SPSS Export
- SPSS variable name
- Update user details
- Update time zone
- Teams
- Add Users
- Usage dashboard
- Single user license
- License restrictions
- Troubleshooting login issues
- Software support package
- Welcome Email
- User Roles & Permissions
- Bulk Add Users
- Two-Factor Authentication
- Network Access
- Changing ownership of the survey
- Unable to access Chat support
- Navigating QuestionPro Products
- Agency Partnership Referral Program
- Response Limits
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.
How to connect your Google Sheets account to QuestionPro?
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.
Note: The responses will be exported to the Google Sheet using the system-defined timezone, which is Greenwich Mean Time (GMT).
FAQ's:
Can I connect multiple Google accounts with QuestionPro?
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.
Can I integrate multiple surveys with 1 Google sheet?
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.
Can I export the responses in any desired timezone?
Currently, QuestionPro allows to export the responses to Google sheets only in Greenwich Mean Time (GMT).
License
This feature is available with the following licenses :
