Manage workspaces, rows and data exports/imports in Zoho Analytics, across every Zoho data centre.
Zoho Analytics ships in the w6w first-party pack. It declares 10 actions, 2 health checks, and the host runs its code in a sandbox that never sees the credential.
io.w6w.zoho-analyticsZoho Analytics puts a BI workspace’s tables into a workflow — discover owned and shared workspaces, look up a workspace’s details, add, update and delete rows by criteria, export a table or view as CSV/JSON/XML/HTML, import a CSV or JSON file into a brand-new table, and list a workspace’s users or an organization’s admins.
Zoho hosts every account in one of eight regional data centres, each with its own dedicated Analytics API host and, almost always, its own connection endpoint, so this app routes each region through its own dedicated connection rather than one that could silently send an EU account’s requests through the US region instead. Canada is the one region where the connection endpoint AND the API host itself break the naming pattern the other seven follow, and this app points at the real endpoints rather than the ones the pattern would suggest.
The Asynchronous Import/Export APIs, importing into an existing table, workspace/view/column administration (create, rename, delete, copy), formulas, variables, email schedules, embedding and single sign-on are deliberately left out as not core to workflow automation of a workspace’s data — several of those are large enough to be their own app.
Three routes to the same 10 actions. The Workflow tab is generated from Zoho Analytics's own manifest and carries its real ids, so it is copy-pasteable; the Code and CLI examples are the same call for any action on any app, so every app-specific value in them is a blank you fill in.
data-export Export a table/view's data as CSV, JSON, XML or HTML. Not available for tables over 1M rows, live-connect workspaces, or Dashboard/QueryTable views — use Zoho's Asynchronous Export API for those (not implemented by this app).
data-import-new-table Upload a CSV or JSON file and create a new table from it.
org-admin-list List the admin email addresses for a Zoho Analytics organization.
row-add Add a single row to a table/view. `columns` is column name -> value, e.g. { "Region": "East", "Sales": 1000 }.
row-update Update rows in a table/view matching a criteria (or every row). `columns` is column name -> new value, e.g. { "Region": "East" }.
workspace-list-owned List every Zoho Analytics workspace this connection owns, across every organization it can access.
workspace-list-shared List every Zoho Analytics workspace that has been shared with this connection.
workspace-users-list List every user with access to a workspace, and their role.
A workflow step names the app and the action, and the editor fills in the
connection when you pick one. This is the Step shape from the
workflow spec, carrying Zoho Analytics's real ids.
{
"manifestVersion": "2",
"name": "zoho-analytics-example",
"steps": [
{
"id": "data-export",
"uses": {
"app": "io.w6w.zoho-analytics",
"action": "data-export",
"connection": "conn_YOUR_CONNECTION_ID"
},
"with": {
"workspaceId": "<workspaceId>",
"viewId": "<viewId>",
"responseFormat": "<responseFormat>"
}
}
]
}data-export data-import-new-table org-admin-list row-add row-update +5 more actions available
Every app-specific value here is a blank you have to fill in. An
app action is reached through the connection that authenticates it, so the
address is a connection id, not the app id — and connections belong to your account,
so a public page cannot know yours. Create one for Zoho Analytics, then fill in
the three blanks: conn_YOUR_CONNECTION_ID, the action key, and the
parameters that action declares. The call itself is real — the shape is transcribed
from the studio's own snippet builder, which prints the same kind of blanks — but
nothing in it is specific to Zoho Analytics. The Workflow tab is where this app's
real ids are.
npm install @w6w/sdkyarn add @w6w/sdkpnpm add @w6w/sdkdeno add npm:@w6w/sdkimport { W6wClient, isActionRun } from "@w6w/sdk";
// Reads W6W_BASE_URL and W6W_TOKEN from the environment when omitted.
const client = new W6wClient();
const envelope = await client.run({
urn: "conn_YOUR_CONNECTION_ID",
action: "data-export",
payload: {
workspaceId: "<value>",
viewId: "<value>",
responseFormat: "<value>",
// criteria: "<value>",
// selectedColumns: "<value>",
// includeHeader: "<value>",
// organizationId: "<value>",
},
});
if (isActionRun(envelope)) console.log(envelope.value); npm install -g @w6w/cli w6w run conn_YOUR_CONNECTION_ID --action data-export --payload '{"workspaceId":"<value>","viewId":"<value>","responseFormat":"<value>"}' Give an AI agent Zoho Analytics — without giving it Zoho Analytics's credentials. One MCP endpoint exposes every app, function and workflow the caller is entitled to, as tools it can discover and run. Access is granted per team while we onboard.
One tool call{
"name": "w6w_invoke",
"arguments": {
"ref": "app:io.w6w.zoho-analytics#data-export",
"input": {
"workspaceId": "<workspaceId>",
"viewId": "<viewId>",
"responseFormat": "<responseFormat>"
}
}
}
Every tool names its target with a single ref. The
app: form above doesn't name a connection at all — the
host resolves which of the caller's Zoho Analytics connections to sign
with, and refuses rather than guesses when the answer is ambiguous.
The token is attached host-side, at the moment of the call. It is never a tool argument, never in the model's context, and never in a transcript — so a prompt injection has nothing to exfiltrate.
Tools are derived per end user from what that person has actually connected and is entitled to — not one shared bot identity carrying the union of everyone's access.
Multi-step work runs on the workflow engine and returns a run handle the agent can poll — retries, branching and state survive the conversation that started them.
Zoho Analytics's declared health checks are on the surface too, so an agent can tell "the vendor is down" from "your credential expired" before it burns a retry on either.
The MCP surface is part of the hosted platform. Zoho Analytics itself is MIT, and the runtime that executes it is source-available (FSL).
Zoho Analytics declares its own checks, so its health is a property of the app rather than something the host guesses at.
Reads the exact "Zoho Analytics" component off Zoho's StatusIQ RSS feed (us.zohostatus.com/rss) — not the neighbouring Zoho Analytics-Download, Analytics Plus Cloud or Customer Analytics components. Unauthenticated and unsigned.