SyncWith

Export data from Zoho Analytics to Google Sheets

Colin Dellow

Colin Dellow

Zoho Analytics data can be exported using their Export Data API. It’s a multi-step process. This tutorial will walk you through each step.

Get your Zoho Analytics workspace name

First, you need to authenticate to Zoho and get your workspace name.
Use the form below to do so - you’ll need to enter your email address.

List Zoho Analytics workspaces

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

workspaceId
workspaceName
workspaceDesc
orgId
createdTime
createdBy
createdByZuId
isDefault
isFavourite
         
         
         

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards

Get your Zoho Analytics view name

Using the workspace name from the previous step, get a list of your Zoho Analytics views.

List Zoho Analytics views

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

viewId
viewName
viewDesc
viewType
parentViewId
folderId
createdTime
createdBy
createdByZuId
lastModifiedTime
lastModifiedBy
isFavourite
isViewAdmin
             
             
             

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards

Export your Zoho Analytics data

Using the view name from the previous step, you are now ready to export your data. Try it with the form below.
💡
You will likely need to use the + expand button to drill into your data.

Export Zoho Analytics Data

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

Column 1
Column 2
Column 3
Column 4
Column 5
     
     
     

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards