Google Sheets
This integration automatically pushes your responses from your survey into a Google spreadsheet when your respondents submit their responses.
Why should Google Sheet Integration be used?
Using the Google sheet integration, you can push the responses from Zoho Survey to a sheet and then further into a third party tool to generate advanced analytics.Similarly, you can also employ custom script and modify data received from responses into another form.
Pre- Requisites
The following pre-requisties must be completed before enabling Google Sheet integration for individual surveys. Follow the steps below to equip pre-requisites:
Log in to Zoho Survey and navigate to Manage Portal.
Click Apps & Services.
Select Google Sheets.
Accept Zoho's Terms & Conditions by clicking Integrate.
Sign in and authenticate the Google account where you wish to host Google Sheets and link it to your Zoho Survey account.
How To integrate your survey with Zoho Sheets
Navigate to Builder >Hub >Integrations, then click Integrate for Google Sheet.
Choose an integration option:
- Click Create new spreadsheet and type in a name for the spreadsheet. The name of the survey will be displayed by default. You can either use the name of the survey or type in a new one.
- Click Choose an existing spreadsheet to push responses into an existing spreadsheet. Then enter a keyword in the Search bar to find the spreadsheet that you're looking for.
In the same page, select the questions and variables that should be pushed to Google Sheet, then click Next.
You can also sync existing responses from an active survey in the integration by enabling the checkbox.
How to map responses to Google Sheet
Once the questions and variables have been selected, you can map the responses to the respective columns. Here, you can:
Add Custom labels for each questions type, if required: You can provide custom labels as column headers. For example, if the question in the survey is Gender, but you want it to be renamed as Sex in the sheet, just type it as the custom label.
Rearrange the order of responses, if required: The order of the questions/responses as to be reflected in the sheet can be rearranged, unlike the order in the survey questionnaire.This helps to arrange responses in the order of priority while mapping in the sheet.
Change the date-time format,if required: You can also change the format for the Date field question in the survey while mapping it in the Google sheet.
Click Save once all the mapping has been done.
How to Use Custom Scripts in Google Sheet Integration
Custom scripts are short snippets of code that can be used to run a complex logic in your survey. It can be used in the integration of Zoho Survey and Google Sheet to design outputs that will enhance your response analysis and reports
Follow the steps below to use a custom script in Google Sheet Integration:
Once all the questions have been added to your survey, click on the + icon and add a new question.
Then use the custom script option to add the required custom script. You can also test run the code to ensure the logic works.
Read more about custom script implementation.
How to view responses on a spreadsheet
Navigate to Builder >Hub >Integrations, then click Manage for Google Sheet
Click the View Sheet option to view the spreadsheet
How to remove the integration with Google Sheets
Navigate to Builder >Hub >Integrations, then click Manage for Google Sheet.
Click the Remove Integration button, then give confirmation for the prompt.
How to disconnect Google Sheets from Zoho Survey
Log in to Zoho Survey and navigate to Manage Portal.
Click Apps & Services.
Select Google Sheets, then click Disconnect.
Note:
Once disconnected, the integration between Zoho Survey and Google Sheet will be removed, and responses won't get synced.
Access
Google sheet integration can be enabled in your Zoho Survey account with the Pro and Enterprise plans.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Custom Script using Deluge
Deluge is a scripting language specifically designed for the Zoho ecosystem. It stands for Data Enriched Language for the Universal Grid Environment and is tailored to help users automate tasks and customize applications across Zoho's suite of ...Custom Script using JavaScript
JavaScript is a powerful and widely-adopted programming language that excels in client-side scripting within web browsers. It allows developers to create dynamic and interactive web applications. In Zoho Survey, you can leverage JavaScript for ...Google Analytics
The events of the survey being tracked get listed within Events in their corresponding accounts. You can track the following events of your survey: Access to survey Access to survey from each page (Survey_[unique_id]_Page_[page_id]) Survey ...Google Tag Manager
Add various Google Tag Manager (GTM) codes to your live survey, to track the traffic that accesses your surveys. To link your GTM code to your survey: Navigate to Builder>Settings>Track. Click Create in the Google Tag Manager section. Enter the ...How do I unlink my survey from Facebook and Google?
You can unlink your Facebook and Google accounts from Zoho Surveys in a few easy clicks: Click Setup in your Zoho Survey account. Click Integration. Click Disconnect in the Google and Facebook sections.
New to Zoho LandingPage?
Zoho LandingPage Resources