Overview

Integration Setup   

To integrate your form with Google Sheet,

1. Navigate to the Integrations tab under Sheet & Calendar select Google Sheets.

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

7. You can choose to store all the file attachments and signatures received via your form in Google Drive.
   

8. Click Save.
   
   
   

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.

Integration Settings

Set Alert on Integration Failure