KosmoKrator

productivity

Smartsheet MCP Integration for OpenAI Agents SDK

Connect Smartsheet to OpenAI Agents SDK through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.

12 functions 7 read 5 write Bearer token auth
Submit Smartsheet feedback View package source

Connect Smartsheet to OpenAI Agents SDK

Attach KosmoKrator integration tools to OpenAI Agents SDK workflows through a local MCP gateway.

Start the KosmoKrator MCP gateway locally and point the OpenAI Agents SDK MCP tool at that process or wrapper. The gateway is local, scoped to this integration, and starts with --write=deny so OpenAI Agents can inspect read-capable tools without receiving write access by default.

Smartsheet MCP Config for OpenAI Agents SDK

Use headless JSON commands for CI-style execution and MCP for agent tool discovery.

{
  "mcpServers": {
    "kosmokrator-smartsheet": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=smartsheet",
        "--write=deny"
      ]
    }
  }
}

Run the Gateway Manually

kosmokrator mcp:serve --integration=smartsheet --write=deny

Why Use KosmoKrator Here

Scoped tools

Expose only Smartsheet instead of a broad multi-service tool list.

Local credentials

Reuse credentials already configured for the KosmoKrator CLI and Lua runtime.

Write policy

Start read-only, then opt into ask or allow for trusted workspaces.

Smartsheet Tools Visible to OpenAI Agents

OpenAI Agents sees stable MCP tool names generated from the Smartsheet integration catalog.

MCP toolSource functionTypeDescription
integration__smartsheet__smartsheet_list_sheets smartsheet.smartsheet_list_sheets Read List all sheets accessible to the authenticated Smartsheet user. Returns sheet names and IDs.
integration__smartsheet__smartsheet_get_sheet smartsheet.smartsheet_get_sheet Read Get a specific Smartsheet sheet by ID, including its rows and columns.
integration__smartsheet__smartsheet_create_sheet smartsheet.smartsheet_create_sheet Write Create a new Smartsheet sheet with a specified name and column definitions.
integration__smartsheet__smartsheet_add_rows smartsheet.smartsheet_add_rows Write Add one or more rows to a Smartsheet sheet. Each row should have a "cells" array with objects containing "columnId" and "value".
integration__smartsheet__smartsheet_update_rows smartsheet.smartsheet_update_rows Write Update one or more existing rows in a Smartsheet sheet. Each row must include its "id" field along with updated cell values.
integration__smartsheet__smartsheet_delete_rows smartsheet.smartsheet_delete_rows Write Delete one or more rows from a Smartsheet sheet by their row IDs.
integration__smartsheet__smartsheet_list_columns smartsheet.smartsheet_list_columns Read List all columns in a Smartsheet sheet, including their titles, types, and IDs.
integration__smartsheet__smartsheet_add_column smartsheet.smartsheet_add_column Write Add a new column to a Smartsheet sheet. Column types include TEXT_NUMBER, DATE, CHECKBOX, PICKLIST, CONTACT_LIST, DATETIME, DURATION, and AUTO_NUMBER.
integration__smartsheet__smartsheet_list_workspaces smartsheet.smartsheet_list_workspaces Read List all workspaces accessible to the authenticated Smartsheet user.
integration__smartsheet__smartsheet_get_workspace smartsheet.smartsheet_get_workspace Read Get a specific Smartsheet workspace by ID, including its sheets, reports, and other contents.
integration__smartsheet__smartsheet_search smartsheet.smartsheet_search Read Search across Smartsheet sheets, reports, and templates for matching content.
integration__smartsheet__smartsheet_get_current_user smartsheet.smartsheet_get_current_user Read Get the currently authenticated Smartsheet user's profile, including name and email.

Related Smartsheet Pages

Smartsheet CLIUse direct JSON commands instead of MCP discovery. Smartsheet MCPFull gateway reference and MCP tool names. KosmoKrator for OpenAI AgentsClient-level gateway setup.