Skip to content

Integration · Company data

zoho.com

Connect Claude & ChatGPT to Zoho Analytics

Ask your AI which tables a workspace holds, to pull a report's data, or to run an SQL query across your tables in Zoho Analytics. It can list workspaces, views and dashboards, read column metadata, export data, import CSV or JSON, add and update rows, create tables, query tables and reports, and start a data source sync. Data questions get answered without building the report by hand first.

Connect Zoho Analytics free

Free plan, no credit card. Takes about a minute.

Try asking

  • “What tables and reports are in the Sales workspace?”

    The AI finds the workspace and lists its views: tables, reports, dashboards and query tables.

  • “Export the Orders table for September as CSV.”

    It exports the table's data in CSV with a criteria filter on the order date.

  • “Total revenue per region last quarter, using the Orders and Regions tables.”

    It starts an SQL export job that joins the two tables, checks the job and downloads the result.

What your AI can do

Workspaces and views

List workspaces, folders, views, dashboards and recent views, read view details and column metadata, and create workspaces.

Data in and out

Export table and report data, run SQL SELECT exports across tables, import CSV or JSON, and add, update or delete rows.

Modeling and reports

Create tables, query tables from SQL and chart, pivot or summary reports, and list and sync data sources.

  • “Add a row to the Leads table: Nordic Foods, Aarhus, source Website.”

    It reads the table's columns and adds one row with those values.

  • “Create a bar chart of revenue by month from the Orders table.”

    It creates a chart report in the workspace with the base table, title and axis columns.

  • “Sync the CRM data source in the Sales workspace now.”

    It starts an immediate sync for that data source.

112 tools for Zoho Analytics

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

  • add_rowChanges dataAdd one row to a table by `workspace_id` and `view_id`; put the values in `config.columns` as column name to value.
  • archive_wlaccessMoves moneyArchive a wlaccess (workspace id). Financial or irreversible action; may require approval. API summary: Disable Workspace for Domain Access.
  • create_column_autoanalyseChanges dataCreate a new autoanalyse for a column. Required: zanalytics orgid. API summary: Auto Analyse Column.
  • create_query_tableChanges dataCreate a query table from an SQL SELECT in `config`, to combine or transform data from other tables.
  • create_reportChanges dataCreate a chart, pivot or summary report in a workspace; set `config.baseTableName`, `config.reportType`, a `title` and the axis columns.
  • create_tableChanges dataCreate a new table in a workspace; define its name and columns in `config.tableDesign` (TABLENAME, COLUMNS).
  • create_tag_viewChanges dataCreate a new view for a tag. Required: zanalytics orgid or config. API summary: Add Tag To Multiple Views.
  • create_view_aggregateformulaChanges dataCreate a new aggregateformula for a view. Required: zanalytics orgid or config. API summary: Add Aggregate Formula.
  • create_view_autoanalyseChanges dataCreate a new autoanalyse for a view. Required: zanalytics orgid. API summary: Auto Analyse View.
  • create_view_columnChanges dataCreate a new column for a view. Required: zanalytics orgid or config. Search columns first to avoid duplicates. API summary: Add Column.
  • create_view_customformulaChanges dataCreate a new customformula for a view. Required: zanalytics orgid or config. API summary: Add Custom Formula.
  • create_view_favoriteChanges dataCreate a new favorite for a view. Required: zanalytics orgid. API summary: Add Favorite View.
  • create_view_saveaChanges dataCreate a new savea for a view. Required: zanalytics orgid or config. API summary: Save As View.
  • create_view_similarviewChanges dataCreate a new similarview for a view. Required: zanalytics orgid or config. API summary: Create Similar Views.
  • create_view_tagChanges dataCreate a new tag for a view. Required: zanalytics orgid or config. API summary: Add Multiple Tags To View.
  • create_workspaceChanges dataCreate a new, empty workspace with `config.workspaceName` and an optional `config.workspaceDesc`.
  • create_workspace_dashboardChanges dataCreate a new dashboard for a workspace. Required: zanalytics orgid or config. API summary: Create Dashboard.
  • create_workspace_defaultChanges dataCreate a new default for a workspace. Required: zanalytics orgid. API summary: Add Default Workspace.
  • create_workspace_favoriteChanges dataCreate a new favorite for a workspace. Required: zanalytics orgid. API summary: Add Favourite Workspace.
  • create_workspace_folderChanges dataCreate a new folder for a workspace. Required: zanalytics orgid or config. API summary: Create Folder.
  • create_workspace_tagChanges dataCreate a new tag for a workspace. Required: zanalytics orgid or config. API summary: Create Tag.
  • create_workspace_variableChanges dataCreate a new variable for a workspace. Required: zanalytics orgid or config. API summary: Create Variable.
  • delete_rowsMoves moneyDelete rows from a table that match `config.criteria` (or all rows with `deleteAllRows`). This cannot be undone.
  • delete_tag_viewsMoves moneyPermanently delete a view by tag id. Financial or irreversible action; may require approval. API summary: Remove Tag From Multiple Views.
  • delete_view_aggregateformulaDeletesPermanently delete a aggregateformula by formula id. Destructive action; may require approval. API summary: Delete Aggregate Formula.
  • delete_view_columnDeletesPermanently delete a column by column id. Destructive action; may require approval. API summary: Delete Column.
  • delete_view_customformulaDeletesPermanently delete a customformula by formula id. Destructive action; may require approval. API summary: Delete Custom Formula.
  • delete_view_favoritesMoves moneyPermanently delete a favorite by view id. Financial or irreversible action; may require approval. API summary: Remove Favorite View.
  • delete_view_tagsMoves moneyPermanently delete a tag by view id. Financial or irreversible action; may require approval. API summary: Remove Multiple Tags From View.
  • delete_workspaceDeletesPermanently delete a workspace by workspace id. Destructive action; may require approval. API summary: Delete Workspace.
  • delete_workspace_defaultsMoves moneyPermanently delete a default by workspace id. Financial or irreversible action; may require approval. API summary: Remove Default Workspace.
  • delete_workspace_favoritesMoves moneyPermanently delete a favorite by workspace id. Financial or irreversible action; may require approval. API summary: Remove Favourite Workspace.
  • delete_workspace_folderDeletesPermanently delete a folder by folder id. Destructive action; may require approval. API summary: Delete Folder.
  • delete_workspace_tagDeletesPermanently delete a tag by tag id. Destructive action; may require approval. API summary: Delete Tag.
  • delete_workspace_trashDeletesPermanently delete a trash by view id. Destructive action; may require approval. API summary: Delete Trash View.
  • delete_workspace_variableDeletesPermanently delete a variable by variable id. Destructive action; may require approval. API summary: Delete Variable.
  • delete_workspace_viewDeletesPermanently delete a view by view id. Destructive action; may require approval. API summary: Delete View.
  • download_export_dataDownload the result of a finished export job by `workspace_id` and `job_id`.
  • export_dataExport data. API summary: Export as Template.
  • export_view_dataExport the data of a table or report by `workspace_id` and `view_id`. In `config`, set `responseFormat` (csv, json...) and an optional `criteria` filter or `selectedColumns`.
  • get_export_jobCheck the status of a background export job by `workspace_id` and `job_id`.
  • get_owned_dashboardsList owneds. API summary: Get Owned Dashboards.
  • get_shared_dashboardsList shareds. API summary: Get Shared Dashboards.
  • get_viewGet one view's details by `view_id`.
  • get_view_columnsGet a view's metadata, including its columns and data types, by `workspace_id` and `view_id`. Use before adding or updating rows.
  • get_view_urlVisible to othersPublish a view (view id). Has effects visible outside this system. API summary: Get View URL.
  • get_workspaceGet one workspace's details by `workspace_id`.
  • get_workspace_importjobGet one importjob for a workspace by job id. API summary: Get Import Job Details.
  • get_workspace_querytableGet one querytable for a workspace by querytable id. API summary: Get Query Table Details.
  • get_workspace_variableGet one variable for a workspace by variable id. API summary: Get Variable Details.
  • import_data_into_tableChanges dataImport CSV or JSON text (`data`) into an existing table. `config.importType` is append, updateadd or truncateadd; truncateadd deletes all existing rows first.
  • list_aggregateformula_dependentsList dependents for a aggregateformula. API summary: Get Aggregate Formula Dependents.
  • list_aggregateformula_valuesList values for a aggregateformula. API summary: Get Aggregate Formula Value.
  • list_column_dependentsList dependents for a column. API summary: Get Column Dependents.
  • list_dashboard_metadataList metadata for a dashboard. Optional filters: config. API summary: Get Dashboard Metadata.
  • list_dashboardsList all dashboards you own or that are shared with you.
  • list_data_sourcesList the data sources (connected apps and files) feeding a workspace.
  • list_foldersList the folders in a workspace by `workspace_id`.
  • list_metadetailsList metadetails. Optional filters: config. API summary: Get Meta Details From Name.
  • list_organizationsList the Zoho Analytics organizations you belong to.
  • list_ownedsList owneds. API summary: Get Owned Workspace List.
  • list_recent_viewsList the views you opened recently.
  • list_report_metadataList metadata for a report. API summary: Get Report Metadata.
  • list_resourcesList resources. API summary: Get Resource Details.
  • list_sharedsList shareds. API summary: Get Shared Workspace List.
  • list_subscriptionsList subscriptions. API summary: Get Subscription Details.
  • list_tag_viewsList views for a tag. Optional filters: config. API summary: Get Tagged Views.
  • list_view_aggregateformulasList aggregateformulas for a view. API summary: Get Aggregate Formula.
  • list_view_customformulasList customformulas for a view. API summary: Get Custom Formulas.
  • list_view_dataList data for a view. Optional filters: config. API summary: Create Export Job using View ID.
  • list_view_dependentsList dependents for a view. API summary: Get View Dependents.
  • list_view_importdetailsList importdetails for a view. API summary: Get Last Import Details.
  • list_view_tagsList tags for a view. API summary: Get View Tags.
  • list_viewsList the views (tables, reports, dashboards, query tables) in a workspace by `workspace_id`, optionally filtered by name `keyword` in `config`.
  • list_workspace_aggregateformulasList aggregateformulas for a workspace. API summary: Get Unified Metrics in Workspace.
  • list_workspace_secretkeysList secretkeys for a workspace. Optional filters: config. API summary: Get Workspace Secret Key.
  • list_workspace_tagsList tags for a workspace. API summary: Get Tags List.
  • list_workspace_trashesList trashes for a workspace. API summary: Get Trash Views.
  • list_workspace_variablesList variables for a workspace. API summary: Get Variables.
  • list_workspacesList all workspaces you own or that are shared with you. Use this to find a workspace ID.
  • remove_lookupDeletesSearch columns for a view. Use this to find existing columns before creating a new column. Destructive action; may require approval. API summary: Remove Lookup.
  • restore_trashChanges dataRestore a trash (view id). API summary: Restore Trash View.
  • restore_wlaccessChanges dataRestore a wlaccess (workspace id). API summary: Enable Workspace for Domain Access.
  • search_view_columnsChanges dataSearch columns for a view. Use this to find existing columns before creating a new column. API summary: Add Lookup.
  • search_workspace_querytablesSearch querytables for a workspace by config. Use this to find existing querytables before creating a new querytable. API summary: Get Query Tables.
  • start_sql_exportStart a background export job that runs an SQL SELECT (`config.sqlQuery`) across a workspace's tables. Returns a job ID; check it with get_export_job.
  • submit_formulaVisible to othersCopy a formula (view id). Has effects visible outside this system. API summary: Copy Custom Formulas.
  • submit_viewVisible to othersCopy a view (workspace id). Has effects visible outside this system. API summary: Copy Views.
  • submit_view_syncVisible to othersSync a view (view id). Has effects visible outside this system. API summary: Refetch Data.
  • sync_data_sourceVisible to othersStart an immediate data sync for a data source by `workspace_id` and `datasource_id`.
  • update_folder_defaultsVisible to othersUpdate an existing default identified by folder id. Has effects visible outside this system. API summary: Make Default Folder.
  • update_folder_movesVisible to othersUpdate an existing move identified by folder id. Has effects visible outside this system. API summary: Change Folder Hierarchy.
  • update_folder_reordersVisible to othersUpdate an existing reorder identified by folder id. Has effects visible outside this system. API summary: Change Folder Position.
  • update_hidesVisible to othersUpdate an existing hide identified by view id. Has effects visible outside this system. API summary: Hide Columns.
  • update_movetofoldersVisible to othersUpdate an existing movetofolder identified by workspace id. Has effects visible outside this system. API summary: Move Views To Folder.
  • update_reordersVisible to othersUpdate an existing reorder identified by view id. Has effects visible outside this system. API summary: Reorder Columns.
  • update_rowsVisible to othersUpdate rows in a table: set new values in `config.columns` and choose rows with a `criteria` expression, or set `updateAllRows`.
  • update_showsVisible to othersUpdate an existing show identified by view id. Has effects visible outside this system. API summary: Show Columns.
  • update_sortsVisible to othersUpdate an existing sort identified by view id. Has effects visible outside this system. API summary: Sort Data by Columns.
  • update_view_aggregateformulaChanges dataUpdate an existing aggregateformula identified by formula id. API summary: Edit Aggregate Formula.
  • update_view_columnChanges dataUpdate an existing column identified by column id. API summary: Rename Column.
  • update_view_customformulaChanges dataUpdate an existing customformula identified by formula id. API summary: Edit Custom Formula.
  • update_workspaceChanges dataUpdate an existing workspace identified by workspace id. API summary: Rename Workspace.
  • update_workspace_dashboardChanges dataUpdate an existing dashboard identified by dashboard id. API summary: Update Dashboard.
  • update_workspace_datasourceChanges dataUpdate an existing datasource identified by datasource id. API summary: Update Datasource Connection.
  • update_workspace_folderChanges dataUpdate an existing folder identified by folder id. API summary: Rename Folder.
  • update_workspace_querytableChanges dataUpdate an existing querytable identified by querytable id. API summary: Edit Query Table.
  • update_workspace_reportChanges dataUpdate an existing report identified by view id. API summary: Update Analysis View.
  • update_workspace_tagChanges dataUpdate an existing tag identified by tag id. API summary: Update Tag.
  • update_workspace_variableChanges dataUpdate an existing variable identified by variable id. API summary: Edit Variable.
  • update_workspace_viewChanges dataUpdate an existing view identified by view id. API summary: Rename View.
  • upload_dataChanges dataUpload a data (workspace id). API summary: Import Data into a New Table.

Set up in three steps

  1. 1

    Pick the app

    Create a free HeyMyApps account and choose Zoho Analytics from the app list.

  2. 2

    Paste your key

    Paste four values: your Zoho domain ending (com, eu, in, com.au, jp, sa or com.cn), a Client ID, a Client Secret and your Zoho Analytics Organization ID. Go to api-console.zoho.com on your Zoho data center, click Add Client > Server-based Applications, enter any name and homepage, and set the Authorized Redirect URI to https://heymyapps.com/oauth/callback. Then connect with your Zoho login.

  3. 3

    Add the link to your AI

    You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:

    1. Click your name, then Settings › Connectors › Add custom connector.
    2. Paste your link as the Remote MCP server URL.
    3. Switch it on from the + menu in a chat.

Questions

What can the AI do in Zoho Analytics?

The AI can list organizations, workspaces, folders, views, dashboards, recent views and data sources, read view details and columns, export data and run SQL exports. It can create workspaces, tables, query tables and reports, import data, add, update and delete rows, and start a data source sync, if you switch those tools on.

Does the AI see my Zoho Analytics credentials?

No. Your Client ID, Client Secret and the access HeyMyApps gets through your Zoho login are encrypted at rest and never shown to the AI. After you save them, they are not shown again, not even to you. The AI only sees the results of the tools it calls.

Can I control what the AI is allowed to do?

Yes. You choose which tools are switched on, so you can start read-only. Deleting rows cannot be undone, an import with truncateadd removes all existing rows first, and updating rows changes your data. These actions can require your approval before they run. Every tool call is logged.

Does it work with ChatGPT?

Yes. In ChatGPT go to Settings › Apps & Connectors › Advanced and turn on Developer mode, then add your HeyMyApps link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.

What does it cost?

Zoho Analytics connects with OAuth, and OAuth connections need the HeyMyApps Pro plan or above. HeyMyApps also has a free plan with no credit card, but it does not include this connection. Paid plans bill per completed task. You also need your own Zoho Analytics account.

Why do I need to create a client in Zoho's API console?

Zoho Analytics uses OAuth, so HeyMyApps needs a Client ID and Client Secret from a server-based application that you create in your own Zoho account. You set its redirect URI to https://heymyapps.com/oauth/callback, paste the values into HeyMyApps and sign in with Zoho to approve access. Pick the domain ending that matches your Zoho data center, for example eu or com. If you do not know your Organization ID, the AI can find it with the list organizations tool.

Related integrations

Let your AI work in Zoho Analytics today.

Start free. Your key stays encrypted, and you decide what the AI may do.

Connect Zoho Analytics free

HeyMyApps is not affiliated with Zoho Analytics. Product names are trademarks of their owners.