Smartsheet MCP Server
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Smartsheet MCP Server list all sheets I have access to"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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 |
| List all accessible sheets | ✅ |
| Read sheet data (columns + rows + cells) with filters & pagination | ✅ |
| Get column definitions and IDs for a sheet | ✅ |
| Add rows with cell values and hierarchy placement | ❌ |
| Update existing row cells, lock/unlock rows | ❌ |
| Permanently delete rows | ❌ |
| Add new columns with type/options | ❌ |
| Read paginated report data | ✅ |
| List all accessible reports | ✅ |
| List workspaces | ✅ |
| Browse all contents of a workspace | ✅ |
| Browse folder contents | ✅ |
| List all dashboards (Sights) | ✅ |
| Get all discussions on a sheet | ✅ |
| Get discussions on a specific row | ✅ |
| Start a new sheet-level discussion | ❌ |
| Start a new row-level discussion | ❌ |
| Reply to an existing discussion | ❌ |
| Delete a comment (own comments only) | ❌ |
| List all attachments on a sheet | ✅ |
| List attachments on a row | ✅ |
| Attach a URL link to a row | ❌ |
| Permanently delete an attachment | ❌ |
| Full-text search across all Smartsheet assets | ✅ |
| Full-text search within one sheet | ✅ |
| Audit trail — all historic values of a cell | ✅ |
| 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 startClaude 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/healthPer-request Token (multi-user / OAuth scenarios)
Each request can pass its own token via header, overriding the server default:
X-Smartsheet-Token: user_specific_tokenThis 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=httpYour MCP endpoint will be:
https://<app-name>.azurewebsites.net/mcpWiring into M365 Copilot (Declarative Agent)
Option A — Copilot Studio (Recommended for EPO/no-code)
Open Copilot Studio → Create or edit an agent
Go to Actions → Add an action → Model Context Protocol (MCP)
Enter your server URL:
https://<app-name>.azurewebsites.net/mcpSelect the tools you want the agent to use
Configure authentication (API key or OAuth)
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)
Install Microsoft 365 Agents Toolkit extension in VS Code
Create a new Declarative Agent from the toolkit
Choose Add Action → Start with an MCP server
Enter your MCP endpoint URL
The toolkit auto-generates the plugin manifest by reading your tool schemas
Pick which tools to expose
Configure OAuth (Smartsheet supports OAuth 2.0) or API key auth
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 ( | 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)
Create a new app → Set redirect URI to
https://teams.microsoft.com/api/platform/v1.0/oAuthRedirectCopy the Client ID and Client Secret
In Agents Toolkit: choose OAuth (static registration) and paste these values
Environment Variables
Variable | Required | Description |
| Yes (unless using per-request header) | Smartsheet API Bearer token |
| No (default: | Set to |
| No (default: | 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/defaulton nested properties can fail manifest validation in the Agents Toolkit — strip these if provisioning failsMax 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.mdAvailable Tools
27 toolssmartsheet_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 ContentsARead-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 ContentsARead-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 AttachmentADestructive
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 CommentADestructive
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 SheetADestructive
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 HistoryARead-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 ColumnsARead-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 DataARead-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 DataARead-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 VersionARead-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 AttachmentsARead-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 DashboardsARead-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 ReportsARead-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 AttachmentsARead-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 DiscussionsARead-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 DiscussionsARead-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 SheetsARead-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 WorkspacesARead-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_searchSearch SmartsheetARead-onlyIdempotent
Search across all accessible Smartsheet assets (sheets, reports, dashboards, rows, cells, discussions). Returns matching objects with their type, ID, and parent context. Use this to find sheets by name, locate rows containing specific text, or discover resources.
Args:
query (string): Search text (minimum 2 characters)
scope (string[], optional): Limit to specific object types: "cellData", "comments", "folderNames", "reportNames", "sheetNames", "sightNames", "summaryFields", "workspaceNames"
include_favorites (boolean, optional): Include favorite resources in results
page_size (number, optional): Max results (default 100)
Returns: Matching objects with IDs, types, and parent context.
Inputs: query (required), scope, page_size.
smartsheet_search_sheetSearch Within SheetARead-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
Scored across 27 tools
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.
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.
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.
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
Connect AI agents to Process Street workflows, tasks, runs, data sets, and operational records.
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Governed AI agents for the software your company already runs. 400+ connectors, one endpoint.
Give AI agents access to form submissions — read, search, update, and process file attachments.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceProvides 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.14MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to seamlessly interact with Google Sheets through secure OAuth 2.0 authentication. Supports reading, searching, updating spreadsheet data, and managing sheets with smart text replacement and batch operations.599 npmMIT
- AlicenseNot gradedqualityDmaintenanceIntegrates 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 npm22MIT
- AlicenseNot gradedqualityDmaintenanceEnables 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.17Apache 2.0