Google Sheets Integration | Zoho Forms - User Guide

Google Sheets Integration

Overview

If you are looking to automate storing your form responses in a sheet and save the time spent on manual entry of form data into the sheet, you can use the Zoho Forms - Google Sheets integration. With this integration, your form responses will automatically be stored in Google Sheets. If you have attachment and signature fields in your form, you can choose to save the files uploaded to these fields in Google Drive using this integration.
Sheet integration with form

Integration Setup   

To integrate your form with Google Sheet,

  1. Navigate to the Integrations tab in your form builder and click Google Sheets from the left menu.

  2. Click Integrate.

  3. If you have not authenticated Zoho Forms to connect with your Google account already, you will see an authentication pop-up. Click Authenticate Google.  

  4. Select the sheet to store your form responses from the below options:
    New sheet: Creates a new spreadsheet to store your form responses. Give the sheet a name of your choice in Sheet Name.
    Existing sheet:Stores form responses in a new spreadsheet of an existing Workbook. Select an existing workbook in Sheet Name.

    Integration Setup

  5. Under Integration Settings, you can choose to add additional information, such as Added Email ID, Referrer Name, Payment Information, etc., under separate dedicated columns in the sheet for each form entry pushed.

  6. If you have a Matrix Choice field (in Dropdown, Text Box, Number, Currency type) on your form, you can choose to send it's data into the sheet in any of the following 2 formats depending on how you want to analyze the data:

    1. Combine answers in a cell: In this format, all the choices selected within the Matrix Choice field are combined into a single cell in the exported data. This can be useful when you want a quick overview of the respondent's choices without the need for detailed analysis.
      In a single cel
    2. Provide individual cells for each answer : In this format, each selected choice within the matrix choice field is exported into a separate cell. This format provides a more detailed view of the respondent's choices and allows for more granular analysis.
      In separate cells
  7. You can choose to store all the file attachments and signatures received via your form in Google Drive.

  8. Click Save.

    Google Sheets Integration setup

Once integrated, all the form responses will be saved in both Zoho Forms and Google Sheets. As you add fields to your form, they will be automatically added to the spreadsheet.
Note:
  1. Data saved in Zoho Forms and Google Sheets are independent of one another. Editing the records in Zoho Forms will not alter the data in the Google spreadsheet.
  2. Entries from Subform will be pushed to Google Sheets and grouped under the Subform's name. File and image attachments from Subforms can also be pushed to Google Drive.
  3. Once saved, the columns in the spreadsheet cannot be removed. If you wish to deselect any of the information, the integration setup must be removed completely and reconfigured. The new integration can be configured to a new worksheet within the same spreadsheet or to a new spreadsheet.

To remove Google Sheets integration, click Remove Integration and confirm.

Integration Settings

In addition to all the fields in your form, you can also assign dedicated columns to view Added Email ID, Referrer Name, Payment Information, UTM Tracking parameters, and Geolocation details in the integrated spreadsheet.

To do this, while setting up Google Sheets integration, select the information you wish to add to the spreadsheet from the following options under 
Integration Settings:

Payment Information: This option adds the payment details like Payment Amount, Payment Status, Payment Currency, and Payment Merchant as separate columns to the spreadsheet, if you have a Payment field configured in your form.

UTM Tracking: This option adds the default UTM tracking parameters like utm_source, utm_medium, utm_campaign, utm_term, utm_content and the custom parameters as separate columns to the spreadsheet if you have enabled UTM tracking for your form.

Geolocation: This option adds the respondent location details like Submitters Location, Submitters Latitude, Submitters Longitude as separate columns to the spreadsheet if you have enabled the Geolocation option in your form.

Added Email ID: This option adds the email addresses of the respondents as a column in the spreadsheet if you have shared your form privately within an organization. The Added Email ID of the respondents filling out your form using its public link will be pushed as Unknown.

Referrer Name: This option adds the details of the source from which the form was filled as a separate column in the spreadsheet.

URL of Stored FilesIf you have configured to store your form attachments in a cloud service under Manage Form Attachments, enabling this option will include the link to the files saved in a designated cloud service within the respective columns of the Google Sheet, whether they are File Upload, Image Upload, or Audio/Video Upload fields. This makes it convenient to access and view these files directly from your Google Sheet.

    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









                                                                                                          • Related Articles

                                                                                                          • Google Calendar Integration

                                                                                                            By integrating Zoho Forms with Google Calendar, you can schedule meetings and events, and manage guests in your calendar. With this integration, you can push form entries as events to your Google Calendar and associate guests with the calendar ...
                                                                                                          • Saving attachments to Google Drive

                                                                                                            If your form has attachment and signature fields, you can choose to save them in Google Drive using this integration. To do this,   Select Yes to store file attachments and signatures under Google Drive. Select the Attachment and Signature fields ...
                                                                                                          • Zoho Sheet Integration

                                                                                                            Overview If you are looking to store your form responses in a sheet and save the time spent on manual entry of form data into the sheet, you can use the Zoho Forms-Zoho Sheet integration. With this integration, your form responses will automatically ...
                                                                                                          • Microsoft Teams Integration

                                                                                                            If you wish to trigger notifications of form entries in your Microsoft Teams channel, you can use the Zoho Forms - Microsoft Teams Integration. Using this integration, you can trigger message cards using a bot in a Microsoft Teams channel when you ...
                                                                                                          • Salesforce Integration

                                                                                                            Table of Contents Overview Integration Setup Supported Field Types Add Input Manually while mapping fields Trigger Actions while pushing form entries Set Alert on Integration Failure Overview With the Zoho Forms and Salesforce integration, you can ...
                                                                                                            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