Smartsheet MCP. Query your entire company grid from chat.

Stop jumping between tabs. This server lets your AI client talk directly to all your company's Smartsheet grids—you can query, map, and pull raw data without ever leaving your code editor. It handles everything from finding a specific project sheet to checking who you are in the system.

Discovering Your Grid Structure

You need to know where the data lives before you touch it. You start by listing all top-level workspaces using list_workspaces. That shows you every major container of projects and sheets your team uses across the organization. From there, you can drill down into specific sections; list_folders pulls up an inventory of every single folder within a chosen workspace, giving you that full project hierarchy map.

To see what grids are actually available for work, run list_sheets. This tool gives you a clean list of every active spreadsheet grid attached to your account. You can combine these tools—you'll use them in sequence to trace the exact path from a top workspace down through folders and finally to the sheet itself.

Pulling Raw Data & Reports

Once you know which sheets exist, you pull the data. If you target a specific spreadsheet by its ID, get_sheet_details pulls everything: it grabs all columns and every single row of metadata for deep analysis. You don't just get a summary; you get the raw dump. For high-level summaries, you can use list_reports.

This tool retrieves a list of pre-built, saved reports—these are complex aggregations that summarize data across multiple company sheets, letting your agent know exactly what views already exist without needing to build them from scratch.

Checking System Context and Permissions

Before you write a single line of code, you check the context. You run get_current_user; this pulls all the details about the Smartsheet user account your agent is currently connected to. This lets it verify connectivity and understand its current access scope right out of the gate. By checking the user details first, you'll know exactly what kind of permissions you have when you try querying data or listing grids.

It’s a comprehensive system for understanding where all your structured project data is located—you map the top workspaces with list_workspaces, drill into the containers using list_folders, get the list of available sheets via list_sheets, and then finally use get_sheet_details to extract every single row and column you need. You'll also pull up all system reports with list_reports and keep a tight grip on what your agent can actually see using get_current_user.

This lets your AI client treat your entire grid setup like one giant, queryable database.