Integration · Company data
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.
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.
23 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.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_workspaceChanges dataCreate a new, empty workspace with `config.workspaceName` and an optional `config.workspaceDesc`.delete_rowsMoves moneyDelete rows from a table that match `config.criteria` (or all rows with `deleteAllRows`). This cannot be undone.download_export_dataDownload the result of a finished export job by `workspace_id` and `job_id`.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_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_workspaceGet one workspace's details by `workspace_id`.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_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_organizationsList the Zoho Analytics organizations you belong to.list_recent_viewsList the views you opened recently.list_viewsList the views (tables, reports, dashboards, query tables) in a workspace by `workspace_id`, optionally filtered by name `keyword` in `config`.list_workspacesList all workspaces you own or that are shared with you. Use this to find a workspace ID.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.sync_data_sourceVisible to othersStart an immediate data sync for a data source by `workspace_id` and `datasource_id`.update_rowsVisible to othersUpdate rows in a table: set new values in `config.columns` and choose rows with a `criteria` expression, or set `updateAllRows`.
Set up in three steps
- 1
Pick the app
Create a free PipMCP account and choose Zoho Analytics from the app list.
- 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://pipmcp.com/oauth/callback. Then connect with your Zoho login.
- 3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
- Click your name, then Settings › Connectors › Add custom connector.
- Paste your link as the Remote MCP server URL.
- 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 PipMCP 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 PipMCP 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 PipMCP Pro plan or above. PipMCP 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 PipMCP 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://pipmcp.com/oauth/callback, paste the values into PipMCP 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 freePipMCP is not affiliated with Zoho Analytics. Product names are trademarks of their owners.