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_dashboardAdd a previously created chart to a Smartsheet dashboard as a widget.
Add columns
Tool name:
add_columnsAdds one or more new columns to the specified sheet.
Add comment
Tool name:
add_commentAdds a new comment to an existing discussion.
Add rows
Tool name:
add_rowsAdds one or more new rows to the specified sheet with optional positioning.
Attach URL
Tool name:
attach_urlAttaches a URL to a Smartsheet sheet, row, or comment.
Browse folder
Tool name:
browse_folderBrowse all children (nested folders, sheets, reports, dashboards, templates) within a folder.
Browse workspace
Tool name:
browse_workspaceBrowse all children (folders, sheets, reports, dashboards, templates) within a workspace.
Create chart from data
Tool name:
create_chart_from_dataBuild a chart structure from pre-computed data values (bar, line, pie, or stacked bar).
Create chart from prompt
Tool name:
create_chart_from_promptGenerate charts from a natural language description by starting (or continuing) a conversation against a sheet's data.
Create dashboard
Tool name:
create_dashboardCreates a new Smartsheet dashboard whose widgets are generated by AI from one or more sheets.
Create discussion
Tool name:
create_discussionCreates a new discussion on a sheet or specific row.
Create folder
Tool name:
create_folderCreates a new folder in a workspace or within another folder.
Create report
Tool name:
create_reportSpecify a destination (folder or workspace ID and type)
Create sheet
Tool name:
create_sheetCreates a new sheet within a specified Smartsheet folder or workspace.
Create workspace
Tool name:
create_workspaceCreates 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_writeCreate 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_readQuery configured Smartsheet automations.
Write execute automations
Tool name:
execute_automations_writeManage configured Smartsheet automations.
Read execute discussions
Tool name:
execute_discussions_readQuery discussions on a sheet or row, and retrieve a single discussion's full details.
Write execute discussions
Tool name:
execute_discussions_writeCreate discussions, and add, update, or delete comments and discussions.
Read execute portfolio
Tool name:
execute_portfolio_readQuery portfolios, project templates, and projects — list, inspect, and retrieve details.
Write execute portfolio
Tool name:
execute_portfolio_writeCreate and delete portfolios, project templates, and projects.
Read execute reports
Tool name:
execute_reports_readQuery reports — list accessible reports and retrieve a single report's data by ID.
Write execute reports
Tool name:
execute_reports_writeCreate 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_readQuery 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_writeCreate 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_readQuery asset shares and the current user's favorites list, and check favorite status.
Write execute sharing
Tool name:
execute_sharing_writeAdd and remove items from the current user's favorites.
Read execute users
Tool name:
execute_users_readQuery the current user's plan memberships, and a plan's license inventory, seat requests, and per-user seat usage.
Explain chart
Tool name:
explain_chartExplain 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_sheetSearch for text within a specific Smartsheet sheet.
Get attachment
Tool name:
get_attachmentRetrieves attachment metadata by ID including name, type, URL, size, and timestamps.
Get cell history
Tool name:
get_cell_historyRetrieve the complete modification history for a specific cell in a Smartsheet.
Get chart definition
Tool name:
get_chart_definitionRetrieve a saved chart-definition including its type, axes, styling, and configuration.
Get chart suggestions
Tool name:
get_chart_suggestionsGet AI-powered chart suggestions for a Smartsheet sheet.
Get columns
Tool name:
get_columnsRetrieves detailed column metadata from a Smartsheet.
Get dashboard
Tool name:
get_dashboardRetrieves detailed information about a specific dashboard by ID.
Get discussion
Tool name:
get_discussionRetrieves a single discussion by ID with full details including comments and attachments.
Get report
Tool name:
get_reportRetrieves detailed report data by report ID including columns, rows, and cells.
Get resource guide
Tool name:
get_resource_guideRetrieve resource guides for tool operations.
Get sheet aggregates
Tool name:
get_sheet_aggregatesComputes 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_pathGet 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_summaryWhy this matters: Column names are CASE-SENSITIVE.
Get sheet version
Tool name:
get_sheet_versionGet the current version number of a sheet without loading the entire sheet.
List attachments
Tool name:
list_attachmentsRetrieves a paginated list of attachments from a Smartsheet.
List dashboards
Tool name:
list_dashboardsRetrieves a list of all dashboards (Sights) that the user has access to with pagination support.
List discussions
Tool name:
list_discussionsRetrieves discussions from a Smartsheet.
List reports
Tool name:
list_reportsList all reports accessible to the user.
List workspaces
Tool name:
list_workspacesRetrieves a list of workspaces from Smartsheet with pagination support.
Query chart
Tool name:
query_chartQuery a saved chart-definition's data for visualization.
Refine chart
Tool name:
refine_chartGet suggested follow-up refinements for an existing chart in a conversation.
Search
Tool name:
searchSearch across all accessible Smartsheet assets (sheets, reports, dashboards, folders, workspaces) to discover and locate resources.
Search tools
Tool name:
search_toolsDiscover 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_commentUpdates 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.