Smartsheet Integration

Pro v1.0.0

Manage sheets, rows, columns, attachments, and collaborate on work through the Smartsheet API

Requires Claude Code CLI

This skill integrates with Smartsheet through Claude Code. Install Claude Code and add this skill to use it.

Available Actions

List Sheets

List all sheets accessible to your account

Returns

array List of sheets with IDs, names, and permalinks

Try saying...

  • "Show me all my Smartsheet sheets"
  • "List my Smartsheet workspaces"
  • "What sheets do I have access to?"

Get Sheet Details

Retrieve detailed information about a specific sheet including rows, columns, and cell values

Parameters

Name Type Required Description
sheet_id integer Required The numeric ID of the sheet

Returns

object Complete sheet data including structure and content

Try saying...

  • "Get details for sheet 123456789"
  • "Show me the contents of sheet 987654321"
  • "What's in my project plan sheet?"

Add Row to Sheet

Add a new row to a sheet with specified cell values

Parameters

Name Type Required Description
sheet_id integer Required The numeric ID of the sheet
cells object Required JSON object mapping column names to cell values

Returns

object The created row with assigned row ID

Try saying...

  • "Add a row to sheet 123456789 with task 'Review budget'"
  • "Create a new task in my project sheet"
  • "Add a new entry to the team roster"

Update Row

Update an existing row with new cell values

Parameters

Name Type Required Description
sheet_id integer Required The numeric ID of the sheet
row_id integer Required The numeric ID of the row to update
cells object Required JSON object mapping column names to new cell values

Returns

object The updated row data

Try saying...

  • "Update row 999888777 to set status to Complete"
  • "Change the assignee on row 123456 to John Doe"
  • "Mark task as finished"

List Discussions

List all discussions (comment threads) on a sheet

Parameters

Name Type Required Description
sheet_id integer Required The numeric ID of the sheet

Returns

array List of discussions with comments

Try saying...

  • "Show me all discussions on sheet 123456789"
  • "List comments on my project plan"
  • "What conversations are happening on this sheet?"

Add Comment

Add a comment to a sheet or specific row

Parameters

Name Type Required Description
sheet_id integer Required The numeric ID of the sheet
comment string Required The comment text to add
row_id integer Optional Optional row ID to attach comment to specific row

Returns

object The created comment/discussion

Try saying...

  • "Add a comment to sheet 123456789"
  • "Post 'Great progress!' on the project sheet"
  • "Comment on row 999888777"

List Attachments

List all attachments on a sheet

Parameters

Name Type Required Description
sheet_id integer Required The numeric ID of the sheet

Returns

array List of attachments with names, types, and URLs

Try saying...

  • "Show me attachments on sheet 123456789"
  • "List files attached to my project plan"
  • "What documents are on this sheet?"

Get Current User Info

Get information about the currently authenticated user

Returns

object User account details including email, name, and account type

Try saying...

  • "Who am I authenticated as?"
  • "Show my Smartsheet user info"
  • "What's my account email?"

Getting Started

API Key Easy Setup
  1. 1 Log in to Smartsheet at https://app.smartsheet.com
  2. 2 Click your profile picture > Apps & Integrations
  3. 3 Click API Access in the left sidebar
  4. 4 Click 'Generate new access token'
  5. 5 Give your token a descriptive name
  6. 6 Copy the token (shown only once)
  7. 7 Add to shell config: echo 'export SMARTSHEET_ACCESS_TOKEN="YOUR_TOKEN"' >> ~/.zshrc
  8. 8 Restart terminal or run: source ~/.zshrc

Verify Setup

python scripts/client.py whoami

Success: Returns user account information

View full setup guide

Security & Access

Access Scope

Full access to all Smartsheet resources accessible by your user account, including read, write, update, and delete permissions on sheets, rows, columns, attachments, users, and workspaces

  • Your API token grants the same level of access as your user account
  • Anyone with your token can read, modify, or delete your Smartsheet data
  • Never commit tokens to version control or share them publicly
  • Use shared service accounts for team integrations rather than personal accounts
  • Tokens for Smartsheet Gov and Regions Europe are separate from Smartsheet.com
  • Revoke compromised tokens immediately from the Smartsheet UI

Limitations

  • API token has same permissions as the user account
  • Separate tokens required for Smartsheet Gov and Smartsheet Regions Europe
  • Some advanced features may require specific account types
  • Large sheets may have performance considerations

Get This Skill

Requires Pro subscription ($9/month)

Quick Reference

Type
PYTHON_SDK
Auth
API Key
Setup
Easy Setup
Tools Required
Bash
Python Dependencies
smartsheet-python-sdk>=2.177.0

Documentation

Have Feedback?

Help us improve this skill by sharing your ideas and suggestions.

Request Improvements