productivity
Zoho Sheet MCP, CLI, and Lua Integration for AI Agents
Zoho Sheet integration docs for AI agents: MCP gateway setup, Zoho Sheet CLI commands, Lua API reference, credentials, and function schemas.
7 functions 6 read 1 write Manual OAuth token auth
Zoho Sheet for agents
Credentials can be configured manually in web or CLI hosts.
Use this integration from Lua code mode, the headless integrations CLI, or the KosmoKrator MCP gateway. The same package metadata powers all three surfaces.
Machine-Readable Metadata
- integration_slug
zoho_sheet- route_slug
zoho-sheet- package
zoho-sheet- auth_strategy
oauth2_manual_tokenManual OAuth token- cli_setup_supported
true- cli_runtime_supported
true- mcp_gateway_supported
true- lua_supported
true- supports_multi_account
true
Quick Links
Lua APIAgent-facing namespace and function reference. Zoho Sheet CLIHeadless setup and direct function calls. Zoho Sheet MCPMCP gateway setup for external clients. Submit feedbackReport missing tools, auth problems, wrong docs, or runtime issues. ContributeAdd tools or improve metadata in the integrations repo.
Zoho Sheet MCP Client Matrix
Use these pages when a specific agent client or framework needs copy-pasteable MCP setup for Zoho Sheet.
Claude Code Zoho Sheet MCP setup for Claude Code. Cursor Zoho Sheet MCP setup for Cursor. Codex Zoho Sheet MCP setup for Codex. OpenAI Agents Zoho Sheet MCP setup for OpenAI Agents SDK. Claude Agent SDK Zoho Sheet MCP setup for Claude Agent SDK. Vercel AI SDK Zoho Sheet MCP setup for Vercel AI SDK. LangChain Zoho Sheet MCP setup for LangChain. LangGraph Zoho Sheet MCP setup for LangGraph. CrewAI Zoho Sheet MCP setup for CrewAI. MCP clients Zoho Sheet MCP setup for Generic MCP Clients.
Zoho Sheet CLI Matrix
Use these pages for direct Zoho Sheet CLI workflows in scripts, CI, cron, and agent wrappers.
CI Zoho Sheet CLI for CI. Cron Jobs Zoho Sheet CLI for cron jobs. Shell Scripts Zoho Sheet CLI for shell scripts. Headless Automation Zoho Sheet CLI for headless automation. Coding Agents Zoho Sheet CLI for coding agents.
Function Catalog
| Function | Type | Parameters | Description |
|---|---|---|---|
zoho_sheet.zoho_sheet_list_spreadsheets | Read read | 2 | List all spreadsheets accessible to the authenticated Zoho Sheet user. Returns spreadsheet names, IDs, and metadata. Use this to discover available spreadsheets before querying worksheets or rows. |
zoho_sheet.zoho_sheet_get_spreadsheet | Read read | 1 | Get details of a specific Zoho Sheet spreadsheet by its ID. Returns spreadsheet metadata including name, description, and associated worksheets. |
zoho_sheet.zoho_sheet_list_worksheets | Read read | 1 | List all worksheets within a Zoho Sheet spreadsheet. Returns worksheet names, IDs, and metadata like row/column counts. Use this to discover worksheets before reading or writing row data. |
zoho_sheet.zoho_sheet_get_worksheet | Read read | 2 | Get details of a specific worksheet within a Zoho Sheet spreadsheet. Returns worksheet metadata including name, row/column counts, and header information. |
zoho_sheet.zoho_sheet_list_rows | Read read | 4 | List rows in a Zoho Sheet worksheet with pagination. Returns row data as key-value pairs using column headers as keys. Use this to read data from a specific worksheet. |
zoho_sheet.zoho_sheet_create_row | Write write | 3 | Create a new row in a Zoho Sheet worksheet. Provide column header names as keys and their values. The row will be appended to the end of the worksheet. |
zoho_sheet.zoho_sheet_get_current_user | Read read | 0 | Get the authenticated Zoho Sheet user's profile information. Returns display name, email, and account details. Useful for verifying which account is connected. |