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 Cron Jobs

Use the Smartsheet CLI for cron jobs 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 Cron Jobs

Schedule repeatable integration workflows from cron while keeping credentials in KosmoKrator config.

Use the headless CLI from cron when an operation should run without an interactive agent session. 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 Cron Jobs
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. Shell Scripts Smartsheet CLI for shell scripts. Headless Automation Smartsheet CLI for headless automation. Coding Agents Smartsheet CLI for coding agents.