Smartsheet MCP Server

@smar-imran-khawaja

Basic information

About Smartsheet MCP Server

Smartsheet MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "smar-mcp-smar-imran-khawaja": {
      "command": "node",
      "args": [
        "-r",
        "dotenv/config",
        "build/index.js"
      ]
    }
  }
}

Smartsheet MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Smartsheet MCP Server?

A Model Context Protocol (MCP) server for interacting with the Smartsheet API. It provides tools for searching, retrieving, and updating Smartsheet sheets through the MCP protocol, relying on a Smartsheet API token for authentication.

How to use Smartsheet MCP Server?

Clone the repository, install dependencies, create a .env file with your SMARTSHEET_API_KEY, build the project, then start with npm run start or npm run dev. The server runs on stdio and exposes tools like get_sheet, update_rows, create_version_backup, and more. Configure Claude Desktop or Roo Code using the provided example config file.

Key features of Smartsheet MCP Server

Retrieve sheet data including rows, columns, and cells.
Create, update, and delete sheets and rows.
Create version backups from a specific ISO 8601 timestamp.
Responses formatted for AI consumption.
Copy sheets to the same or a different folder.
Add, update, and delete rows (deletion gated by an environment variable).

Use cases of Smartsheet MCP Server

Back up a sheet at a specific date/time for archival.
Retrieve and analyze sheet data via an AI assistant.
Automate row updates or additions from a chat interface.
Create new sheets with custom columns from a prompt.
Copy a sheet template to a new folder.

Frequently asked questions

What do I need to use this server?

You need a Smartsheet API token set in the `SMARTSHEET_API_KEY` environment variable, which can be obtained from the Smartsheet Developer Portal.

How do I enable deletion tools?

Set the environment variable `ALLOW_DELETE_TOOLS` to `'true'`; otherwise, `delete_rows` is unavailable.

What runtime requirements are there?

Node.js 16 or higher and npm 7 or higher are required.

How does this server authenticate with Smartsheet?

All operations use your Smartsheet API token to make direct API calls to Smartsheet; no other authentication is used.

What transport protocol does this server use?

It runs on stdio transport.

Comments

More Other MCP servers

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K