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

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 


    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








                                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

                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                        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







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • 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