Smartsheet MCP Server

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.