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.