Integrate Zoho Survey With Google Sheet - Online Help Guide

Google Sheets

Similar to the Zoho Sheet integration, this integration automatically pushes your responses from your survey into a Google spreadsheet when your respondents submit their responses. Map your survey responses into a new spreadsheet or to a new sheet in an existing spreadsheet.

To integrate your survey with Google Sheets:

  1. Click the Hub tab.
    Hub
  2. Click the Integrations section.
    Integrations
  3. Click Integrate in the Google Sheets section.
    google-sheets-integration
  4. Click Integrate to agree to the terms of service and privacy policy.
    google-sheets-integration-confirm
  5. Authenticate your Google account and link it to your Zoho Survey account.
    google-sheets-integration-permissions
  6. Choose an integration option:
    1. 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.
    2. 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, and select a survey to use. 
  7. Click Save.
    Google Sheet integration with Zoho Survey
You can enable all or only certain responses to be added to your sheet. Additionally, you can arrange and order these fields as needed, and can customize the column header labels for the selected fields.
Select the questions that have to be added to the sheet and save.

To view the responses on a spreadsheet:

  1. Click the Integrations section in the Hub tab.

  2. Click Edit in the Google Sheets section. 
    google-sheets-edit
  3. Click View Sheet after integrating your survey with Google Sheets.
    google-sheets-integration-view-sheet
  4. Log on to your Google account and find the spreadsheet with the record of responses. If you change the alignment or order of questions in your survey, the changes won't be reflected on the sheet. If you add or delete a row/column in the sheet, the alignment of collected responses will also vary.

To remove the integration with Google Sheets: 

  1. Click the Hub tab. 
    Hub 
  2. Click the Integrations section.
    Integrations 
  3. Click Remove Integration in the Google Sheets section. 
    google-sheets-remove-integration
  4. Click Remove
    google-sheets-integration-remove-confirm 

Disconnection

Disconnecting Google Sheets and Zoho Survey will stop all your existing surveys from pushing data to Google Sheets. The permissions you've provided to Zoho Survey to make changes to your Google Sheets (by pushing responses to it) will be revoked. 

To disconnect Google Sheets and Zoho Survey:

  1. Go to Setup under your Profile in the top right corner of your screen. 
    Setup 
  2. Click Apps and Services
    google-sheets-apps-services
  3. Click Disconnect in the Google Sheets section.
    google-sheets-disconnect
  4. Click Yes, Disconnect Integration.  
    google-sheets-integration-disconnect-confirm 


    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 CRM Training
        Redefine the way you work
        with Zoho Workplace

          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 CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION





                          Quick LinksWorkflow AutomationData Collection
                          Web FormsEnterpriseBegin Data Collection
                          Interactive FormsWorkplaceData Collection App
                          CRM FormsCustomer ServiceAccessible Forms
                          Digital FormsMarketingForms for Small Business
                          HTML FormsEducationForms for Enterprise
                          Contact FormsE-commerceForms for any business
                          Lead Generation FormsHealthcareForms for Startups
                          Wordpress FormsCustomer onboardingOrder Forms for Small Business
                          No Code FormsConstructionRSVP tool for holidays
                          Free FormsTravel
                          Prefill FormsNon-Profit

                          Intake FormsLegal
                          Mobile App
                          Form DesignerHR
                          Mobile Forms
                          Card FormsFoodOffline Forms
                          Assign FormsPhotography
                          Mobile Forms Features
                          Translate FormsReal EstateKiosk in Mobile Forms
                          Electronic Forms

                          Notification Emails for FormsAlternativesSecurity & Compliance
                          Holiday FormsGoogle Forms alternative GDPR
                          Form to PDFJotform alternativeHIPAA Forms
                          Email Forms
                          Encrypted Forms
                          Embeddable Forms
                          Secure Forms
                          Drag & drop form builder
                          WCAG



                                            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.




                                                Manage your brands on social media


                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • 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: Click the Hub tab. Click the Track section. Click Create in the Google Tag Manager section. Enter ...
                                                                                                              • 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.
                                                                                                              • What is the main difference between Google Docs and Zoho Survey?

                                                                                                                Google Docs and Zoho Survey are two totally different products developed for different purposes. Zoho Survey helps you create questionnaires, mainly to collect feedback. It has advanced features, such as logic and trigger emails, and lets you perform ...
                                                                                                              • Zapier

                                                                                                                Integrate Zoho Survey with all the applications you use through Zapier. You will be able to connect your survey account to different applications and execute various actions every time a survey is submitted. You can receive instant alerts in your ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources