Google Sheets Integration | Zoho Forms - User Guide

Google Sheets Integration


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.

Integration Setup   

To integrate your form with Google Sheet,

  1. Navigate to the Integrations tab and click Google Sheets from the left side 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.


  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. You can choose to store all the file attachments and signatures received via your form in Google Drive.

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

    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 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 ...
                                                          • 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 ...
                                                          • 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 ...
                                                          • Google Drive

                                                            Your form attachments will be saved to Google Drive when you choose this option.  To do this,  In your form builder, go to  Settings  and choose  Manage Form Attachments  from the left menu.  Choose  Google Drive  service. Authenticate  Zoho Forms to ...
                                                          • 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, select the ...

                                                          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