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.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.
Agent Surfaces
Machine-Readable Metadata
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. |