Smartsheet MCP server

Connect Smartsheet to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

Deploy SmartsheetBook a demo

What you can do with the Smartsheet MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the send sheet via email tool in Smartsheet
  • Use the add rows tool in Smartsheet
  • Use the create sheet tool in Smartsheet
  • Use the get sheet tool in Smartsheet
  • Use the list workspaces tool in Smartsheet
  • Use the manage folders tool in Smartsheet

Supported Tools

send_sheet_email

Send Sheet via Email

Send a sheet or specific rows via email to one or more recipients. Supports formatting options and optional CC to self.

add_rows

Add Rows

Add one or more rows to a sheet. Each row contains cell values mapped to column IDs. Rows can be positioned at the top, bottom, or relative to other rows.

create_sheet

Create Sheet

Create a new sheet with specified columns. Optionally create the sheet inside a folder or workspace. You can also create a sheet from a template by providing a template ID.

get_sheet

Get Sheet

Retrieve a sheet's full data including columns, rows, and cell values. Optionally filter by specific columns or rows. Use this to read sheet structure and data.

list_workspaces

List Workspaces

List all workspaces accessible to the current user. Workspaces are top-level containers for organizing sheets, reports, and dashboards.

manage_folders

Manage Folders

Create, list, update, or delete folders. Folders can be created at the home level, inside a workspace, or as subfolders within other folders. Use the **action** field to specify the operation.

manage_columns

Manage Columns

Add, update, or delete columns on a sheet. Use the **action** field to specify the operation. When adding columns, provide column definitions. When updating, provide the column ID and fields to change. When deleting, provide the column ID.

list_users

List Users

List all users in the organization account. Can filter by email address. Requires admin-level access or READ_USERS scope.

create_workspace

Create Workspace

Create a new workspace. Workspaces serve as top-level organizational containers with their own sharing permissions.

share_resource

Share Resource

Share a sheet or workspace with users or groups. List a page of current shares, add new shares, update access levels, or remove shares.

search

Search

Search across all accessible sheets or within a specific sheet. Returns matching results with context including the object type, parent sheet, and matched text.

list_reports

List Reports

List all reports accessible to the current user, or get the full data for a specific report. Reports aggregate data from multiple sheets and are read-only.

list_dashboards

List Dashboards

List all dashboards accessible to the current user, or get details for a specific dashboard. Dashboards (also known as Sights) aggregate information from sheets and reports into visual displays.

create_update_request

Create Update Request

Send update requests to collaborators asking them to update specific rows in a sheet. Recipients receive an email with a link to update the specified rows.

delete_sheet

Delete Sheet

Permanently delete a sheet. This action cannot be undone.

delete_workspace

Delete Workspace

Permanently delete a workspace and all its contents. This cannot be undone.

update_rows

Update Rows

Update one or more existing rows in a sheet. Can modify cell values, move rows to different positions, lock/unlock rows, or change their parent hierarchy.

update_sheet

Update Sheet

Update a sheet's properties such as its name. Can also copy or move a sheet to a different folder or workspace.

manage_discussions

Manage Discussions

List, create, or reply to discussions on sheets and rows. Discussions are threaded comment collections attached to a sheet or a specific row. Use **action** to specify the operation.

list_sheets

List Sheets

List all sheets accessible to the current user. Returns sheet metadata including names, IDs, access levels, and timestamps. Use pagination parameters to control result size.

delete_rows

Delete Rows

Delete one or more rows from a sheet by their IDs. This permanently removes the rows and their data.

get_workspace

Get Workspace

Get details of a workspace including its contained sheets, folders, reports, and dashboards.

get_current_user

Get Current User

Get the profile information of the currently authenticated user.

add_user

Add User

Add a new user to the organization. Requires ADMIN_USERS scope. The user will receive an invitation email.

get_row

Get Row

Retrieve one row with its cell values, formulas, position, and lock state. Use get_sheet to discover row IDs and column IDs.

Connect Smartsheet to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Smartsheet in Metorial. In your Metorial portal, enable the Smartsheet MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Smartsheet tools.

Run Smartsheet through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Smartsheet and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Smartsheet tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Smartsheet

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Slack

Slack: connect with bot OAuth or user OAuth to work with messages, conversations, search, files, Canvases, Lists, profiles, reactions, reminders, and workspace productivity settings.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Microsoft Outlook

Send, read, reply to, forward, and manage email messages in user mailboxes. Organize messages into folders, apply categories, flags, and importance levels. Manage file and item attachments. Create, update, delete, and respond to calendar events and meetings. Find available meeting times, manage attendees, handle recurrence, and work with shared or delegated calendars. Create, read, update, and delete contacts, organize them into contact folders, and manage contact photos. Manage tasks and task lists via Microsoft To Do, including due dates, reminders, recurrence, and checklist items. Support for Focused Inbox, @-mentions, mail tips, send-on-behalf, and send-as capabilities.

Linear

Create, read, update, and delete issues across teams with support for priorities, labels, assignees, due dates, and workflow states. Manage projects that group related issues, and organize work into time-boxed cycles (sprints). Create and manage documents, comments, and file attachments. Search issues using vector similarity or rich filters. Configure teams, workflow states, and labels. Track customers and link them to issues.

Technical notes for Smartsheet

Create and manage sheets, rows, columns, workspaces, and folders. Read dashboards and reports, search sheet data, discuss work, send sheets or rows by email, and request collaborator updates. Share sheets and workspaces with users or groups, and retrieve the current user profile.

Frequently asked questions

Common questions about connecting Smartsheet to AI agents with Metorial.

  1. How many tools does the Smartsheet MCP server have?
    The Smartsheet MCP server exposes 25 tools, including Send Sheet via Email, Add Rows, Create Sheet. Each one is governed and traced through Metorial.
  2. Smartsheet exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Smartsheet MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Smartsheet and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Smartsheet MCP server yourself or use the hosted gateway.

Connect Smartsheet to production AI agents

See how Metorial gives your team governed access to Smartsheet, with tracing and security controls built in.

Book a demoDeploy Smartsheet