RELATED 01
MCP Server for Excel
Drives the real desktop Microsoft Excel on Windows through COM for workbooks, Power Query, DAX and VBA
856GitHub stars
4.3k/wknpm downloads
73popularity score
Smartsheet MCP Server
Smartsheet's own hosted server for working with sheets, rows, reports, dashboards and workflows
Official · smartsheet.com Remote (hosted) · Streamable HTTP ProductivityData and analytics
Connect your client
Remote (hosted)
Add in one click
Opens the app, which asks before it adds the server. Then replace each <NAME> in its settings with your value.
Or add it by command or config
Its sign-in lets no client register itself: a client signs in only with an app (a client ID) registered with its maker first, so these snippets work only after that step.
Claude Codeterminal
claude mcp add --transport http smartsheet-mcp \
https://mcp.smartsheet.com \
-H "Authorization:Bearer <SMARTSHEET_API_TOKEN>"Cursormcp.json (Settings > Tools & MCP > Add Custom MCP)
{
"mcpServers": {
"smartsheet": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.smartsheet.com",
"--header",
"Authorization:${AUTH_HEADER}"
],
"env": {
"AUTH_HEADER": "Bearer <SMARTSHEET_API_TOKEN>"
}
}
}
}CodexSettings > MCP servers > Add server (Streamable HTTP, bearer token variable)
[mcp_servers.smartsheet]
url = "https://mcp.smartsheet.com/"Gemini CLIsettings.json
{
"mcpServers": {
"smartsheet-mcp": {
"httpUrl": "https://mcp.smartsheet.com",
"headers": {
"Authorization": "Bearer <SMARTSHEET_API_TOKEN>"
}
}
}
}Claude (desktop and web)Smartsheet connector in Claude or Claude Desktop (OAuth)
https://mcp.smartsheet.com/ChatGPTSmartsheet connector in ChatGPT (OAuth)
https://mcp.smartsheet.com/Settings 1
SMARTSHEET_API_TOKEN |
Optional: Smartsheet API token sent as the Bearer header by clients without Smartsheet OAuth (Claude Code, Codex, Cursor, Gemini CLI); the docs say the variable name is your choice. |
|---|
What it does
The Smartsheet MCP Server is run by Smartsheet itself at https://mcp.smartsheet.com, with separate endpoints for the EU (https://mcp.smartsheet.eu) and Australia (https://mcp.smartsheet.au). There is nothing to install: a client connects over streamable HTTP and acts with the permissions of the Smartsheet user who signed in.
Its tools cover most of daily Smartsheet work. An assistant can search across your assets, browse workspaces and folders, read a sheet's structure and rows, add, change or delete rows and columns, look at a cell's history, handle attachments, discussions and comments, read reports, and build dashboards. Tools added during 2026 manage automated workflows, generate charts from a plain-language request, create portfolios and project templates, and run Scenario Planning for resource plans.
The tools reference page documents 77 tools, and the changelog shows the set still changing: in October 2026 add_chart_to_dashboard was replaced by add_charts_to_dashboard, and update_workflow and get_scenario_group were added. Tools are grouped into toolsets (such as automations, discussions, portfolio, sharing and scenario_planning) that a client can load on demand through search_tools and a read or write executor per toolset, so not every tool needs to sit in the client's context at once.
Each tool needs a named OAuth scope. The endpoint's sign-in metadata lists eleven, from READ_SHEETS through DELETE_SHEETS, ADMIN_WORKSPACES, ADMIN_USERS and SHARE_SHEETS, which shows how far a connection can reach.
What it needs
A Smartsheet account on a Business, Enterprise or Advanced Work Management plan; portfolio and Scenario Planning tools need Enterprise or Advanced Work Management. Clients with Smartsheet's OAuth (ChatGPT, Claude, Claude Desktop, Gemini Enterprise Plus, Microsoft 365 Copilot) sign in through the Smartsheet connector; Claude Code, Codex, Cursor and Gemini CLI need a Smartsheet API token sent as a Bearer header. Cursor's documented setup runs mcp-remote through npx, which needs Node.js.
Limits
Hosted only: there is no package or source to run yourself, and data passes through Smartsheet's service. Tools are subject to Smartsheet API rate limits; get_cell_history is limited to 30 requests per minute per API token. query_chart works only on charts already saved to a dashboard. Several tools are marked destructive and irreversible in the docs, including delete_portfolio, which removes a portfolio with all its templates, projects and workspace contents. Tool names change between releases (add_chart_to_dashboard was removed in October 2026), so saved prompts naming tools may break.
Who it suits
Suits teams already on a paid Smartsheet plan who want an assistant to find, read and update their sheets, reports and dashboards without running anything locally, and who prefer a server maintained by Smartsheet. Its write and delete tools reach whole workspaces and portfolios, so for cautious use connect as a user with limited sharing. It does not fit free or Pro accounts. We also list mcp-server-smartsheet-rm, a community Python package you run yourself; it works on Resource Management by Smartsheet (the 10,000ft API) rather than sheets, so pick it for timesheets and resource scheduling in that product.
Tools 60 of 77
search- Searches names, cell data, comments and attachments across the sheets, reports and workspaces you can see
browse_workspace- Lists what a workspace contains
browse_folder- Lists what a folder contains
list_workspaces- Lists the workspaces you can access
create_workspace- Creates a new workspace
create_folder- Creates a folder
create_workspace_assets- Builds a set of workspaces, sheets, dashboards, workflows and reports from a plain-language description
get_sheet_path- Returns where a sheet sits in the folder tree, with its permalink
get_sheet_summary- Returns a sheet's structure and contents
get_sheet_version- Returns a sheet's version number to detect changes cheaply
find_in_sheet- Finds text inside one sheet and returns the matching cells
get_columns- Lists a sheet's columns
add_columns- Adds columns to a sheet
update_column- Changes a column's settings
delete_column- Removes a column
add_rows- Adds rows to a sheet
update_rows- Changes cell values in existing rows
delete_rows- Removes rows from a sheet
get_cell_history- Shows past values of one cell and who changed them
list_attachments- Lists files attached to a sheet or row
get_attachment- Returns one attachment's details and download link
delete_attachment- Removes an attachment
list_discussions- Lists discussions on a sheet or row
get_discussion- Returns one discussion with its comments
create_discussion- Starts a discussion
delete_discussion- Removes a discussion
add_comment- Posts a comment in a discussion
update_comment- Edits a comment
delete_comment- Removes a comment
list_reports- Lists reports you can access
get_report- Returns a report's rows
get_workflows- Lists the automated workflows on a sheet
create_workflow- Creates an automated workflow on a sheet
update_workflow- Replaces a workflow's definition
enable_workflow- Turns a disabled workflow back on
disable_workflow- Turns a workflow off without deleting it
delete_workflow- Deletes a workflow
list_dashboards- Lists dashboards you can access
get_dashboard- Returns a dashboard and its widgets
create_dashboard- Creates a dashboard
get_chart_suggestions- Suggests charts to build from a sheet
create_chart_from_prompt- Generates charts and metrics from a sheet using a plain-language request
refine_chart- Suggests follow-up changes to a chart
explain_chart- Summarises what a chart shows
query_chart- Returns the data of a chart saved to a dashboard
get_chart_definition- Returns a chart's definition
add_charts_to_dashboard- Places generated charts on a dashboard
list_shares- Lists who an asset is shared with
list_favorites- Lists your favourite assets
add_favorites- Marks assets as favourites
list_portfolios- Lists portfolios you can access
create_portfolio- Creates a portfolio with its project list sheet and dashboards
delete_portfolio- Deletes a portfolio and everything in it
list_projects- Lists projects under a project template
get_scenario_groups- Lists Scenario Planning plans
create_scenario- Creates a scenario in a plan
get_scenario_diffs- Shows what applying a scenario would change and any conflicts
get_scenario_capacity_workload- Returns capacity and workload figures for a scenario
apply_scenario- Writes a scenario's changes back to its source sheets
update_shadow_sheet_rows- Edits rows in a scenario's copy of a sheet