Can I use Zoho Sheet as a CLI?

Yes. KosmoKrator exposes a Zoho Sheet CLI through kosmo integrations:call and the provider shortcut command. Commands can return JSON for scripts, CI, and coding agents.

Can I expose Zoho Sheet through MCP?

Yes. The KosmoKrator MCP gateway can expose selected Zoho Sheet tools to clients such as Claude Code, Cursor, Codex, and other MCP-compatible tools.

Where are Zoho Sheet credentials stored?

Zoho Sheet credentials are configured in KosmoKrator's local integration settings and reused by CLI, Lua, and MCP gateway surfaces.

Can I deny write access for Zoho Sheet MCP tools?

Yes. Start the gateway with --write=deny for read-only clients, or use ask/allow only for trusted workspaces.

productivity

Zoho Sheet CLI for AI Agents

Use the Zoho Sheet CLI from KosmoKrator to call Zoho Sheet tools headlessly, return JSON, inspect schemas, and automate workflows from coding agents, scripts, and CI.

Zoho Sheet CLI Setup

Zoho Sheet can be configured headlessly with `kosmokrator integrations:configure zoho-sheet`.

Install, configure, and verify

# Install KosmoKrator first if it is not available on PATH.
curl -fsSL https://raw.githubusercontent.com/OpenCompanyApp/kosmokrator/main/install.sh | bash

# Configure and verify this integration.
kosmokrator integrations:configure zoho-sheet --set access_token="$ZOHO_SHEET_ACCESS_TOKEN" --enable --read allow --write ask --json
kosmokrator integrations:doctor zoho-sheet --json
kosmokrator integrations:status --json

Credentials

Authentication type: Manual OAuth token oauth2_manual_token. Configure credentials once, then reuse the same stored profile from scripts, coding CLIs, Lua, and MCP.

Key	Env var	Type	Required	Label
`access_token`	`ZOHO_SHEET_ACCESS_TOKEN`	Secret `secret`	yes	Access Token
`url`	`ZOHO_SHEET_URL`	URL `url`	no	API Base URL

Command Patterns

The generic command is stable across every integration. The provider shortcut is shorter for humans.

Generic CLI call

kosmo integrations:call zoho-sheet.zoho_sheet_list_spreadsheets '{"page":1,"per_page":1}' --json

Provider shortcut

kosmo integrations:zoho-sheet zoho_sheet_list_spreadsheets '{"page":1,"per_page":1}' --json

Discovery

These commands return structured output for coding agents that need to inspect capabilities before choosing a function.

Discovery commands

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

Automation Contexts

The same configured command surface works in these environments. The command does not change unless the host wrapper, credentials, or permissions change.

CI Run integration calls from CI jobs with JSON output, explicit credentials, and predictable exit status. Cron Jobs Schedule repeatable integration workflows from cron while keeping credentials in KosmoKrator config. Shell Scripts Call integration functions from shell scripts with stable JSON input and output. Headless Automation Use KosmoKrator as a non-interactive integration runtime for local automations and wrappers. Coding Agents Let coding agents discover schemas and execute integration functions through CLI commands or MCP.

CLI Functions

Every function below can be called headlessly. Commands are highlighted, copyable, and scroll horizontally when payloads are long.

`zoho-sheet.zoho_sheet_list_spreadsheets`

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.

Read read

Parameters: page, per_page

Generic call

kosmo integrations:call zoho-sheet.zoho_sheet_list_spreadsheets '{"page":1,"per_page":1}' --json

Shortcut

kosmo integrations:zoho-sheet zoho_sheet_list_spreadsheets '{"page":1,"per_page":1}' --json

`zoho-sheet.zoho_sheet_get_spreadsheet`

Get details of a specific Zoho Sheet spreadsheet by its ID. Returns spreadsheet metadata including name, description, and associated worksheets.

Read read

Parameters: id

Generic call

kosmo integrations:call zoho-sheet.zoho_sheet_get_spreadsheet '{"id":"example_id"}' --json

Shortcut

kosmo integrations:zoho-sheet zoho_sheet_get_spreadsheet '{"id":"example_id"}' --json

`zoho-sheet.zoho_sheet_list_worksheets`

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.

Read read

Parameters: id

Generic call

kosmo integrations:call zoho-sheet.zoho_sheet_list_worksheets '{"id":"example_id"}' --json

Shortcut

kosmo integrations:zoho-sheet zoho_sheet_list_worksheets '{"id":"example_id"}' --json

`zoho-sheet.zoho_sheet_get_worksheet`

Get details of a specific worksheet within a Zoho Sheet spreadsheet. Returns worksheet metadata including name, row/column counts, and header information.

Read read

Parameters: id, worksheet_id

Generic call

kosmo integrations:call zoho-sheet.zoho_sheet_get_worksheet '{"id":"example_id","worksheet_id":"example_worksheet_id"}' --json

Shortcut

kosmo integrations:zoho-sheet zoho_sheet_get_worksheet '{"id":"example_id","worksheet_id":"example_worksheet_id"}' --json

`zoho-sheet.zoho_sheet_list_rows`

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.

Read read

Parameters: id, worksheet_id, page, per_page

Generic call

kosmo integrations:call zoho-sheet.zoho_sheet_list_rows '{"id":"example_id","worksheet_id":"example_worksheet_id","page":1,"per_page":1}' --json

Shortcut

kosmo integrations:zoho-sheet zoho_sheet_list_rows '{"id":"example_id","worksheet_id":"example_worksheet_id","page":1,"per_page":1}' --json

`zoho-sheet.zoho_sheet_create_row`

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.

Write write

Parameters: id, worksheet_id, data

Generic call

kosmo integrations:call zoho-sheet.zoho_sheet_create_row '{"id":"example_id","worksheet_id":"example_worksheet_id","data":"example_data"}' --json

Shortcut

kosmo integrations:zoho-sheet zoho_sheet_create_row '{"id":"example_id","worksheet_id":"example_worksheet_id","data":"example_data"}' --json

`zoho-sheet.zoho_sheet_get_current_user`

Get the authenticated Zoho Sheet user's profile information. Returns display name, email, and account details. Useful for verifying which account is connected.

Read read

Parameters: none

Generic call

kosmo integrations:call zoho-sheet.zoho_sheet_get_current_user '{}' --json

Shortcut

kosmo integrations:zoho-sheet zoho_sheet_get_current_user '{}' --json

Function Schemas

Use these parameter tables when building CLI payloads without calling integrations:schema first.

zoho-sheet.zoho_sheet_list_spreadsheets 2 parameters

Schema command

kosmo integrations:schema zoho-sheet.zoho_sheet_list_spreadsheets --json

Parameter	Type	Required	Description
`page`	integer	no	Page number for pagination (default: 1).
`per_page`	integer	no	Number of spreadsheets per page (default: 25, max: 100).

zoho-sheet.zoho_sheet_get_spreadsheet 1 parameters

Schema command

kosmo integrations:schema zoho-sheet.zoho_sheet_get_spreadsheet --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.

zoho-sheet.zoho_sheet_list_worksheets 1 parameters

Schema command

kosmo integrations:schema zoho-sheet.zoho_sheet_list_worksheets --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.

zoho-sheet.zoho_sheet_get_worksheet 2 parameters

Schema command

kosmo integrations:schema zoho-sheet.zoho_sheet_get_worksheet --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.
`worksheet_id`	string	yes	The worksheet resource ID.

zoho-sheet.zoho_sheet_list_rows 4 parameters

Schema command

kosmo integrations:schema zoho-sheet.zoho_sheet_list_rows --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.
`worksheet_id`	string	yes	The worksheet resource ID.
`page`	integer	no	Page number for pagination (default: 1).
`per_page`	integer	no	Number of rows per page (default: 25, max: 100).

zoho-sheet.zoho_sheet_create_row 3 parameters

Schema command

kosmo integrations:schema zoho-sheet.zoho_sheet_create_row --json

Parameter	Type	Required	Description
`id`	string	yes	The spreadsheet resource ID.
`worksheet_id`	string	yes	The worksheet resource ID.
`data`	object	yes	Row data as key-value pairs. Keys must match column headers in the worksheet (e.g., {"Name": "John", "Email": "john@example.com", "Age": 30}).

zoho-sheet.zoho_sheet_get_current_user 0 parameters

Schema command

kosmo integrations:schema zoho-sheet.zoho_sheet_get_current_user --json

Parameter	Type	Required	Description
No parameters.

Permissions

Headless calls still follow the integration read/write permission policy. Configure read/write defaults with integrations:configure. Add --force only for trusted automation that should bypass that policy.