Smartsheet MCP for AI. Manage projects and report metrics directly from chat.
Gemini Works with every AI agent you already use
…and any MCP-compatible client
How this MCP server connects to your AI agent
Smartsheet MCP Server gives your AI agent full control over enterprise data sheets. It lets you list entire project workspaces, retrieve sheet metadata, add or update specific rows, delete old records, and search for filtered data—all via natural language conversation.
What AI agents can do with Smartsheet Automation
Add sheet rows
Appends a new set of data rows to an existing sheet when provided with the required JSON array format.
Remove sheet row
Deletes an entire row of data from a sheet, requiring the specific row ID for execution.
Get my profile
Retrieves basic profile information for the currently logged-in user or specified agent.
Retrieves structured lists of your existing Smartsheet files and parent project containers.
Reads the metadata for a specific sheet, detailing every column name and its data type.
Performs full CRUD operations on cell data within sheets using tools like add_sheet_rows, update_sheet_rows, and remove_sheet_row.
Runs filtered searches inside a sheet to locate exact pieces of information, preventing manual data dives.
Accesses user directories (list_platform_users) and lists all available project reports in your account.
Ask an AI about this
Waiting for input…
What AI agents can do with Smartsheet MCP Server: 12 Tools for Sheet Operations
Use these tools to manage sheet metadata, add/modify records, list workspaces, and search deeply across all your Smartsheet projects.
Make your AI actually useful.
Add this MCP to Claude, Cursor, or Windsurf and your AI stops guessing. It gets real tools to look things up, take action, and handle the stuff you keep doing by hand.
Start using Smartsheet on VinkiusAdd Sheet Rows
Appends a new set of data rows to an existing sheet when provided with the required JSON array format.
Remove Sheet Row
Deletes an entire row of data from a sheet, requiring the specific row ID for...
Get My Profile
Retrieves basic profile information for the currently logged-in user or specified...
Get Sheet Details
Fetches detailed metadata about a specific sheet, including its owner and creation...
Get Workspace Details
Retrieves high-level information about an entire project workspace or container.
List Sheet Columns
Lists the column headers (fields) available on a sheet so you know exactly what data can be read or written.
List Available Reports
Lists and filters all the report templates currently available within your Smartsheet account.
List Sheets
Returns an immediate list of all sheets contained within your connected Smartsheet...
List Platform Users
Generates a directory list of all company users accessible in the platform...
List Workspaces
Provides a directory listing of all major project workspaces or folders you manage.
Search Within Sheet
Runs a targeted search inside a single sheet to find rows that match certain...
Update Sheet Rows
Modifies existing data within specific rows, requiring the row IDs and the new cell values in a JSON array.
Security and governance baked right in.
Pick your AI client below to get set up. Just create a Vinkius account, subscribe, and you're instantly up and running. We handle the entire backend infrastructure, delivering out-of-the-box support for HTTPS Streamable, SSE, and OAuth2—zero messy routing required.
Claude AI
Open Claude Settings
Go to claude.ai, click your profile icon, then navigate to Customize → Connectors.
Add Custom Connector
Click the "+" button and select Add custom connector. Paste your Vinkius endpoint URL:
https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp
Replace [YOUR_TOKEN_HERE] with your token
from cloud.vinkius.com. For OAuth-protected servers, expand
Advanced settings to add credentials.
Start a conversation
Open a new chat. The Smartsheet integration is available immediately — no restart needed.
Choose How to Get Started
Build a custom MCP for your own tools, or connect a ready-made integration from our catalog.
Build Your Own
Turn any API into an MCP. Import a spec, define Agent Skills, or deploy with MCPFusion.
- Import from OpenAPI, Swagger, or YAML specs
- Create Agent Skills with progressive disclosure
- Deploy to edge with MCPFusion framework
- Built in DLP, auth, and compliance on every call
- Real time usage dashboard and cost metering
- Publish to catalog or keep private
Make Your AI Do More
Start with Smartsheet, then connect any of our 5,100+ other servers whenever your AI needs more. One click, no limits.
- Use this MCP plus 5,100+ others, all in one place
- Add new capabilities to your AI anytime you want
- Every connection is secured and compliant automatically
- Track usage and costs across all your servers
- Works with Claude, ChatGPT, Cursor, and more
- New servers added to the catalog every week
Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Smartsheet. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.
VINKIUS INFRASTRUCTURE
Cloud Hosted
Managed infra
V8 Isolated
Sandboxed per request
Zero-Trust Proxy
No stored credentials
DLP Enforced
Policy on every call
GDPR Compliant
EU data residency
Token Compression
~60% cost reduction
Built on the Model Context Protocol (MCP) for Claude, ChatGPT, Cursor, and more
The Model Context Protocol standardizes how applications expose capabilities to LLMs. Instead of operating in isolation, your AI gains direct access to external platforms, live data, and real-world actions through secure, standardized connections.
This connection provides 12 powerful capabilities that interface natively with Claude, ChatGPT, Cursor, and other compatible AI platforms. No middleware. No custom integration required.
Finding the right sheet or column shouldn't feel like detective work., Solved with Vinkius AI Gateway
Right now, if you need a status update from 'Q3 Marketing,' you open the main folder in Smartsheet. You then click through several sub-tabs until you find the correct sheet. Once there, you might have to scroll down 50 rows or run multiple filters just to confirm one number—and you risk misinterpreting which version of the data you're looking at.
With this MCP server, you simply ask your agent: 'What was the Q3 Marketing status?' The agent first uses `list_sheets` to narrow down the correct file, then calls `search_within_sheet` directly. It pulls the exact number and hands it back to you instantly. No clicking, no guessing.
The Smartsheet MCP Server: full control over data rows.
Manually updating project records is painful. You have multiple teams with different statuses—Marketing needs to change the 'Status' column, while Finance only has permission to update the 'Budget Approved' cell. If you use a simple interface, you might accidentally overwrite a critical field or forget which row ID corresponds to whom.
The server gives your agent granular control: it knows the difference between adding an entire new record (`add_sheet_rows`) and just changing one status flag using `update_sheet_rows`. You tell it *what* needs fixing, and it handles the precise data placement.
What your AI can actually do with this
When your AI agent connects to this Smartsheet server, it gets full control over your company's structured data sheets. You can manage and read enterprise project information right from your chat client; you never gotta leave the conversation window.
This isn't just a reader; it’s a write-through system for complex workflows. Your agent handles all the heavy lifting, whether you need to track resource allocations or pull up details on an old campaign report. You tell your AI what you want, and it runs the necessary commands using this server.
Navigating Your Data Landscape
You can start by getting a lay of the land. The agent can run list_workspaces to give you a directory list of every major project container you manage—it shows all your top-level folders. From there, it uses list_sheets to pull up an immediate roster of every sheet inside those workspaces.
If you need to dig deeper into what's available, the agent can use get_workspace_details to retrieve high-level info about a whole project container, or run get_sheet_details for specific metadata on any individual sheet, including who owns it and when it was created.
To make sure your AI client knows exactly what data structure you’re dealing with, it uses list_sheet_columns. This tool tells the agent every single column header—the actual field names—available on a given sheet. It's how the system knows what data types it can read or write.
Working with Records and Data Integrity
The server handles full CRUD (Create, Read, Update, Delete) operations directly on cell data. If you need to add new entries, the agent uses add_sheet_rows, which takes a required JSON array format to append an entirely new set of data rows to any existing sheet.
If records change and you gotta fix 'em up, it runs update_sheet_rows. You give it the specific row IDs along with the new cell values in another JSON array, and those old cells get modified. Conversely, if a record is junk or outdated, the agent executes remove_sheet_row, which requires the exact row ID to delete that entire line of data.
Finding Specific Answers & Monitoring People
Don't wanna manually scroll through thousands of rows? The agent runs search_within_sheet. You give it keywords or criteria, and it finds matching rows inside a single sheet. This lets you pinpoint exact pieces of information instantly, so you don't waste time diving into data yourself.
For people management, the server provides tools to monitor your organization. It uses list_platform_users to generate a comprehensive directory list of every company user accessible in Smartsheet, giving you their names and roles. You can also check basic profile info for any account using get_my_profile or specifying an agent’s details.
When it comes to project reporting, the server tracks what's available. The agent runs list_available_reports to list and filter every single report template that lives in your Smartsheet account.
019dd162-253c-7352-8b66-8f5c2f1734c6 
Here's how it actually works
The bottom line is that you get an AI agent with direct write access to your core business data in Smartsheet, eliminating context switching entirely.
Subscribe to the Smartsheet MCP Server and provide your Smartsheet Access Token.
Your AI client connects using that token, giving the agent read/write permissions to your workspace.
You ask a question (e.g., 'Update Sarah's status on the Project Roadmap sheet'). The agent executes the necessary tools (update_sheet_rows) and confirms completion.
Who is this actually for?
Anyone who spends too much time clicking between Smartsheet and email—Project Managers, Operations Analysts, or Data Coordinators. This is for the person tired of running five different reports just to figure out a single status update.
Uses list_sheets and search_within_sheet to quickly pull statuses, or uses update_sheet_rows to mark milestones complete across multiple sheets in one chat session.
Runs the directory tools (list_platform_users) and get_workspace_details to gather resource data or verify team membership for process automation.
Manages data integrity by listing columns (list_sheet_columns), verifying the structure, before using add_sheet_rows to input batch records.
What Changes When You Connect
Stop jumping between apps. You can list all managed sheets (list_sheets) and immediately check a specific column's value, all without leaving your agent client.
Control data mutation with precision. Instead of manual copy/pasting, use update_sheet_rows to change statuses or resource assignments across multiple records at once.
Always know the structure before you write. Use list_sheet_columns first; it tells you exactly what field names and types your agent needs when calling add_sheet_rows.
Find data faster than searching tabs. The search_within_sheet tool lets your agent filter through thousands of rows to pull out the exact answer you need.
Maintain a clear project view by listing all workspaces (list_workspaces) and getting overall details with get_workspace_details, keeping track of every active project container.
See it in action
The status report audit
A Project Manager needs to know the completion percentage for five different tracks. Instead of opening 5 sheets, they prompt their agent: 'Show me all active project sheets and what percentage complete they are.' The agent uses list_sheets and then executes structured searches on each one to compile a single summary report.
Resource cleanup
An Ops Analyst needs to clear out records for employees who left last quarter. They use the directory tools (list_platform_users) to verify current staff, then ask their agent to identify and run remove_sheet_row on all archived employee records from the master sheet.
Onboarding new team members
A Data Coordinator is building a resource tracker. They first call list_workspaces to find the correct project folder, then use list_sheet_columns on the target sheet to confirm all necessary fields exist before using add_sheet_rows to populate initial team data.
Finding a specific document detail
A PM needs one piece of information from an old, massive 'Master Data' sheet. Instead of scrolling through thousands of rows, they ask the agent to search_within_sheet for 'Q4 budget variance for Marketing.' The agent runs the search and provides only the relevant cell data.
The honest tradeoffs
Assuming a simple write endpoint
Thinking you can just tell your agent to 'Change John's status on the sheet.' This fails because the tool needs more than intent; it requires specific IDs and data.
You must first confirm the target row ID using search_within_sheet, then use that ID in the update_sheet_rows tool. The agent handles this multi-step process for you.
Overwriting entire sheets
Attempting to dump a huge CSV file and hoping the sheet just takes it over. This risks deleting existing metadata or breaking complex formulas.
Always use add_sheet_rows to append data, or run list_sheet_columns first to understand the exact structure before modifying anything.
Asking for a general 'report' without context
Prompting 'Give me the sales report.' The agent won't know which one you mean and will fail or list everything.
Use list_available_reports to see all options, then specify the exact name of the report you want metrics from.
When It Fits, When It Doesn't
Use this server if your workflow requires structured data management—you need to read metadata, modify specific cells/rows, or query information housed within a spreadsheet. It's designed for internal project tracking and operational databases.
Don't use it if you just need to draft an email, schedule a meeting reminder, or pull external public market data. For those tasks, use dedicated messaging or calendar APIs instead. If your goal is purely to gather high-level summaries that don't require modifying the underlying records, sometimes reading reports via other means (like BI tools) is cleaner than using list_available_reports.
It’s perfect for complex coordination: Use get_workspace_details to scope a project, then use search_within_sheet to find data in that project's core sheets.
Questions you might have
How do I list all active sheets in my Smartsheet account? +
You use the list_sheets tool. This instantly returns a directory of every sheet you have access to, so you don't have to manually browse your folder structure.
Can I update only one cell in a row using update_sheet_rows? +
Yes. The update_sheet_rows tool requires you to provide the specific Row IDs and the new values for the cells you want to change, making modifications precise.
What if I don't know what columns are in a sheet? +
Run list_sheet_columns. This tool reads the metadata and gives you a clean list of every column header available on that specific sheet, so your agent knows where to write data.
Does get_workspace_details give me everything about a project? +
It provides high-level details about the entire workspace—the container for related sheets and reports. It helps you understand the scope of the overall project, not just one sheet.
What credentials does `get_my_profile` require to successfully fetch my user information? +
You need a valid Smartsheet Access Token with at least read permissions. The token must be correctly configured in your client's environment variables for the call to succeed. It doesn't require specific scopes beyond basic profile access.
If I need to delete multiple rows, is it safe to use `remove_sheet_row` repeatedly? +
Yes, you can process deletions in batches using the tool. However, you must provide the unique row IDs for each call. Always confirm the ID before running the deletion command.
Does running many searches using `search_within_sheet` impact performance or hit rate limits? +
API calls are subject to rate limits enforced by Smartsheet. If you run too many searches rapidly, your AI client will receive a throttling error. It's best practice to implement a short delay between search operations.
What specific data points does `list_platform_users` return about all company users? +
This tool returns core user details, including name, email address, and basic group membership. It's designed for listing operational records rather than deep HR profile access.
How do I find my Smartsheet Access Token? +
Log in to Smartsheet, navigate to Account > Personal Settings > API Access, and generate a new access token for your integration.
We've already built the connector for Smartsheet. Just plug in your AI agents and start using Vinkius.
No hosting. No infrastructure. No complex setup.
All 12 tools are live and waiting.
You're up and running in seconds.
Gemini Vinkius gives your AI agents access to the full catalog of app connectors, all fully managed, secure, and enterprise-ready. One subscription, every tool you need.
Built, hosted, and secured by Vinkius. You just connect and go.