Zoho Analytics logo

Integrate Zoho Analytics with your AI CRM

Zoho Analytics provides APIs for data, workspaces, reports, dashboards, sharing, user management, automation, and analytics administration.

Explore Triggers and Actions

Activate Users

Activate Users.

ActionTry it

Add Aggregate Formula

Add Aggregate Formula.

ActionTry it

Add Column

Add Column.

ActionTry it

Add Custom Formula

Add Custom Formula.

ActionTry it

Add Default Workspace

Set a workspace as the connected user's default workspace.

ActionTry it

Add Favorite View

Mark a view as a favorite for the authenticated user.

ActionTry it

Add Favourite Workspace

Add a workspace to the connected user's favourites.

ActionTry it

Add Group Members

Add Group Members.

ActionTry it

Add Lookup

Add Lookup.

ActionTry it

Add Multiple Tags To View

Attach up to 1,000 existing workspace tags to one view.

ActionTry it

Add Row

Add one row to a Zoho Analytics view.

ActionTry it

Add Tag To Views

Attach one workspace tag to up to 1,000 views.

ActionTry it

Add Users

Invite users by email to the organization and assign their organization-level roles.

ActionTry it

Add Workspace Admins

Add Workspace Admins.

ActionTry it

Add Workspace Users

Add Workspace Users.

ActionTry it

Auto Analyse Column

Generate automatic analysis views for one table column.

ActionTry it

Auto Analyse View

Generate automatic analysis views for a table, optionally replacing a previous run.

ActionTry it

AutoML What If Analysis

Generate a prediction from hypothetical feature values using an AutoML model.

ActionTry it

Backup Workspace Now

Queue an immediate workspace backup. Requires a paid Zoho Analytics plan.

ActionTry it

Batch Import into a New Table

Upload one batch in a multi-part import that creates a new table.

ActionTry it

Batch Import into an Existing Table

Upload one batch in a multi-part import that appends, updates, or replaces all rows in an existing table; TRUNCATEADD permanently deletes the current rows first.

ActionTry it

Change Alert Status

Activate or pause a set of data alerts in one workspace.

ActionTry it

Change Email Schedule Status

Activate or deactivate an email schedule.

ActionTry it

Change Folder Hierarchy

Promote a subfolder to the root or nest a root folder under another folder.

ActionTry it

Change Folder Position

Reorder a folder relative to another folder at the same hierarchy level.

ActionTry it

Change User Role

Change User Role.

ActionTry it

Change Workspace Users Role

Change Workspace Users Role.

ActionTry it

Change Workspace Users Status

Change Workspace Users Status.

ActionTry it

Copy Custom Formulas

Copy Custom Formulas.

ActionTry it

Copy Views

Copy selected views into another workspace, optionally with dependents.

ActionTry it

Copy Workspace

Copy a workspace within the connected organization or to an explicitly selected destination organization.

ActionTry it

Create Alert

Create a data alert for a view.

ActionTry it

Create AutoML Analysis

Create an AutoML regression, classification, or clustering analysis in a workspace.

ActionTry it

Create AutoML Analysis Deployment

Create a scheduled or on-demand deployment for an AutoML analysis model.

ActionTry it

Create Custom Role

Create Custom Role.

ActionTry it

Create Dashboard

Create a dashboard from a JSON-encoded card layout and optional theme and viewer settings.

ActionTry it

Create Email Schedule

Create a recurring email delivery schedule for workspace views.

ActionTry it

Create Export Job using SQL Query

Create an asynchronous data-export job from a SQL SELECT query.

ActionTry it

Create Export Job using View ID

Create an asynchronous data-export job for a view.

ActionTry it

Create Folder

Create a root folder or subfolder in a workspace.

ActionTry it

Create Group

Create Group.

ActionTry it

Create Import Job for a New Table

Upload CSV or JSON data and create an asynchronous import job for a new table.

ActionTry it

Create Import Job for an Existing Table

Queue an asynchronous CSV or JSON import that appends, updates, or replaces all rows in an existing table; TRUNCATEADD permanently deletes the current rows first.

ActionTry it

Create Private URL

Create or update a private view URL; regenerating its key permanently invalidates the previous URL, and access settings can remove its password or expiry.

ActionTry it

Create Query Table

Create Query Table.

ActionTry it

Create Report

Create a chart, pivot, or summary report from a base table and axis configuration.

ActionTry it

Create Similar Views

Replicate a reference table's analysis views for a compatible target table.

ActionTry it

Create Slideshow

Create Slideshow.

ActionTry it

Create Table

Create Table.

ActionTry it

Create Tag

Create a uniquely named, colored tag in a workspace.

ActionTry it

Create Variable

Create Variable.

ActionTry it

Create Workspace

Create a workspace in the connected organization.

ActionTry it

Deactivate Users

Deactivate Users.

ActionTry it

Delete Aggregate Formula

Permanently delete an aggregate formula, optionally deleting every dependent view, dashboard, and aggregate formula.

ActionTry it

Delete Alerts

Permanently delete up to 1000 data alerts from a workspace.

ActionTry it

Delete AutoML Analysis

Permanently delete an AutoML analysis from a workspace.

ActionTry it

Delete AutoML Analysis Model

Permanently delete a model generated by an AutoML analysis.

ActionTry it

Delete AutoML Analysis Model Deployment

Permanently delete a deployment of an AutoML analysis model.

ActionTry it

Delete Column

Permanently delete a column, optionally deleting every dependent view, report, chart, pivot table, and formula.

ActionTry it

Delete Custom Formula

Permanently delete a custom formula column, optionally deleting every dependent report, chart, pivot table, and formula column.

ActionTry it

Delete Custom Role

Permanently delete a custom organization role.

ActionTry it

Delete Email Schedule

Permanently delete an email schedule.

ActionTry it

Delete Folder

Permanently delete a workspace folder, optionally also permanently deleting its dependent views and objects.

ActionTry it

Delete Group

Permanently delete a workspace group without deleting its users.

ActionTry it

Delete Row

Delete rows selected by criteria, or explicitly delete all rows in a view.

ActionTry it

Delete Slideshow

Permanently delete a slideshow and invalidate its access URL.

ActionTry it

Delete Tag

Permanently delete a workspace tag and remove it from tagged views.

ActionTry it

Delete Trash View

Permanently delete a view from trash, optionally with trashed dependents.

ActionTry it

Delete Variable

Permanently delete a workspace variable.

ActionTry it

Delete View

Move a view to trash, optionally including all dependent views.

ActionTry it

Delete Workspace

Permanently delete a workspace and its contents.

ActionTry it

Download Exported Data

Download the file produced by a completed asynchronous export job.

ActionTry it

Download Workspace Backup

Download a completed workspace backup as a file. Requires a paid Zoho Analytics plan.

ActionTry it

Edit Aggregate Formula

Edit Aggregate Formula.

ActionTry it

Edit Custom Formula

Edit Custom Formula.

ActionTry it

Edit Query Table

Edit Query Table.

ActionTry it

Edit Variable

Edit Variable.

ActionTry it

Export as Template

Export selected workspace views as a downloadable template file.

ActionTry it

Export Data from a View

Synchronously export view data and return the downloaded content as a file.

ActionTry it

Get Aggregate Formula

Return Aggregate Formula.

ActionTry it

Get Aggregate Formula Dependents

Return Aggregate Formula Dependents.

ActionTry it

Get Aggregate Formula Value

Return Aggregate Formula Value.

ActionTry it

Get Alert Configuration

Return the complete configuration of one data alert.

ActionTry it

Get Alert Events

Return one filtered page of evaluation events for a data alert.

ActionTry it

Get Alerts In View

Return the data alerts configured for a view.

ActionTry it

Get Alerts In Workspace

Return the data alerts configured in a workspace.

ActionTry it

Get AutoML Analysis Details

Get the configuration, models, and current state of an AutoML analysis.

ActionTry it

Get AutoML Analysis In Organization

List the AutoML analyses available in the connected organization.

ActionTry it

Get AutoML Analysis In Workspace

List the AutoML analyses configured in a workspace.

ActionTry it

Get Column Dependents

Return Column Dependents.

ActionTry it

Get Custom Formulas

Return Custom Formulas.

ActionTry it

Get Custom Roles

Return Custom Roles.

ActionTry it

Get Datasources

Return the datasources and sync intervals configured in a workspace.

ActionTry it

Get Deployments For A Model

Get the deployment configured for an AutoML analysis model.

ActionTry it

Get Email Schedules

Return all email schedules configured in a workspace.

ActionTry it

Get Embed URL

Return Embed URL.

ActionTry it

Get Export Job Details

Return the current status and details of an asynchronous export job.

ActionTry it

Get Folder List

Return the folders in a workspace.

ActionTry it

Get Group Details

Return Group Details.

ActionTry it

Get Group List

Return Group List.

ActionTry it

Get Import Job Details

Return the current status and details of an asynchronous import job.

ActionTry it

Get Last Import Details

Return details and row counts for the most recent import into a view.

ActionTry it

Get Linkable Workspaces

Return workspaces that can be linked to the specified master workspace.

ActionTry it

Get Linked Workspace Sync Details

Return synchronization details for all or selected linked workspaces.

ActionTry it

Get Linked Workspaces for Master Workspace

Return workspaces linked to a master workspace.

ActionTry it

Get Linked Workspaces for Organization

Return all linked workspace relationships in the organization.

ActionTry it

Get Meta Details From Name

Resolve workspace and optional view metadata from their exact display names.

ActionTry it

Get Org Access Restrictions

Return the organization-wide sharing, link, public-view, export, and email restrictions.

ActionTry it

Get Org Admins

Return Org Admins.

ActionTry it

Get Org Dashboards

Return one page of visible organization dashboards plus a continuation cursor.

ActionTry it

Get Org Recent Items

Return up to 20 views most recently opened by the connected user in the organization.

ActionTry it

Get Org Workspaces

Return organization workspaces visible to the connected user.

ActionTry it

Get Private URL

Return Private URL.

ActionTry it

Get Publish Configurations

Return Publish Configurations.

ActionTry it

Get Query Table Details

Return Query Table Details.

ActionTry it

Get Query Tables

Return Query Tables. Returns one page and a continuation cursor.

ActionTry it

Get Resource Details

Return the organization's plan allocations and current usage by resource type.

ActionTry it

Get Shared Details For Views

Return Shared Details For Views.

ActionTry it

Get Slideshow Details

Return Slideshow Details.

ActionTry it

Get Slideshow URL

Return Slideshow URL.

ActionTry it

Get Slideshows

Return Slideshows.

ActionTry it

Get Subscription Details

Return the organization's active plan, add-ons, billing date, and trial status.

ActionTry it

Get Table Metadata

Return Table Metadata.

ActionTry it

Get Tagged Views

Return one page of views carrying a tag, with a continuation cursor when limited.

ActionTry it

Get Tags

Return the tags defined in a workspace.

ActionTry it

Get Trash Views

Return views currently in a workspace's trash.

ActionTry it

Get Unified Metrics in Workspace

Return Unified Metrics in Workspace.

ActionTry it

Get User Permissions

Return User Permissions.

ActionTry it

Get Users

Return Users.

ActionTry it

Get Variable Details

Return Variable Details.

ActionTry it

Get Variables

Return Variables.

ActionTry it

Get View Dependents

Return active views that depend directly or transitively on a view.

ActionTry it

Get View Details

Return a view's metadata, optionally including type-specific involved objects.

ActionTry it

Get View List

Return one filtered, sorted page of workspace views with a continuation cursor when limited.

ActionTry it

Get View Metadata For Alert

Return the view metadata needed to construct valid data-alert rules.

ActionTry it

Get View Tags

Return the tags attached to a view.

ActionTry it

Get View URL

Generate a shareable view URL with display, filtering, and custom-domain options.

ActionTry it

Get Workspace Access Restrictions

Return one workspace's effective access restrictions and their configuration source.

ActionTry it

Get Workspace Admins

Return Workspace Admins.

ActionTry it

Get Workspace Backup Status

Return the status of a workspace backup. Requires a paid Zoho Analytics plan.

ActionTry it

Get Workspace Backups

Return backups for a workspace. Requires a paid Zoho Analytics plan.

ActionTry it

Get Workspace Info

Return metadata for a workspace, optionally including the requesting user's role.

ActionTry it

Get Workspace Linking Compatibility

Check whether candidate client workspaces can be linked to a master workspace.

ActionTry it

Get Workspace Restore Status

Return the status of a workspace restore. Requires a paid Zoho Analytics plan.

ActionTry it

Get Workspace Shared Details

Return Workspace Shared Details.

ActionTry it

Get Workspace Users

Return Workspace Users.

ActionTry it

Hide Columns

Hide Columns.

ActionTry it

Import Data into a New Table

Synchronously import an uploaded file or inline data into a new table.

ActionTry it

Import Data into an Existing Table

Synchronously append, update, or replace all rows in an existing table from an uploaded file or inline data; TRUNCATEADD permanently deletes the current rows first.

ActionTry it

Link Workspaces

Link client workspaces to a master workspace.

ActionTry it

Make Default Folder

Set a workspace folder as the default folder.

ActionTry it

Make Views Public

Make Views Public.

ActionTry it

Move Views to Folder

Move up to 1000 workspace views into a folder.

ActionTry it

Read Dashboard Metadata

Return all or one section of a non-tabbed dashboard's stored configuration.

ActionTry it

Read Report Metadata

Return the stored definition summary of a chart, pivot, or summary report.

ActionTry it

Refetch Data

Refetch source data for a view, incrementally or as a full fetch.

ActionTry it

Remove Default Workspace

Remove a workspace from the connected user's default workspace setting.

ActionTry it

Remove Favorite View

Remove a view from the authenticated user's favorites.

ActionTry it

Remove Favourite Workspace

Remove a workspace from the connected user's favourites.

ActionTry it

Remove Group Members

Remove Group Members.

ActionTry it

Remove Lookup

Remove a column lookup relationship, optionally deleting every report, chart, pivot table, and query table that depends on it.

ActionTry it

Remove Private Access

Remove Private Access.

ActionTry it

Remove Public Permission

Remove Public Permission.

ActionTry it

Remove Share

Remove Share.

ActionTry it

Remove Tag From Views

Detach one tag from selected views or every view in a workspace.

ActionTry it

Remove Tags From View

Detach selected tags or every tag from one view.

ActionTry it

Remove Users

Remove Users.

ActionTry it

Remove Workspace Admins

Remove Workspace Admins.

ActionTry it

Remove Workspace Users

Remove Workspace Users.

ActionTry it

Rename Column

Rename Column.

ActionTry it

Rename Folder

Rename a workspace folder and update its description.

ActionTry it

Rename Group

Rename Group.

ActionTry it

Rename View

Replace a view's display name and description.

ActionTry it

Rename Workspace

Rename a workspace and update its description.

ActionTry it

Reorder Columns

Reorder Columns.

ActionTry it

Restore Trash View

Restore a trashed view, optionally restoring required parent objects.

ActionTry it

Restore Workspace from Backup

Queue a paid-plan restore that replaces the workspace structure and, when selected, its data from a backup.

ActionTry it

Run Alert

Evaluate a configured data alert immediately and send its configured notifications or run its configured actions when the alert condition matches.

ActionTry it

Run AutoML Analysis

Run an AutoML deployment and write predictions to its configured output table; the deployment may append, update, or replace all existing rows.

ActionTry it

Save As View

Create an independent copy of a table or analysis view in the same workspace.

ActionTry it

Share Views

Share Views.

ActionTry it

Show Columns

Show Columns.

ActionTry it

Sort Data by Columns

Sort Data by Columns.

ActionTry it

Sync Data

Start a sync for a datasource, optionally targeting one sync interval.

ActionTry it

Sync Linked Workspaces

Synchronize all or selected client workspaces with a master workspace.

ActionTry it

Unlink Workspaces

Unlink all or selected client workspaces from a master workspace.

ActionTry it

Update Alert

Replace the configuration of an existing data alert.

ActionTry it

Update Custom Role

Update Custom Role.

ActionTry it

Update Dashboard

Replace selected layout, theme, or viewer settings of a non-tabbed dashboard.

ActionTry it

Update Email Schedule

Update an existing email delivery schedule.

ActionTry it

Update Org Access Restrictions

Update organization-wide sharing, link, public-view, export, or email restrictions.

ActionTry it

Update Publish Configurations

Update Publish Configurations.

ActionTry it

Update Report

Replace the definition of an existing chart, pivot, or summary report.

ActionTry it

Update Rows

Update rows selected by criteria, or explicitly update all rows in a view.

ActionTry it

Update Shared Details For View

Update Shared Details For View.

ActionTry it

Update Slideshow

Update a slideshow; regenerating its access key permanently invalidates the previous slideshow URL.

ActionTry it

Update Tag

Change a workspace tag's name, color, or both.

ActionTry it

Update Workspace Access Restrictions

Switch a workspace's configuration source or update its sharing, link, export, and email restrictions.

ActionTry it

How the Zoho Analytics integration works

The Zoho Analytics integration connects your Dench AI CRM directly to Zoho Analytics, so agents can read and act on your Zoho Analytics data as part of everyday work — answering questions in chat, keeping your CRM in sync, and running automations without anyone copying data between tools.

198 actions are available for agents to invoke on your behalf. Every call runs through Zoho Analytics's own authorization, scoped to the account you connect.

Set up Zoho Analytics in Dench

  1. 1

    Sign in to your Dench workspace and open Integrations.

  2. 2

    Find Zoho Analytics and click Connect — you'll authorize access through Zoho Analytics's own sign-in flow. No API keys or code required.

  3. 3

    Ask an agent to use Zoho Analytics in chat, or call it from an automation.

  4. 4

    Manage or disconnect the connection any time from workspace settings.

Frequently asked questions

How does the Zoho Analytics integration work with Dench?

The Dench Zoho Analytics integration connects your AI CRM to Zoho Analytics, so AI agents can work with your Zoho Analytics data as part of chats, automations, and CRM workflows. You connect your account once, and every agent in your workspace can use it — governed by your workspace permissions.

What actions can AI agents perform with Zoho Analytics via Dench?

The Zoho Analytics integration currently exposes 198 actions, including Activate Users, Add Aggregate Formula, Add Column, Add Custom Formula, Add Default Workspace, and Add Favorite View. Agents invoke them on your behalf from chat or from automations.

Do I need to write code to connect Zoho Analytics to Dench?

No. You connect Zoho Analytics from your Dench workspace using Zoho Analytics's own sign-in and authorization flow — no API keys to copy, no glue code to maintain.

Is the Zoho Analytics integration secure?

Connections are authorized through Zoho Analytics's own authentication flow, and Dench stores only the authorization needed to act on your behalf. You can review and disconnect the Zoho Analytics connection from your workspace settings at any time.