KosmoKrator

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_token Manual OAuth token
cli_setup_supported
true
cli_runtime_supported
true
mcp_gateway_supported
true
lua_supported
true
supports_multi_account
true

Quick Links

Zoho Sheet MCP Client Matrix

Use these pages when a specific agent client or framework needs copy-pasteable MCP setup for Zoho Sheet.

Zoho Sheet CLI Matrix

Use these pages for direct Zoho Sheet CLI workflows in scripts, CI, cron, and agent wrappers.

Function Catalog

FunctionTypeParametersDescription
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.