productivity
Zoho Sheet CLI for Shell Scripts
Use the Zoho Sheet CLI for shell scripts with headless JSON commands, schema discovery, credentials, and permission controls.
7 functions 6 read 1 write Manual OAuth token auth
Zoho Sheet CLI for Shell Scripts
Call integration functions from shell scripts with stable JSON input and output.
Use shell scripts for small local automations that need one or more integration calls. 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 Shell Scripts
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.