Advertise
MCP.so
Sign In

Smartsheet MCP Server

@smar-imran-khawaja

Repository

Basic information

Category

Other

License

Apache-2.0 license

Transports

stdio

Author

smar-imran-khawaja

About Smartsheet MCP Server

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

1

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.

2

How do I enable deletion tools?

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

3

What runtime requirements are there?

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

4

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.

5

What transport protocol does this server use?

It runs on stdio transport.

Comments

More Other MCP servers

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.

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

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

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K
Advertise