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