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,
setting up Google Sheets integration
t the information you wish to add to the spreadsheet from the following options under
: 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.
: 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.
: 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
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.
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.
Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.
Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.
Make the most of Zoho CRM with these useful tips.