Smartsheet

Smartsheet MCP Connector for Claude

A+

Empower your AI to read Smartsheet rows, list workspaces, and manage your spreadsheets effortlessly from your code editor.

6 tools Official Updated Jun 28, 2026 Official Vinkius Partner

Connect your Smartsheet account to any AI agent and empower your team to query project configurations, internal spreadsheets, and custom reports seamlessly. Interact with your organization's grids through natural language without ever switching tabs.

What you can do

  • Project Navigation — Easily map out your hierarchical structures calling list_workspaces and list_folders to find correct document locations
  • Sheet Deep-Dives — Browse all your active spreadsheets using list_sheets and extract raw rows/columns instantly via get_sheet_details
  • Reporting Overviews — Retrieve saved tabular aggregations automatically calling list_reports across all configured company sheets
  • Identity Profiling — Test the connectivity and query authorized scopes by requesting the internal get_current_user tool

How it works

  1. Subscribe to this server
  2. Enter your Personal Smartsheet Access Token
  3. Start using Claude, Cursor, or any MCP-compatible client to query the state of your tabular data

Stop manually hunting down the ID of a specific project table just to wire up your Python scripts. Let your AI agent read the workspace layout automatically.

Who is this for?

  • Project Managers — rapidly audit how many tasks are active across cross-functional sheets or pull report overviews without exporting CSVs
  • Data Engineers — query the actual sheet layout and row metadata directly from the code editor to build sturdy ETL scripts
  • Team Leaders — have the bot read specific spreadsheets to generate weekly summary drafts completely autonomously
spreadsheetworkflow-automationproject-trackingreportingdata-integration

6 tools expose this connector's capabilities to your AI agent.

list_sheets

Lists all sheets available in Smartsheet

get_sheet_details

Retrieves details for a specific sheet

list_workspaces

Lists all workspaces in Smartsheet

list_folders

Lists all folders

list_reports

Lists all reports

get_current_user

Retrieves information about the current Smartsheet user

See how to talk to your AI agent using Smartsheet.

List all sheets available in my Smartsheet account.

I've invoked the listing call. Your account currently has access to the following 3 sheets: - Q1 Marketing Budget (ID: `10023`) - Employee Resource Registry (ID: `82910`) - Bug Triage Queue (ID: `15523`) Which sheet would you like me to inspect in more detail?

Retrieve the details and rows for the 'Release Candidate Tracker' sheet.

I matched 'Release Candidate Tracker' to ID `85739`. **Columns Detected**: 1. Status (Dropdown) 2. Task Name (Text/Number) 3. Assigned To (Contact List) **Rows retrieved**: - Row 1: Status: In Progress | Task: Implement API Docs | Assigned To: J. Doe - Row 2: Status: Complete | Task: Docker Upgrade | Assigned To: S. Smith

Summarize all our workspaces in a markdown table.

Sure. Using `list_workspaces`, I've compiled this table: | Workspace Name | ID | Permission Level | | --- | --- | --- | | External Consultants | `W-2391` | Admin | | Core Engineering Team | `W-8472` | Owner | | Q3 Marketing Rollouts | `W-1102` | Viewer |

Yes. When you call the `get_sheet_details` tool, the server returns the spreadsheet's metadata, including all column names, types (e.g., date, dropdown), and rows. The AI maps the internal IDs together to form a highly accurate contextual grid of your project.

Related Connectors