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

| Tool | Description | |------|-------------| | smartsheet_list_workspaces | List all workspaces you have access to | | smartsheet_get_workspace | Get workspace details including sheets and folders | | smartsheet_list_sheets | List all sheets across all workspaces | | smartsheet_get_sheet | Get full sheet data with columns and rows | | smartsheet_get_sheet_structure | Get only column definitions (no row data) | | smartsheet_search_sheets | Search sheets by name or content | | smartsheet_get_user | Get current authenticated user info | | smartsheet_generate_sheet_documentation | Generate markdown documentation for a sheet | | smartsheet_generate_workspace_documentation | Generate documentation for entire workspace |

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.