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 MCP, CLI, and Lua Integration for AI Agents

Smartsheet integration docs for AI agents: MCP gateway setup, Smartsheet CLI commands, Lua API reference, credentials, and function schemas.

12 functions 7 read 5 write Bearer token auth

Submit Smartsheet feedback View package source

Smartsheet for agents

Credentials can be configured manually in web or CLI hosts.

Use this integration from Lua code mode, the headless integrations CLI, or the KosmoKrator MCP gateway. The same package metadata powers all three surfaces.

Machine-Readable Metadata

integration_slug: smartsheet
route_slug: smartsheet
package: smartsheet
auth_strategy: bearer_token Bearer token
cli_setup_supported: true
cli_runtime_supported: true
mcp_gateway_supported: true
lua_supported: true
supports_multi_account: false

Quick Links

Lua APIAgent-facing namespace and function reference. Smartsheet CLIHeadless setup and direct function calls. Smartsheet MCPMCP gateway setup for external clients. Submit feedbackReport missing tools, auth problems, wrong docs, or runtime issues. ContributeAdd tools or improve metadata in the integrations repo.

Smartsheet MCP Client Matrix

Use these pages when a specific agent client or framework needs copy-pasteable MCP setup for Smartsheet.

Smartsheet CLI Matrix

Use these pages for direct Smartsheet CLI workflows in scripts, CI, cron, and agent wrappers.

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

Function Catalog

Function	Type	Parameters	Description
`smartsheet.smartsheet_list_sheets`	Read `read`	2	List all sheets accessible to the authenticated Smartsheet user. Returns sheet names and IDs.
`smartsheet.smartsheet_get_sheet`	Read `read`	4	Get a specific Smartsheet sheet by ID, including its rows and columns.
`smartsheet.smartsheet_create_sheet`	Write `write`	2	Create a new Smartsheet sheet with a specified name and column definitions.
`smartsheet.smartsheet_add_rows`	Write `write`	2	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 `write`	2	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 `write`	2	Delete one or more rows from a Smartsheet sheet by their row IDs.
`smartsheet.smartsheet_list_columns`	Read `read`	3	List all columns in a Smartsheet sheet, including their titles, types, and IDs.
`smartsheet.smartsheet_add_column`	Write `write`	4	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 `read`	2	List all workspaces accessible to the authenticated Smartsheet user.
`smartsheet.smartsheet_get_workspace`	Read `read`	1	Get a specific Smartsheet workspace by ID, including its sheets, reports, and other contents.
`smartsheet.smartsheet_search`	Read `read`	3	Search across Smartsheet sheets, reports, and templates for matching content.
`smartsheet.smartsheet_get_current_user`	Read `read`	0	Get the currently authenticated Smartsheet user's profile, including name and email.