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.
To integrate your form with Google Sheet,
Navigate to the Integrations tab in your form builder and click Google Sheets from the left menu.
If you have not authenticated Zoho Forms to connect with your Google account already, you will see an authentication pop-up. Click Authenticate Google.
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.
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.
You can choose to store all the file attachments and signatures received via your form in Google Drive.
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.
- 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.
- 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.
- 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.
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.