LABSCO SUMMARY

Sheet edits that respect the sheet.

Smartsheet is not a spreadsheet you can safely write to blindly: column types and formula references make some writes valid and others destructive. Reading the structure first and validating against it is what makes an automated update survivable.

What it is

An MCP server for Smartsheet covering document management, data operations and column customisation. It validates against column types, preserves and updates formula references as rows change, and adds batch processing and custom scoring for larger analytical workloads.

What you get

A sheet's structure and metadata read before anything is changed (get_sheet_info)
A column map of the sheet, so updates address the right columns (get_column_map)
Create, update and delete across rows and columns, validated against the column types
Formula references preserved and updated automatically as the sheet changes
Batch processing for large datasets
Custom scoring systems applied to sheet data
Error handling and validation at each layer, with referential integrity maintained across operations

Requirements

Both runtimes installed: the server pairs a Node MCP layer with the smartsheet_ops Python package, so it needs Node.js and Python — plus Smartsheet access for the sheets you intend to touch.

Setup effort

Follow the published steps — conda create -n cline_mcp_env python=3.12 nodejs -y

See installation options

USE CASES

01

Understanding a sheet before you touch it

Structure and metadata come back first, so an update is written against the sheet as it is rather than as someone described it.

get_sheet_info

02

Addressing the right column when updating rows

The column map ties column names to their ids and types, which is what stops an update landing in the wrong field.

get_column_map

03

Applying a change across many rows

Batch processing handles large datasets in one pass, with column-type validation applied to every row rather than the first one.

04

Scoring a dataset against your own criteria

Custom scoring systems run over sheet data, so a scoring model lives with the sheet instead of in someone's spreadsheet copy.

34 tools

Listed in project docs. Your client may show a different list.

get_column_map

get_sheet_info

smartsheet_write

smartsheet_update

smartsheet_delete

smartsheet_search

smartsheet_add_column

smartsheet_delete_column

smartsheet_rename_column

smartsheet_bulk_update

get_all_row_ids

start_batch_analysis

get_job_status

cancel_batch_analysis

list_workspaces

BEFORE YOU INSTALL

What to know first

Tools you get

34 tools named in the project's documentation.

Requires

SMARTSHEET_API_KEY in your environment

INSTALLATION

Connect your client

Server setup

TERMINAL

conda create -n cline_mcp_env python=3.12 nodejs -y
conda activate cline_mcp_env
npm install
cd smartsheet_ops
pip install -e .
cd ..
npm run build

MCP Clients

Cline

CLINE · JSON

{
  "mcpServers": {
    "smartsheet": {
      "command": "/Users/<YOUR_USERNAME>/anaconda3/envs/cline_mcp_env/bin/node",
      "args": [
        "<YOUR_PATH_TO_SMARTSHEET_SERVER>/build/index.js",
        "--transport",
        "stdio"
      ],
      "env": {
        "PYTHON_PATH": "/Users/<YOUR_USERNAME>/anaconda3/envs/cline_mcp_env/bin/python3",
        "SMARTSHEET_API_KEY": "<YOUR_SMARTSHEET_API_KEY>",
        "AZURE_OPENAI_API_KEY": "<YOUR_AZURE_OPENAI_API_KEY>",
        "AZURE_OPENAI_API_BASE": "<YOUR_AZURE_OPENAI_API_BASE>",
        "AZURE_OPENAI_API_VERSION": "<YOUR_AZURE_OPENAI_API_VERSION>",
        "AZURE_OPENAI_DEPLOYMENT": "<YOUR_AZURE_OPENAI_DEPLOYMENT>"
      },
      "disabled": false
    }
  }
}

Any MCP client — HTTP

Start the server in HTTP mode

ANY MCP CLIENT — HTTP · TERMINAL

PYTHON_PATH=/Users/<YOUR_USERNAME>/anaconda3/envs/cline_mcp_env/bin/python3 SMARTSHEET_API_KEY=<YOUR_SMARTSHEET_API_KEY> node build/index.js --transport http

ANY MCP CLIENT — HTTP · JSON

{
  "mcpServers": {
    "smartsheet-server": {
      "type": "http",
      "url": "http://localhost:3000/mcp",
      "headers": {
        "Authorization": "Bearer <YOUR_OPTIONAL_AUTH_TOKEN>"
      }
    }
  }
}

Smartsheet