Can I use Smartsheet as a CLI?

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

Can I expose Smartsheet through MCP?

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

Where are Smartsheet credentials stored?

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

Can I deny write access for Smartsheet MCP tools?

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

productivity

Smartsheet CLI for Headless Automation

Use the Smartsheet CLI for headless automation with headless JSON commands, schema discovery, credentials, and permission controls.

12 functions 7 read 5 write Bearer token auth

Submit Smartsheet feedback View package source

Smartsheet 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 Smartsheet CLI uses the same integration registry as the TUI, Lua runtime, and MCP gateway, but returns predictable command output for automation.

Command Shape

# Smartsheet CLI for Headless Automation
kosmokrator integrations:configure smartsheet --set 0="$SMARTSHEET_0" --enable --read allow --write ask --json
kosmo integrations:call smartsheet.smartsheet_list_sheets '{"limit":1,"page":1}' --json

Discovery Before Execution

Agents and scripts can inspect Smartsheet docs and schemas before choosing a function.

kosmo integrations:docs smartsheet --json
kosmo integrations:docs smartsheet.smartsheet_list_sheets --json
kosmo integrations:schema smartsheet.smartsheet_list_sheets --json
kosmo integrations:search "Smartsheet" --json
kosmo integrations:list --json

Useful Smartsheet CLI Functions

Function	Type	Parameters	Description
`smartsheet.smartsheet_list_sheets`	Read	limit, page	List all sheets accessible to the authenticated Smartsheet user. Returns sheet names and IDs.
`smartsheet.smartsheet_get_sheet`	Read	sheet_id, level, page_size, page	Get a specific Smartsheet sheet by ID, including its rows and columns.
`smartsheet.smartsheet_create_sheet`	Write	name, columns	Create a new Smartsheet sheet with a specified name and column definitions.
`smartsheet.smartsheet_add_rows`	Write	sheet_id, rows	Add one or more rows to a Smartsheet sheet. Each row should have a "cells" array with objects containing "columnId" and "value".
`smartsheet.smartsheet_update_rows`	Write	sheet_id, rows	Update one or more existing rows in a Smartsheet sheet. Each row must include its "id" field along with updated cell values.
`smartsheet.smartsheet_delete_rows`	Write	sheet_id, row_ids	Delete one or more rows from a Smartsheet sheet by their row IDs.
`smartsheet.smartsheet_list_columns`	Read	sheet_id, limit, page	List all columns in a Smartsheet sheet, including their titles, types, and IDs.
`smartsheet.smartsheet_add_column`	Write	sheet_id, title, type, options	Add a new column to a Smartsheet sheet. Column types include TEXT_NUMBER, DATE, CHECKBOX, PICKLIST, CONTACT_LIST, DATETIME, DURATION, and AUTO_NUMBER.
`smartsheet.smartsheet_list_workspaces`	Read	limit, page	List all workspaces accessible to the authenticated Smartsheet user.
`smartsheet.smartsheet_get_workspace`	Read	workspace_id	Get a specific Smartsheet workspace by ID, including its sheets, reports, and other contents.
`smartsheet.smartsheet_search`	Read	query, location, limit	Search across Smartsheet sheets, reports, and templates for matching content.
`smartsheet.smartsheet_get_current_user`	Read	none	Get the currently authenticated Smartsheet user's profile, including name and email.

Automation Notes

Use --json for machine-readable output.
Keep credentials out of argv by using environment variables or stored KosmoKrator configuration.
Configure read/write policy before unattended runs; use --force only for trusted automation.
Use the MCP gateway instead when the agent needs dynamic tool discovery inside a conversation.

Related Smartsheet CLI Pages

CI Smartsheet CLI for CI. Cron Jobs Smartsheet CLI for cron jobs. Shell Scripts Smartsheet CLI for shell scripts. Coding Agents Smartsheet CLI for coding agents.