Skip to main content

Set up the Smartsheet MCP server

Smartsheet's MCP server lets AI agents read, write, update, and delete data across sheets, rows, reports, dashboards, discussions, and workspaces. This guide covers connecting Smartsheet's generally available server from MintMCP's recommended servers, where each user authenticates with their own Smartsheet access token.

Prerequisites

  • A MintMCP admin account
  • A Smartsheet account on a Business, Enterprise, or Advanced Work Management plan (required for API access)
  • Each user needs their own access token before connecting — see Generate a Smartsheet access token

Add Smartsheet to MintMCP

  1. In MintMCP, go to MCP store and open the Recommended servers tab.

  2. Select Smartsheet (marked Official) to open the Configure Smartsheet panel.

  3. In Server URL, enter the endpoint for your account's data region:

    RegionServer URL
    UShttps://mcp.smartsheet.com
    EUhttps://mcp.smartsheet.eu
    AUhttps://mcp.smartsheet.au
  4. Set Authorization Method to Bearer Token.

  5. Set Connection Type to Per-user credentials.

  6. Click Install.

Each user then generates their own access token and supplies it when MintMCP prompts for a bearer token on first connect.

Generate a Smartsheet access token

Each user who wants to access Smartsheet through MintMCP must generate their own personal access token:

  1. In Smartsheet, click your profile icon in the bottom-left navigation bar and select Personal Settings.
Smartsheet profile menu with Personal Settings highlighted
  1. Click the API Access tab.
  2. Click Generate new access token.
Personal Settings dialog on the API Access tab with the Generate new access token button
  1. Enter a name for the token — something like "MintMCP" — and click OK.
  2. Copy the token value immediately. It's only shown once.

Enter this token when MintMCP prompts for a bearer token.

Authorize Smartsheet dialog with a field to enter your bearer token

Tool capabilities reference

The server exposes read, write, and delete tools across Smartsheet's main objects:

CapabilityWhat it coversAccess
SheetsRead and search sheet data, create sheetsRead, write
RowsAdd, update, and delete rows; view cell historyRead, write, delete
ColumnsRead, add, update, and delete columnsRead, write, delete
Discussions & commentsRead threads, start discussions, add/update/delete commentsRead, write, delete
AttachmentsList and retrieve attachments, attach URLs, delete attachmentsRead, write, delete
ReportsList, read, and create reportsRead, write
DashboardsList and read dashboardsRead
Workspaces & foldersBrowse and list, create workspaces and foldersRead, write
DiscoverySearch assets, manage favorites and sharesRead, write

A Smartsheet access token carries the generating user's full account permissions and has no per-tool scopes, so these capabilities are bounded by what that user can already do in Smartsheet.

Security considerations

  • Per-user identity comes from the Per-user credentials connection type, so every tool call runs under the individual user's Smartsheet identity and is bounded by their permissions and roles — not an organization-wide identity.
  • A personal access token inherits the user's full permissions and has no granular scopes, which means an agent can do anything the token's owner can, including destructive writes like delete_rows, delete_column, delete_attachment, delete_comment, and delete_discussion. Review what agents do with write access.
  • Smartsheet's MCP server processes untrusted cell data, which can carry prompt injection, so be deliberate about granting write access.
  • Tokens are shown only once. Store them securely and rotate from Personal Settings → API Access if one is exposed.

Troubleshooting

  • 401 or authentication errors — the access token is wrong, expired, or revoked. Generate a new one under Personal Settings → API Access and reconnect.
  • Connection fails or returns no data — the Server URL must match the account's data region (.com, .eu, or .au).
  • Tools missing or write tools fail — the connecting user lacks access to the target sheet or workspace. A token never grants more than the user already has in Smartsheet.

Next steps