Skip to main content
Glama
Smartsheet MCP Server

Smartsheet MCP Server

by prmbr42-bot

Smartsheet MCP Server

A production-ready Model Context Protocol (MCP) server that gives AI agents full read/write access to Smartsheet — equivalent to the native Claude MCP, but deployable as a remote HTTP endpoint for Microsoft 365 Copilot declarative agents and Copilot Studio.


Tools Exposed

Tool

Description

Read-only

smartsheet_list_sheets

List all accessible sheets

✅

smartsheet_get_sheet

Read sheet data (columns + rows + cells) with filters & pagination

✅

smartsheet_get_columns

Get column definitions and IDs for a sheet

✅

smartsheet_add_rows

Add rows with cell values and hierarchy placement

❌

smartsheet_update_rows

Update existing row cells, lock/unlock rows

❌

smartsheet_delete_rows

Permanently delete rows

❌

smartsheet_add_columns

Add new columns with type/options

❌

smartsheet_get_report

Read paginated report data

✅

smartsheet_list_reports

List all accessible reports

✅

smartsheet_list_workspaces

List workspaces

✅

smartsheet_browse_workspace

Browse all contents of a workspace

✅

smartsheet_browse_folder

Browse folder contents

✅

smartsheet_list_dashboards

List all dashboards (Sights)

✅

smartsheet_list_sheet_discussions

Get all discussions on a sheet

✅

smartsheet_list_row_discussions

Get discussions on a specific row

✅

smartsheet_create_sheet_discussion

Start a new sheet-level discussion

❌

smartsheet_create_row_discussion

Start a new row-level discussion

❌

smartsheet_add_comment

Reply to an existing discussion

❌

smartsheet_delete_comment

Delete a comment (own comments only)

❌

smartsheet_list_attachments

List all attachments on a sheet

✅

smartsheet_list_row_attachments

List attachments on a row

✅

smartsheet_attach_url_to_row

Attach a URL link to a row

❌

smartsheet_delete_attachment

Permanently delete an attachment

❌

smartsheet_search

Full-text search across all Smartsheet assets

✅

smartsheet_search_sheet

Full-text search within one sheet

✅

smartsheet_get_cell_history

Audit trail — all historic values of a cell

✅

smartsheet_get_sheet_version

Check if a sheet was modified (lightweight)

✅


Related MCP server: Google Sheets MCP Server

Prerequisites

  • Node.js 18+

  • A Smartsheet API token — generate one at: Account → Apps & Integrations → API Access

  • For M365 Copilot deployment: an Azure App Service or Azure Container Apps to host the HTTP server


Local Development (stdio — Claude Desktop or Copilot Studio local)

npm install
npm run build

# Set your token
export SMARTSHEET_API_TOKEN=your_token_here

# Run in stdio mode (default)
npm start

Claude Desktop config (claude_desktop_config.json)

{
  "mcpServers": {
    "smartsheet": {
      "command": "node",
      "args": ["/absolute/path/to/smartsheet-mcp-server/dist/index.js"],
      "env": {
        "SMARTSHEET_API_TOKEN": "your_token_here"
      }
    }
  }
}

Remote HTTP Deployment (for M365 Copilot)

# Run in HTTP mode
TRANSPORT=http SMARTSHEET_API_TOKEN=your_token_here npm start

# Server listens at http://localhost:3000/mcp
# Health check: GET http://localhost:3000/health

Per-request Token (multi-user / OAuth scenarios)

Each request can pass its own token via header, overriding the server default:

X-Smartsheet-Token: user_specific_token

This supports SSO scenarios where each M365 user authenticates to Smartsheet with their own credentials.


Deploying to Azure App Service

# Build the project
npm run build

# Create a zip of the deployable files
zip -r deploy.zip dist/ package.json package-lock.json

# Deploy via Azure CLI
az webapp deploy --resource-group <rg> --name <app-name> --src-path deploy.zip

# Set environment variables in Azure
az webapp config appsettings set \
  --resource-group <rg> \
  --name <app-name> \
  --settings SMARTSHEET_API_TOKEN=your_token TRANSPORT=http

Your MCP endpoint will be:

https://<app-name>.azurewebsites.net/mcp

Wiring into M365 Copilot (Declarative Agent)

  1. Open Copilot Studio → Create or edit an agent

  2. Go to Actions → Add an action → Model Context Protocol (MCP)

  3. Enter your server URL: https://<app-name>.azurewebsites.net/mcp

  4. Select the tools you want the agent to use

  5. Configure authentication (API key or OAuth)

  6. Publish the agent

ℹ️ MCP is now generally available in Copilot Studio as of mid-2025.

Option B — VS Code + Microsoft 365 Agents Toolkit (for IT/Dev)

  1. Install Microsoft 365 Agents Toolkit extension in VS Code

  2. Create a new Declarative Agent from the toolkit

  3. Choose Add Action → Start with an MCP server

  4. Enter your MCP endpoint URL

  5. The toolkit auto-generates the plugin manifest by reading your tool schemas

  6. Pick which tools to expose

  7. Configure OAuth (Smartsheet supports OAuth 2.0) or API key auth

  8. Deploy to your M365 tenant via Microsoft 365 Admin Center → Copilot → Agents

Option C — Direct Manifest (Advanced)

The Agents Toolkit auto-generates ai-plugin.json and openapi.json from your MCP server's tool list. These files go into the declarative agent's appPackage/ directory and are uploaded to the Teams App Catalog.


Authentication Options for M365

Method

When to use

API Key in header (X-Smartsheet-Token)

Single shared service account token; simplest setup

OAuth 2.0 (per user)

Each user authenticates with their own Smartsheet account; required for per-user audit trails

Managed Identity + Key Vault

Best practice for production Azure deployments; store token in Key Vault, bind to App Service MSI

Smartsheet OAuth App Setup (for per-user auth)

  1. Go to Smartsheet Developer Portal

  2. Create a new app → Set redirect URI to https://teams.microsoft.com/api/platform/v1.0/oAuthRedirect

  3. Copy the Client ID and Client Secret

  4. In Agents Toolkit: choose OAuth (static registration) and paste these values


Environment Variables

Variable

Required

Description

SMARTSHEET_API_TOKEN

Yes (unless using per-request header)

Smartsheet API Bearer token

TRANSPORT

No (default: stdio)

Set to http for remote/Copilot deployments

PORT

No (default: 3000)

HTTP listen port


Known M365 Copilot Limitations

  • Only tools are supported — MCP resources and prompts are ignored by Copilot

  • Nested object schemas with minimum/maximum/default on nested properties can fail manifest validation in the Agents Toolkit — strip these if provisioning fails

  • Max 5 tools injected inline when ≤5 plugins are defined in a declarative agent manifest; above 5, the orchestrator selects dynamically

  • Confirmation prompts: Read-only tools (annotated readOnlyHint: true) don't require user confirmation; write tools do on first call


Project Structure

smartsheet-mcp-server/
├── src/
│   ├── index.ts                     # Entry point, transport selection
│   ├── types.ts                     # Smartsheet entity types
│   ├── constants.ts                 # API base URL, limits
│   ├── services/
│   │   └── smartsheet.ts            # API client, auth, error handling
│   └── tools/
│       ├── sheets.ts                # Sheet CRUD, rows, columns
│       ├── reports-workspaces.ts    # Reports, workspaces, folders, dashboards
│       ├── discussions-attachments.ts  # Comments, attachments
│       └── search.ts               # Search, cell history, version check
├── dist/                            # Compiled JS (after npm run build)
├── package.json
├── tsconfig.json
└── README.md

Available Tools

27 tools
smartsheet_add_columnsAdd Columns to SheetA

Add one or more new columns to a Smartsheet sheet. Supported column types: TEXT_NUMBER, DATE, DATETIME, PICKLIST, CHECKBOX, CONTACT_LIST, DURATION, PREDECESSOR, AUTO_NUMBER, ABSTRACT_DATETIME. Picklist/dropdown columns require an 'options' array.

Args:

  • sheet_id (number): Target sheet ID

  • columns (array): Column definitions, each with:

    • title (string): Column header text

    • type (string): Column type (TEXT_NUMBER, DATE, PICKLIST, CHECKBOX, CONTACT_LIST, etc.)

    • index (number, optional): 0-based position; appends if omitted

    • options (string[], optional): Dropdown options for PICKLIST columns

    • width (number, optional): Column width in pixels

Returns: Created column definitions with assigned IDs.

Inputs: sheet_id (required), columns (required).

smartsheet_add_commentAdd Comment to DiscussionA

Add a reply comment to an existing discussion on a sheet.

Args:

  • sheet_id (number): Target sheet ID

  • discussion_id (number): Target discussion ID

  • comment_text (string): Text of the comment to add

Returns: New comment ID and creation timestamp.

Inputs: sheet_id (required), discussion_id (required), comment_text (required).

smartsheet_add_rowsAdd Rows to SheetA

Add one or more rows to a Smartsheet sheet. Each row specifies cells as columnId/value pairs. Rows can be positioned at top, bottom, or relative to a parent/sibling row for hierarchical (indent) structures.

Args:

  • sheet_id (number): Target sheet ID

  • rows (array): Array of row objects, each containing:

    • cells (array): Array of {columnId, value} objects

    • to_top (boolean, optional): Insert at top of sheet

    • to_bottom (boolean, optional): Insert at bottom (default)

    • parent_id (number, optional): Make this a child of this row ID

    • sibling_id (number, optional): Insert as sibling below this row ID

    • expanded (boolean, optional): Whether row is expanded (default true)

Returns: Newly created row IDs and updated sheet version.

Inputs: sheet_id (required), rows (required).

smartsheet_attach_url_to_rowAttach URL to RowA

Attach a URL link to a specific row in a Smartsheet sheet. Creates a hyperlink attachment that appears in the row's attachment panel.

Args:

  • sheet_id (number): Target sheet ID

  • row_id (number): Target row ID

  • url (string): URL to attach

  • name (string): Display name for the attachment

  • description (string, optional): Description text

Returns: New attachment ID and metadata.

Inputs: sheet_id (required), row_id (required), url (required), name (required), +1 more.

smartsheet_browse_folderBrowse Folder ContentsA
Read-onlyIdempotent

Get the contents of a Smartsheet folder: sheets, reports, sub-folders, and dashboards.

Args:

  • folder_id (number): Smartsheet folder ID

  • load_all (boolean, optional): Include nested sub-folder contents

Returns: Folder contents with IDs for all child resources.

Inputs: folder_id (required), load_all.

smartsheet_browse_workspaceBrowse Workspace ContentsA
Read-onlyIdempotent

Get the full contents of a workspace: all sheets, reports, folders, and dashboards. Use this to discover what resources exist in a workspace before accessing them.

Args:

  • workspace_id (number): Smartsheet workspace ID

  • load_all (boolean, optional): If true, include nested folder contents

Returns: Workspace contents tree with IDs for all sheets, reports, folders, dashboards.

Inputs: workspace_id (required), load_all.

smartsheet_create_row_discussionCreate Row DiscussionA

Create a new discussion (with initial comment) on a specific row in a sheet.

Args:

  • sheet_id (number): Target sheet ID

  • row_id (number): Target row ID

  • comment_text (string): Initial comment text

Returns: New discussion ID and comment ID.

Inputs: sheet_id (required), row_id (required), comment_text (required).

smartsheet_create_sheet_discussionCreate Sheet DiscussionA

Create a new discussion (with initial comment) at the sheet level in Smartsheet.

Args:

  • sheet_id (number): Target sheet ID

  • comment_text (string): Initial comment text for the discussion

Returns: New discussion ID and comment ID.

Inputs: sheet_id (required), comment_text (required).

smartsheet_delete_attachmentDelete AttachmentA
Destructive

Permanently delete an attachment from a Smartsheet sheet. This action is IRREVERSIBLE. Verify the attachment ID before proceeding.

Args:

  • sheet_id (number): Sheet ID containing the attachment

  • attachment_id (number): Attachment ID to delete

Returns: Deletion confirmation.

Inputs: sheet_id (required), attachment_id (required).

smartsheet_delete_commentDelete CommentA
Destructive

Permanently delete a comment from a discussion on a sheet. Only the comment author can delete their own comments. This action is IRREVERSIBLE.

Args:

  • sheet_id (number): Sheet ID containing the comment

  • comment_id (number): Comment ID to delete

Returns: Deletion confirmation.

Inputs: sheet_id (required), comment_id (required).

smartsheet_delete_rowsDelete Rows from SheetA
Destructive

Permanently delete one or more rows from a Smartsheet sheet. This operation is IRREVERSIBLE. Deleted rows and their cell data are permanently removed. Confirm row IDs before calling. Child rows are also deleted when parent rows are removed.

Args:

  • sheet_id (number): Target sheet ID

  • row_ids (number[]): Array of row IDs to delete (max 450 per request)

  • ignore_rows_not_found (boolean, optional): If true, silently skip non-existent row IDs

Returns: Confirmation message and updated sheet version.

Inputs: sheet_id (required), row_ids (required), ignore_rows_not_found.

smartsheet_get_cell_historyGet Cell HistoryA
Read-onlyIdempotent

Retrieve the full modification history for a specific cell in a Smartsheet sheet. Shows all previous values, who changed the value, and when each change occurred. Useful for audit trails and tracking project status changes over time.

Args:

  • sheet_id (number): Target sheet ID

  • row_id (number): Target row ID

  • column_id (number): Target column ID

  • page_size (number, optional): History entries per page (default 100)

  • page (number, optional): Page number (default 1)

Returns: Chronological list of cell value changes with timestamps and user info.

Inputs: sheet_id (required), row_id (required), column_id (required), page_size, +1 more.

smartsheet_get_columnsGet Sheet ColumnsA
Read-onlyIdempotent

Retrieve all column definitions for a Smartsheet sheet. Returns column IDs, titles, types (TEXT_NUMBER, DATE, PICKLIST, CHECKBOX, CONTACT_LIST, etc.), options for dropdown columns, and whether each column is primary. Use this to get column IDs needed before adding or updating rows.

Args:

  • sheet_id (number): Target sheet ID

Returns: Array of column definitions with IDs, types, and options.

Inputs: sheet_id (required).

smartsheet_get_reportGet Report DataA
Read-onlyIdempotent

Retrieve data from a Smartsheet report by ID. Reports aggregate rows from multiple sheets. Returns columns, rows, and cell values just like a sheet, but the rows may originate from different source sheets. Supports pagination since reports can have very large row counts.

Args:

  • report_id (number): The numeric Smartsheet report ID

  • page_size (number, optional): Rows per page (default 100, max 500)

  • page (number, optional): Page number (default 1)

  • level (number, optional): Hierarchy level (0 = all, 1 = summary only)

Returns: Report metadata, columns, and rows with source sheet context.

Inputs: report_id (required), page_size, page, level.

smartsheet_get_sheetGet Sheet DataA
Read-onlyIdempotent

Retrieve sheet data from Smartsheet including columns, rows, and cell values. Supports optional filtering by column IDs, row IDs, and pagination via rowsModifiedSince. Use this to read project data, task lists, resource grids, or any tabular data stored in a sheet.

Args:

  • sheet_id (number): The numeric Smartsheet sheet ID

  • column_ids (number[], optional): Limit response to specific column IDs

  • row_ids (number[], optional): Limit response to specific row IDs

  • rows_modified_since (string, optional): ISO 8601 date; return only rows modified after this date

  • page_size (number, optional): Rows per page (default 100, max 500)

  • page (number, optional): Page number (default 1)

  • include_filters (boolean, optional): Include filter definitions in response

Returns: Sheet metadata, columns array, and rows array with cell values.

Inputs: sheet_id (required), column_ids, row_ids, rows_modified_since, +2 more.

smartsheet_get_sheet_versionGet Sheet VersionA
Read-onlyIdempotent

Get the current version number of a sheet without loading all row data. Use this to efficiently detect whether a sheet has been modified since last read, without pulling the full sheet payload.

Args:

  • sheet_id (number): Target sheet ID

Returns: Current version number and last modification timestamp.

Inputs: sheet_id (required).

smartsheet_list_attachmentsList Sheet AttachmentsA
Read-onlyIdempotent

List all attachments on a Smartsheet sheet (both sheet-level and row-level). Returns attachment name, type, size, and temporary download URL.

Args:

  • sheet_id (number): Target sheet ID

  • page_size (number, optional): Results per page (default 100)

  • page (number, optional): Page number (default 1)

Returns: Array of attachment metadata with download URLs (URLs expire after a short period).

Inputs: sheet_id (required), page_size, page.

smartsheet_list_dashboardsList DashboardsA
Read-onlyIdempotent

List all Smartsheet dashboards (Sights) the authenticated user has access to.

Args:

  • page_size (number, optional): Results per page (default 100)

  • page (number, optional): Page number (default 1)

Returns: Array of dashboard summaries with IDs and metadata.

Inputs: page_size, page.

smartsheet_list_reportsList All ReportsA
Read-onlyIdempotent

List all reports the authenticated user has access to. Returns report name, ID, permalink, access level, and modification timestamps.

Args:

  • page_size (number, optional): Results per page (default 100, max 100)

  • page (number, optional): Page number (default 1)

  • modified_since (string, optional): ISO 8601 date — only reports modified after this date

Returns: Array of report summaries with IDs.

Inputs: page_size, page, modified_since.

smartsheet_list_row_attachmentsList Row AttachmentsA
Read-onlyIdempotent

List all attachments on a specific row in a Smartsheet sheet.

Args:

  • sheet_id (number): Target sheet ID

  • row_id (number): Target row ID

Returns: Array of attachment metadata for the row.

Inputs: sheet_id (required), row_id (required).

smartsheet_list_row_discussionsList Row DiscussionsA
Read-onlyIdempotent

Retrieve all discussions attached to a specific row in a sheet.

Args:

  • sheet_id (number): Target sheet ID

  • row_id (number): Target row ID

  • include_comments (boolean, optional): Include comment text (default true)

Returns: Discussions and comments on the specified row.

Inputs: sheet_id (required), row_id (required), include_comments.

smartsheet_list_sheet_discussionsList Sheet DiscussionsA
Read-onlyIdempotent

Retrieve all discussions on a sheet (both sheet-level and row-level discussions). Returns discussion titles, comment counts, last activity, and comment text.

Args:

  • sheet_id (number): Target sheet ID

  • include_comments (boolean, optional): Include comment text in response (default true)

  • page_size (number, optional): Results per page (default 100)

  • page (number, optional): Page number (default 1)

Returns: Array of discussions with comments.

Inputs: sheet_id (required), include_comments, page_size, page.

smartsheet_list_sheetsList All SheetsA
Read-onlyIdempotent

List all sheets the authenticated user has access to, with pagination support. Returns sheet name, ID, permalink, access level, and modification timestamps. Use this to discover available sheets before reading data from a specific one.

Args:

  • page_size (number, optional): Results per page (default 100, max 100)

  • page (number, optional): Page number (default 1)

  • modified_since (string, optional): ISO 8601 date filter

Returns: Array of sheet summaries with IDs and metadata.

Inputs: page_size, page, modified_since.

smartsheet_list_workspacesList WorkspacesA
Read-onlyIdempotent

List all Smartsheet workspaces the authenticated user has access to. Returns workspace name, ID, access level, and child resource counts.

Args:

  • page_size (number, optional): Results per page (default 100)

  • page (number, optional): Page number (default 1)

Returns: Array of workspace summaries with IDs.

Inputs: page_size, page.

smartsheet_search_sheetSearch Within SheetA
Read-onlyIdempotent

Search for text within a specific Smartsheet sheet. Searches cell values, formulas, comments, and summary fields within one sheet.

Args:

  • sheet_id (number): Sheet ID to search within

  • query (string): Text to search for

Returns: Matching rows and cells within the sheet.

Inputs: sheet_id (required), query (required).

smartsheet_update_rowsUpdate Rows in SheetA

Update one or more existing rows in a Smartsheet sheet. Each row update specifies the row ID and cells to change. Only provided cells are updated; unspecified cells are left unchanged. Can also lock/unlock rows or change hierarchy.

Args:

  • sheet_id (number): Target sheet ID

  • rows (array): Array of row update objects, each containing:

    • row_id (number): ID of the row to update

    • cells (array): Array of {column_id, value} cells to update

    • locked (boolean, optional): Lock or unlock the row

    • expanded (boolean, optional): Expand or collapse row

Returns: Updated row data and new sheet version.

Inputs: sheet_id (required), rows (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A4/5.0

    Scored across 27 tools

    Disambiguation5/5

    All tools have distinct, non-overlapping purposes. Even similar tools like global search vs sheet-specific search are clearly differentiated by scope. Discussions, comments, attachments, and rows each have separate create/read/delete tools with no ambiguity.

    Naming Consistency5/5

    Every tool follows the consistent pattern 'smartsheet_verb_noun' (e.g., 'smartsheet_add_columns', 'smartsheet_get_sheet'). Verbs are uniformly used (add, get, list, create, delete, update, browse, search). No mixing of styles.

    Tool Count4/5

    27 tools is on the higher end but appropriate for a comprehensive Smartsheet API wrapper covering sheets, rows, columns, attachments, discussions, reports, dashboards, workspaces, folders, and search. However, a few tools like browse_workspace and browse_folder could potentially be merged without loss of clarity.

    Completeness2/5

    Notable gaps exist: there is no tool to create a sheet, delete a sheet, or update sheet metadata. While row CRUD is complete (add, update, delete), sheet-level lifecycle is missing. Also missing: update column, delete column, update attachment. This limits the server's ability to fully manage Smartsheet resources.

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides seamless integration with Smartsheet, enabling automated operations on Smartsheet documents through a standardized interface that bridges AI-powered automation tools with Smartsheet's collaboration platform.
      14
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Integrates with Microsoft 365 Copilot APIs to enable retrieval of content from SharePoint and OneDrive, document search across M365, and conversational AI interactions with your Microsoft 365 data while respecting access permissions.
      41 npm
      22
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI agents to securely access and manage Commvault environments, including job control, backup schedules, client/storage management, SLA monitoring, and optional DocuSign envelope backup integration.
      17
      Apache 2.0