Import Data from Zoho Forms

  1. How do I integrate Zoho Forms and Zoho Analytics using Zoho Sheet?
  2. How frequently can I synchronize my data with Zoho Analytics?
  3. There are a few data mismatches between my data available on Zoho Forms and Zoho Analytics. What could be the possible reasons?

1. How do I integrate Zoho Forms and Zoho Analytics using Zoho Sheet?

You can integrate Zoho Forms and Zoho Analytics using Zoho Sheet by following the below steps:

  1. Integrate Zoho Forms with Zoho Sheet. Please refer to the Import from Zoho Forms - Zoho Sheet Integration user document to know more.
  2. Connect Zoho Sheet with Zoho Analytics. Please refer to the Import from Zoho Docs/Zoho Workdrive user document to know more.

2. How frequently can I synchronize my data with Zoho Analytics?

Periodic synchronization between Zoho Analytics and Zoho Sheet will be scheduled, based on the schedule interval provided by you during import. 

If you are a Basic Plan user of Zoho Analytics, you can synchronize your data once every day. If you are a user of the Standard Plan or above, you can choose to synchronize your data at one of the hourly intervals mentioned below.

  • 3 Hours
  • 6 Hours
  • 12 Hours
  • Every day

You can edit this interval anytime using the Edit Setup link available on the Data Sources page.

3. There are a few data mismatches between my data available on Zoho Forms and Zoho Analytics. What could be the possible reasons?

Case 1: Zoho Forms - Zoho Sheet

Any new entries made in Zoho Forms will be immediately added to Zoho Sheet. However, any data changes made to existing rows, such as editing or deleting row, in Zoho Forms will not be synced with Zoho Sheet. This might cause data mismatch between Zoho Forms and Zoho Sheet.

Case 2: Zoho Sheet - Zoho Analytics
There is no direct connection between Zoho Forms and Zoho Analytics. All the data sync is via Zoho Sheet. Any data changes made in Zoho Sheet (it is possible to edit the Zoho Forms data in Zoho Sheet), will be reflected in Zoho Analytics. This could also cause a data mismatch between Zoho Forms and Zoho Analytics.

Data in Zoho Forms

Data in Zoho Sheets

Data in Zoho Analytics