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

                  Zoho SalesIQ Resources



                      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

                                                            To allow Google Analytics to generate reports and statistics on the traffic that comes into your surveys: Click the Hub tab. Click theTrack section. Click Create in the Google Analytics section. Enter the tracking code that you generate from Google ...
                                                          • 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 ...
                                                          • Portal Setup

                                                            The user info widget enables you to manage portals, departments, user accounts, and plan details. There are quick access links to various sections, and links to download the mobile apps right from within the widget. You can configure your survey's ...

                                                          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