Zoho Sheet
This integration automatically pushes your responses from your survey into Zoho Sheet when your respondents submit their responses.
Why should Zoho Sheet Integration be used?
Using Zoho Sheet integration, you can push the responses from Zoho Survey to a Zoho Sheet, 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 Zoho Sheet integration for individual surveys. Follow the steps below to enable the prerequisites:
Log in to Zoho Survey and navigate to Manage Portal.
Click Apps & Services.
Click Connect for Zoho Sheet.
How To integrate your survey with Zoho Sheets
Navigate to Builder >Hub >Integrations, then click Integrate for Zoho 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 Zoho Sheet and click Next.
You can also sync existing responses from an active survey in the integration by enabling the checkbox.
How to map responses to Zoho 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 re-arranged, 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 change the format for the Date field question in the survey while mapping it in the Zoho Sheet.
Click Save once you're done mapping.
How To use Custom Scripts in Zoho 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 Zoho Sheet to design outputs that'll enhance your response analysis and reports
Follow the steps below to use a custom script in Zoho Sheet Integration:
Once all the questions have been added to your survey, click the + icon and add a new question
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.
Click on the View Sheet option, and you'll be able to view the spreadsheet
How to remove the integration with Zoho Sheets
Navigate to Builder >Hub >Integrations, then click Manage.
Click the Remove Integration button, then give confirmation in the prompt.
How to disconnect Zoho Sheets from Zoho Survey
Log in to Zoho Survey and navigate to Manage Portal.
Click Apps & Services.
Select Zoho Sheets, then click Disconnect.
Note:
Once disconnected, the integration between Zoho Survey and Zoho Sheet will cease to exist, and responses won't get synced.
Access
Zoho Sheet integration can be enabled in your Zoho Survey account with the Plus, 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
Edit Default Message
With Zoho Survey, you can create and customize surveys, as well as translate them to different languages. Zoho Survey supports 135 languages, of which 91 are completely supported and 44 are partially supported. In addition to translating survey ...Pipedream - Zoho Survey Integration
Pipedream is a powerful automation tool that can integrate thousands of apps and workflows in a single console. Using PipeDream, you can integrate Zoho Survey with any other app which isn't directly available for integration with Zoho. Integrate Zoho ...Zoho Desk
This integration automatically lets you create tickets when a survey response is submitted. Why should Zoho Survey be integrated with Zoho Desk You are a restaurant owner and wish to dynamically create tickets when a customer feedback survey is ...Create a Collector for Zoho Campaigns/ Zoho Marketing Automation
Overview Use this collector to send survey invitations to your campaign audience directly through Zoho Campaigns/Zoho Marketing Automation, embedded within your existing email without any additional distribution setup. How to create a collector for ...Encryption in Zoho Survey
Encryption is primarily used to safeguard the contents of a message so that only the intended recipient can read it. This is done by replacing the contents with unrecognizable data, which can only be understood by the intended recipient. This is how ...
New to Zoho LandingPage?
Zoho LandingPage Resources