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.

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.

Agent Surfaces

Machine-Readable Metadata

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.