Smartsheet MCP Server

An MCP (Model Context Protocol) server that connects to your Smartsheet account, allowing Claude Code to browse workspaces, read sheets, and assist with documentation.

Available Tools

Related MCP server: SyncPen MCP Server

Setup

1. Get Your Smartsheet API Key

1. Log in to Smartsheet

2. Click your profile icon (top right) → Apps & Integrations

3. Click API Access

4. Click Generate new access token

5. Copy the token (you won't see it again!)

2. Install Dependencies

cd smartsheet-mcp-server
npm install

3. Build the Server

npm run build

4. Configure Claude Code

Add this server to your Claude Code MCP configuration. Edit ~/.claude/settings.json:

{
  "mcpServers": {
    "smartsheet": {
      "command": "node",
      "args": ["/PROJECT_PATH_HERE/dist/index.js"],
      "env": {
        "SMARTSHEET_API_KEY": "YOUR_API_KEY_HERE"
      }
    }
  }
}

Or add to project-specific .claude/settings.json for project-scoped access.

5. Restart Claude Code

After adding the configuration, restart Claude Code to load the new MCP server.

Usage Examples

Once configured, you can ask Claude Code:

• "List all my Smartsheet workspaces"

• "Show me the structure of sheet ID 12345"

• "Generate documentation for my Project Tracker workspace"

• "Search for sheets related to 'budget'"

Development

Run in development mode (no build required):

SMARTSHEET_API_KEY=your_key npm run dev

Troubleshooting

"SMARTSHEET_API_KEY environment variable is required"

• Ensure the API key is set in your Claude Code MCP configuration

"Smartsheet API error (401)"

• Your API key is invalid or expired. Generate a new one in Smartsheet.

"Smartsheet API error (403)"

• You don't have permission to access the requested resource.