Smartsheet MCP Server

Name: Smartsheet MCP Server
Author: smar-imran-khawaja

@smar-imran-khawaja

代码仓库

关于 Smartsheet MCP Server

基本信息

分类

其他

许可证

Apache-2.0 license

运行时

node

传输方式

stdio

发布者

smar-imran-khawaja

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.

其他分类下的更多 MCP 服务器

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K