Skip to main content

Smartsheet

Add rows, build reports, and chart your Smartsheet data on a dashboard.

Tools

61 available tools

Search the tool definitions captured from the MCP server. The live list can vary with version, deployment, and credentials.

61 tools found.

  • Add chart to dashboard

    Tool name: add_chart_to_dashboard

    Add a previously created chart to a Smartsheet dashboard as a widget.

  • Add columns

    Tool name: add_columns

    Adds one or more new columns to the specified sheet.

  • Add comment

    Tool name: add_comment

    Adds a new comment to an existing discussion.

  • Add rows

    Tool name: add_rows

    Adds one or more new rows to the specified sheet with optional positioning.

  • Attach URL

    Tool name: attach_url

    Attaches a URL to a Smartsheet sheet, row, or comment.

  • Browse folder

    Tool name: browse_folder

    Browse all children (nested folders, sheets, reports, dashboards, templates) within a folder.

  • Browse workspace

    Tool name: browse_workspace

    Browse all children (folders, sheets, reports, dashboards, templates) within a workspace.

  • Create chart from data

    Tool name: create_chart_from_data

    Build a chart structure from pre-computed data values (bar, line, pie, or stacked bar).

  • Create chart from prompt

    Tool name: create_chart_from_prompt

    Generate charts from a natural language description by starting (or continuing) a conversation against a sheet's data.

  • Create dashboard

    Tool name: create_dashboard

    Creates a new Smartsheet dashboard whose widgets are generated by AI from one or more sheets.

  • Create discussion

    Tool name: create_discussion

    Creates a new discussion on a sheet or specific row.

  • Create folder

    Tool name: create_folder

    Creates a new folder in a workspace or within another folder.

  • Create report

    Tool name: create_report

    Specify a destination (folder or workspace ID and type)

  • Create sheet

    Tool name: create_sheet

    Creates a new sheet within a specified Smartsheet folder or workspace.

  • Create workspace

    Tool name: create_workspace

    Creates a new workspace with a name.

  • Delete attachment

    Tool name: delete_attachment

    ⚠️ DESTRUCTIVE OPERATION: This tool PERMANENTLY DELETES an attachment from Smartsheet.

  • Delete column

    Tool name: delete_column

    ⚠️ DESTRUCTIVE OPERATION: This tool PERMANENTLY DELETES a column from Smartsheet.

  • Delete comment

    Tool name: delete_comment

    ⚠️ DESTRUCTIVE OPERATION: This tool PERMANENTLY DELETES a comment from Smartsheet.

  • Delete discussion

    Tool name: delete_discussion

    ⚠️ DESTRUCTIVE OPERATION: This tool PERMANENTLY DELETES an entire discussion and ALL its comments from Smartsheet.

  • Delete rows

    Tool name: delete_rows

    ⚠️ DESTRUCTIVE OPERATION: This tool PERMANENTLY DELETES rows from Smartsheet.

  • Execute AI solutions write

    Tool name: execute_ai_solutions_write

    Create comprehensive end-to-end Smartsheet solutions from natural language using AI (workspaces, sheets, dashboards, workflows/automations, reports, forms, and related assets as needed).

  • Read execute automations

    Tool name: execute_automations_read

    Query configured Smartsheet automations.

  • Write execute automations

    Tool name: execute_automations_write

    Manage configured Smartsheet automations.

  • Read execute discussions

    Tool name: execute_discussions_read

    Query discussions on a sheet or row, and retrieve a single discussion's full details.

  • Write execute discussions

    Tool name: execute_discussions_write

    Create discussions, and add, update, or delete comments and discussions.

  • Read execute portfolio

    Tool name: execute_portfolio_read

    Query portfolios, project templates, and projects — list, inspect, and retrieve details.

  • Write execute portfolio

    Tool name: execute_portfolio_write

    Create and delete portfolios, project templates, and projects.

  • Read execute reports

    Tool name: execute_reports_read

    Query reports — list accessible reports and retrieve a single report's data by ID.

  • Write execute reports

    Tool name: execute_reports_write

    Create reports, update a report's definition or its source sheets/workspaces, and add columns to a report.

  • Execute scenario planning read

    Tool name: execute_scenario_planning_read

    Query scenario plans, scenario diffs, capacity/workload, and scenario sheets — list, inspect, and retrieve details including individual rows.

  • Execute scenario planning write

    Tool name: execute_scenario_planning_write

    Create and delete scenario plans, create scenarios, apply scenario diffs to source sheets, and add, update, or delete rows in scenario sheets.

  • Read execute sharing

    Tool name: execute_sharing_read

    Query asset shares and the current user's favorites list, and check favorite status.

  • Write execute sharing

    Tool name: execute_sharing_write

    Add and remove items from the current user's favorites.

  • Read execute users

    Tool name: execute_users_read

    Query the current user's plan memberships, and a plan's license inventory, seat requests, and per-user seat usage.

  • Explain chart

    Tool name: explain_chart

    Explain how a chart answer in a conversation was produced — a plain-language summary plus the step-by-step reasoning.

  • Find in sheet

    Tool name: find_in_sheet

    Search for text within a specific Smartsheet sheet.

  • Get attachment

    Tool name: get_attachment

    Retrieves attachment metadata by ID including name, type, URL, size, and timestamps.

  • Get cell history

    Tool name: get_cell_history

    Retrieve the complete modification history for a specific cell in a Smartsheet.

  • Get chart definition

    Tool name: get_chart_definition

    Retrieve a saved chart-definition including its type, axes, styling, and configuration.

  • Get chart suggestions

    Tool name: get_chart_suggestions

    Get AI-powered chart suggestions for a Smartsheet sheet.

  • Get columns

    Tool name: get_columns

    Retrieves detailed column metadata from a Smartsheet.

  • Get dashboard

    Tool name: get_dashboard

    Retrieves detailed information about a specific dashboard by ID.

  • Get discussion

    Tool name: get_discussion

    Retrieves a single discussion by ID with full details including comments and attachments.

  • Get report

    Tool name: get_report

    Retrieves detailed report data by report ID including columns, rows, and cells.

  • Get resource guide

    Tool name: get_resource_guide

    Retrieve resource guides for tool operations.

  • Get sheet aggregates

    Tool name: get_sheet_aggregates

    Computes exact grouped counts (group_by), numeric statistics (summary_stats), and date-range overlap verdicts (overlap_group_by/overlap_start_column/overlap_end_column) over a sheet's rows — median,…

  • Get sheet path

    Tool name: get_sheet_path

    Get the full hierarchical path of a sheet within the Smartsheet workspace hierarchy, including the UNIX-style path and direct permalink, without loading the sheet itself.

  • Get sheet summary

    Tool name: get_sheet_summary

    Why this matters: Column names are CASE-SENSITIVE.

  • Get sheet version

    Tool name: get_sheet_version

    Get the current version number of a sheet without loading the entire sheet.

  • List attachments

    Tool name: list_attachments

    Retrieves a paginated list of attachments from a Smartsheet.

  • List dashboards

    Tool name: list_dashboards

    Retrieves a list of all dashboards (Sights) that the user has access to with pagination support.

  • List discussions

    Tool name: list_discussions

    Retrieves discussions from a Smartsheet.

  • List reports

    Tool name: list_reports

    List all reports accessible to the user.

  • List workspaces

    Tool name: list_workspaces

    Retrieves a list of workspaces from Smartsheet with pagination support.

  • Query chart

    Tool name: query_chart

    Query a saved chart-definition's data for visualization.

  • Refine chart

    Tool name: refine_chart

    Get suggested follow-up refinements for an existing chart in a conversation.

  • Search

    Tool name: search

    Search across all accessible Smartsheet assets (sheets, reports, dashboards, folders, workspaces) to discover and locate resources.

  • Search tools

    Tool name: search_tools

    Discover available tools by toolset and access type.

  • Update column

    Tool name: update_column

    ⚠️ DESTRUCTIVE OPERATION: This tool modifies column properties in Smartsheet.

  • Update comment

    Tool name: update_comment

    Updates the text of an existing comment.

  • Update rows

    Tool name: update_rows

    ⚠️ DESTRUCTIVE OPERATION: This tool modifies existing row data in Smartsheet.

Compatibility

Connect Smartsheet to the clients your teams already use

27 AI clients can connect to Smartsheet through Runlayer. Pick one for its setup steps and controls.

Why Runlayer

Why connect Smartsheet through Runlayer?

One approved path

Approve Smartsheet once and everyone gets it in the AI clients they already use. Runlayer holds the credentials, so nothing sits in client configuration.

Fine-grained policy

Control who can use each server, tool, and resource, and under which runtime conditions.

Runtime security

Scan tool inputs and outputs for prompt injection, credential exposure, PII, and data exfiltration, then alert, mask, or block.

Audit and observability

Trace every request across users, clients, tools, policies, scanner decisions, and downstream systems.

Frequently asked questions