Google Sheets Integration | Integration Settings - Zoho Forms

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 , selec t 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.


Zoho Forms - Google Sheets Integration - Integration Settings

    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

                                                          • 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 ...
                                                          • Salesforce Integration

                                                            With the Zoho Forms and Salesforce integration, you can automatically push your form data into Salesforce objects when a respondent fills out your form. Y ou can push form entries to the following Salesforce objects: Leads Contacts Accounts ...
                                                          • 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 ...
                                                          • Zoho Campaigns Integration

                                                            If you are looking to automate adding contacts to the mailing lists in your Zoho Campaigns account instead of adding them manually, use the Zoho Forms - Zoho Campaigns integration. With this integration, you can directly add form respondents as ...
                                                          • 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 ...

                                                          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