productivity
Zoho Sheet CLI for Headless Automation
Use the Zoho Sheet CLI for headless automation with headless JSON commands, schema discovery, credentials, and permission controls.
7 functions 6 read 1 write Manual OAuth token auth
Zoho Sheet CLI for Headless Automation
Use KosmoKrator as a non-interactive integration runtime for local automations and wrappers.
Use headless automation when another tool needs a stable local command surface. The Zoho Sheet CLI uses the same integration registry as the TUI, Lua runtime, and MCP gateway, but returns predictable command output for automation.
Command Shape
# Zoho Sheet CLI for Headless Automation
kosmokrator integrations:configure zoho_sheet --set access_token="$ZOHO_SHEET_ACCESS_TOKEN" --enable --read allow --write ask --json
kosmo integrations:call zoho_sheet.zoho_sheet_list_spreadsheets '{"page":1,"per_page":1}' --jsonDiscovery Before Execution
Agents and scripts can inspect Zoho Sheet docs and schemas before choosing a function.
kosmo integrations:docs zoho_sheet --json
kosmo integrations:docs zoho_sheet.zoho_sheet_list_spreadsheets --json
kosmo integrations:schema zoho_sheet.zoho_sheet_list_spreadsheets --json
kosmo integrations:search "Zoho Sheet" --json
kosmo integrations:list --jsonUseful Zoho Sheet CLI Functions
| Function | Type | Parameters | Description |
|---|---|---|---|
zoho_sheet.zoho_sheet_list_spreadsheets | Read | page, per_page | 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 | id | 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 | id | 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 | id, worksheet_id | 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 | id, worksheet_id, page, per_page | 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 | id, worksheet_id, data | 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 | none | Get the authenticated Zoho Sheet user's profile information. Returns display name, email, and account details. Useful for verifying which account is connected. |
Automation Notes
- Use
--jsonfor machine-readable output. - Keep credentials out of argv by using environment variables or stored KosmoKrator configuration.
- Configure read/write policy before unattended runs; use
--forceonly for trusted automation. - Use the MCP gateway instead when the agent needs dynamic tool discovery inside a conversation.