Smartsheet MCP Server

@smar-imran-khawaja

About 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"
      ]
    }
  }
}

Tools

No tools detected

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.

FAQ from Smartsheet MCP Server

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.

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

Basic information

More Other MCP servers

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.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

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Inbox Zero AI MCP

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K