# Smartsheet MCP

> Smartsheet MCP gives your AI agent direct access to your organization’s grids, reports, and folder structures. Instead of manually clicking through tabs or hunting down IDs, you can query project data—from simple task lists to complex cross-functional reports—using natural language in any compatible client. It lets your agent map out entire workspaces, extract raw row metadata, and even list all available saved company reports without leaving your code editor.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Tags:** spreadsheet, workflow-automation, project-tracking, reporting, data-integration

## Description

You can connect this MCP to your AI agent and make it read your internal Smartsheet data structure instantly. Your agent treats your organization's spreadsheets like a database you can query by conversation. You don't have to switch tabs or remember where that crucial project configuration lives; the system maps out all available workspaces, folders, and individual sheets automatically. It reads everything—from basic sheet row content to complex report summaries—and pulls it into context for your agent. If you’re already using Vinkius as your central hub for AI tools, this MCP adds Smartsheet data management directly alongside your other services in one place. This means your team can audit tasks across multiple cross-functional sheets or pull a summary of active reports without ever having to download and sift through a messy CSV file.

## Tools

### list_sheets
Retrieves a complete list of all individual sheets available in your Smartsheet account.

### get_sheet_details
Pulls specific metadata and the raw contents for any identified sheet.

### list_workspaces
Lists all high-level workspaces within your Smartsheet environment to map out project areas.

### list_folders
Provides a directory listing of all folders, helping you navigate the structural hierarchy.

### list_reports
Generates an inventory of saved reports that aggregate data from multiple company sheets.

### get_current_user
Retrieves basic information about the Smartsheet user who is connected via your token.

## Prompt Examples

**Prompt:** 
```
List all sheets available in my Smartsheet account.
```

**Response:** 
```
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?
```

**Prompt:** 
```
Retrieve the details and rows for the 'Release Candidate Tracker' sheet.
```

**Response:** 
```
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
```

**Prompt:** 
```
Summarize all our workspaces in a markdown table.
```

**Response:** 
```
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 |
```

## Capabilities

### Map the entire workspace structure
Your agent lists all available workspaces and folders, helping you find the right document location quickly.

### Browse and extract sheet data
The AI can list every spreadsheet in your account and retrieve the raw rows and columns for any specific sheet.

### Access saved report aggregations
You get a list of all pre-configured company reports, allowing your agent to pull summarized data across multiple sources at once.

### Determine current user permissions
The MCP runs a tool that confirms and reports the identity and scope of the connected Smartsheet account.

## Use Cases

### Auditing cross-functional tasks
A Project Manager needs to know which team is behind on Q3 goals. They ask their agent, 'Show me all task statuses across the Engineering and Marketing sheets.' The agent uses `list_sheets` and then `get_sheet_details` to pull a single view of status updates from multiple sources.

### Building ETL scripts
A Data Engineer needs column definitions for a new data pipeline. They instruct their agent, 'What are the exact columns and types in the Employee Registry sheet?' The agent uses `get_sheet_details` to return the metadata needed for coding.

### Quickly understanding company scope
A Team Leader joins a new project. They ask, 'What are all the major projects we track in Smartsheet?' The agent uses `list_workspaces` to immediately provide an overview of every high-level area they have access to.

### Comparing quarterly results
A manager needs a quick comparison of last quarter's marketing spend vs. this quarter's budget. They ask the agent to summarize all reports, triggering `list_reports` and pulling comparative data without manual effort.

## Benefits

- Stop hunting for sheet IDs. By calling `list_workspaces`, your agent automatically maps out the entire project hierarchy so you never have to manually find a document's location again.
- Go past simple data reads. If you need raw metadata, use `get_sheet_details` to extract columns and rows directly into your workflow without exporting anything.
- Generate immediate summaries. Use `list_reports` to pull aggregated company data across multiple sources in one go; no more manually compiling reports from different tabs.
- Understand scope instantly. The `get_current_user` tool confirms exactly what the agent can see and do, giving you confidence before running complex queries.
- Map your entire structure easily. Combine `list_sheets` with `list_folders` to build a comprehensive map of all data sources available for analysis.

## How It Works

The bottom line is you get immediate, conversational access to all of your company's core spreadsheet data without writing any code.

1. Subscribe to this MCP and provide your personal Smartsheet Access Token.
2. Select any compatible client, like Cursor or Claude, and ask it a question about your sheets or folders.
3. The agent uses the available tools to pull structured data from Smartsheet directly into your conversation context.

## Frequently Asked Questions

**How do I list all sheets using the Smartsheet MCP?**
You ask your agent to 'list all my sheets.' The tool uses `list_sheets` to pull a complete inventory of every available spreadsheet in your account.

**Can I get reports from multiple sources with Smartsheet?**
Yes. To see what summaries are ready, ask the agent to list all reports. It uses `list_reports` and pulls data aggregated across different company sheets instantly.

**Is this MCP only for viewing data?**
No, it's also great for mapping your structure. You can use the agent to list all workspaces or folders using `list_workspaces` and `list_folders` before you even query a sheet.

**What is the difference between listing sheets and getting details with Smartsheet?**
Listing sheets (`list_sheets`) gives you names. Getting details (`get_sheet_details`) pulls the actual data, including columns and rows, for a specific sheet.

**Does the Smartsheet MCP know who I am?**
Yes. You can run `get_current_user` to confirm your identity and what permissions the agent has within your account before running large queries.