Smartsheet MCP Server

what is Smartsheet MCP Server?

Smartsheet MCP Server is a Model Context Protocol (MCP) server designed for interacting with the Smartsheet API, enabling users to search, retrieve, and update Smartsheet sheets through the MCP protocol.

how to use Smartsheet MCP Server?

To use the Smartsheet MCP Server, clone the repository, install dependencies, set up your Smartsheet API token in a .env file, and start the server using npm scripts or Node.js directly.

key features of Smartsheet MCP Server?

• Retrieve detailed information about Smartsheet sheets.
• Create, update, and delete sheets and rows.
• Create version backups of sheets at specific timestamps.
• Provide formatted responses optimized for AI consumption.

use cases of Smartsheet MCP Server?

1. Managing project sheets by updating and retrieving data.
2. Creating backups of sheets for version control.
3. Integrating Smartsheet functionalities into AI applications.

FAQ from Smartsheet MCP Server?

• What is required to run the Smartsheet MCP Server?

You need Node.js, npm, and a valid Smartsheet API token.

• Can I delete rows using this server?

Yes, but you must set the ALLOW_DELETE_TOOLS environment variable to 'true'.

• How do I create a backup of a sheet?

Use the create_version_backup tool with the required parameters.