smartsheet_get_ reportGet report.
Ask which tasks in your project plan are overdue, add this week's leads as new rows, change a status by column name, attach the signed contract and share the sheet with your team, all from your AI client.
PopMCPSmartsheet
Every Smartsheet API call a user's token can make, from sheets, rows, columns and cell history to attachments, comments, proofs, reports, dashboards, workspaces, sharing, webhooks and admin, plus everyday tools that read and write rows by column name.
186 tools in the full catalog: 79 read and 107 write. 37 load by default, and the rest are found with tool search.
smartsheet_get_ reportGet report.
smartsheet_list_ reportsList reports.
smartsheet_copy_ sheetCopy sheet.
smartsheet_create_ sheet_ in_ folderCreate sheet in folder.
smartsheet_create_ sheet_ in_ workspaceCreate sheet in workspace.
smartsheet_describe_ sheetWhat a sheet looks like before reading or writing it: every column with its id, type (TEXT_NUMBER, DATE, CHECKBOX, PICKLIST, CONTACT_LIST...), allowed picklist values and whether Smartsheet fills it in itself, plus the row count, link and summary fields.
smartsheet_export_ csvA whole sheet or report as CSV text (the first row is the column names), cut off at 150,000 characters.
smartsheet_get_ sheetGet sheet.
smartsheet_list_ sheetsList sheets.
smartsheet_update_ sheetUpdate sheet.
smartsheet_get_ current_ userGet current user.
smartsheet_add_ recordsAdd rows to a sheet by column NAME: records [{ "Task": "Draft brief", "Due": "2026-11-01", "Owner": "sam@example.com" }].
smartsheet_add_ rowsAdd rows.
smartsheet_attach_ to_ rowAttach file or URL to row.
smartsheet_delete_ rowsDelete rows.
smartsheet_get_ attachmentGet attachment.
smartsheet_get_ recordsRead a sheet's rows as records keyed by column NAME: [{ _rowId, _rowNumber, "Task": "...", "Due": "2026-11-01", "Done": false }].
smartsheet_get_ rowGet row.
smartsheet_update_ recordsChange cells in existing rows by column NAME: updates [{ rowId, values: { "Status": "Done", "Done": true } }].
smartsheet_update_ rowsUpdate rows.
smartsheet_get_ dashboardGet Dashboard.
smartsheet_list_ dashboardsList dashboards.
smartsheet_create_ folder_ in_ workspaceCreate folder in workspace.
smartsheet_create_ update_ requestCreate an update request.
smartsheet_list_ folder_ childrenList folder children.
smartsheet_list_ workspace_ childrenList workspace children.
smartsheet_list_ workspacesList workspaces.
smartsheet_create_ row_ discussionCreate a discussion on a row.
smartsheet_list_ discussionsList discussions.
smartsheet_add_ columnsAdd columns.
smartsheet_list_ columnsList columns.
smartsheet_list_ sharesList asset shares.
smartsheet_share_ assetShare asset.
smartsheet_add_ commentCreate a comment.
smartsheet_findFind a sheet, report, dashboard, workspace or folder by its NAME and get its numeric id.
smartsheet_searchSearch everything.
smartsheet_import_ sheet_ into_ workspaceImport sheet into workspace.
smartsheet_add_ report_ columnsAdd report columns.
smartsheet_add_ report_ scopeAdd report scope.
smartsheet_create_ reportCreate report.
smartsheet_delete_ reportDelete report.
smartsheet_delete_ report_ columnDelete report column.
smartsheet_get_ report_ columnGet report column.
smartsheet_get_ report_ definitionGet report definition.
smartsheet_get_ report_ pathGet report path.
smartsheet_get_ report_ publish_ statusGets a report's publish settings.
smartsheet_get_ report_ scopeList report scope.
smartsheet_list_ report_ columnsList report columns.
smartsheet_remove_ report_ scopeRemove report scope.
smartsheet_send_ report_ via_ emailSend report via email.
smartsheet_set_ report_ publish_ statusSet a report's publish status.
smartsheet_update_ report_ columnUpdate report column.
smartsheet_update_ report_ definitionUpdate report definition.
smartsheet_delete_ sheetDelete sheet.
smartsheet_get_ sheet_ pathGet sheet path.
smartsheet_get_ sheet_ publish_ statusGet sheet publish status.
smartsheet_get_ sheet_ versionGet sheet version.
smartsheet_list_ organization_ sheetsList org sheets.
smartsheet_move_ sheetMove sheet.
smartsheet_send_ sheet_ via_ emailSend sheet via email.
smartsheet_set_ sheet_ publish_ statusSet sheet publish status.
smartsheet_attach_ to_ proofAttach file to proof.
smartsheet_create_ proofCreate proof.
smartsheet_create_ proof_ discussionCreate proof discussion.
smartsheet_create_ proof_ requestsCreate proof request.
smartsheet_create_ proof_ versionCreate proof version.
smartsheet_delete_ proofDelete proof.
smartsheet_delete_ proof_ requestsDelete proof requests.
smartsheet_delete_ proof_ versionDelete proof version.
smartsheet_get_ proofGet proof.
smartsheet_list_ proof_ attachmentsList proof attachments.
smartsheet_list_ proof_ discussionsList proof discussions.
smartsheet_list_ proof_ request_ actionsList proof request actions.
smartsheet_list_ proof_ versionsList proof versions.
smartsheet_list_ proofsList proofs.
smartsheet_update_ proofUpdate proof status.
smartsheet_add_ userAdd user.
smartsheet_deactivate_ userDeactivate user.
smartsheet_downgrade_ user_ seatDowngrade user.
smartsheet_get_ userGet user.
smartsheet_list_ user_ plansList user plans.
smartsheet_list_ usersList users.
smartsheet_reactivate_ userReactivate user.
smartsheet_remove_ userRemove user from organization.
smartsheet_remove_ user_ from_ planRemove user from plan.
smartsheet_update_ userUpdate user.
smartsheet_update_ user_ profile_ imageUpdate user profile image.
smartsheet_upgrade_ user_ seatUpgrade user.
smartsheet_attach_ to_ commentAttach file or URL to comment.
smartsheet_attach_ to_ sheetAttach file or URL to sheet.
smartsheet_copy_ rowsCopy rows to another sheet.
smartsheet_delete_ attachmentDelete attachment.
smartsheet_delete_ attachment_ versionsDelete all versions.
smartsheet_list_ attachment_ versionsList versions.
smartsheet_list_ discussion_ attachmentsList discussion attachments.
smartsheet_list_ row_ attachmentsList row attachments.
smartsheet_list_ sheet_ attachmentsList attachments.
smartsheet_move_ rowsMove rows to another sheet.
smartsheet_send_ rows_ via_ emailSend rows via email.
smartsheet_sort_ rowsSort rows in sheet.
smartsheet_upload_ attachment_ versionAttach new version.
smartsheet_copy_ dashboardCopy dashboard.
smartsheet_delete_ dashboardDelete dashboard.
smartsheet_get_ dashboard_ pathGet dashboard path.
smartsheet_get_ dashboard_ publish_ statusGet dashboard publish status.
smartsheet_move_ dashboardMove dashboard.
smartsheet_set_ dashboard_ publish_ statusSet dashboard publish status.
smartsheet_update_ dashboardUpdate dashboard.
smartsheet_change_ update_ requestUpdate an update request.
smartsheet_copy_ folderCopy folder.
smartsheet_copy_ workspaceCopy workspace.
smartsheet_create_ folder_ in_ folderCreate folder.
smartsheet_create_ workspaceCreate workspace.
smartsheet_delete_ folderDelete folder.
smartsheet_delete_ sent_ update_ requestDelete sent update request.
smartsheet_delete_ update_ requestDelete an update request.
smartsheet_delete_ workspaceDelete workspace.
smartsheet_get_ folderGet folder metadata.
smartsheet_get_ folder_ pathGet folder path.
smartsheet_get_ sent_ update_ requestGet sent update request.
smartsheet_get_ update_ requestGet an update request.
smartsheet_get_ workspaceGet workspace metadata.
smartsheet_list_ sent_ update_ requestsLists sent update requests.
smartsheet_list_ update_ requestsList update requests.
smartsheet_move_ folderMove folder.
smartsheet_update_ folderUpdate folder.
smartsheet_update_ workspaceUpdate workspace.
smartsheet_add_ image_ to_ summary_ fieldAdd image to sheet summary.
smartsheet_add_ summary_ fieldsAdd summary fields.
smartsheet_create_ sheet_ discussionCreate discussion.
smartsheet_create_ webhookCreate webhook.
smartsheet_delete_ discussionDelete a discussion.
smartsheet_delete_ summary_ fieldsDelete summary fields.
smartsheet_delete_ webhookDelete webhook.
smartsheet_get_ discussionGet discussion.
smartsheet_get_ sheet_ summaryGet sheet summary.
smartsheet_get_ webhookGet webhook.
smartsheet_list_ row_ discussionsList discussions with a row.
smartsheet_list_ summary_ fieldsGet summary fields.
smartsheet_list_ webhooksList webhooks.
smartsheet_reset_ webhook_ shared_ secretReset shared secret.
smartsheet_update_ summary_ fieldsUpdate summary fields.
smartsheet_update_ webhookUpdate webhook.
smartsheet_add_ alternate_ emailsAdd alternate emails.
smartsheet_add_ favoritesAdd favorites.
smartsheet_create_ groupAdd group.
smartsheet_delete_ alternate_ emailDelete alternate email.
smartsheet_delete_ columnDelete column.
smartsheet_delete_ favoriteDelete favorite.
smartsheet_delete_ favorites_ by_ typeDelete multiple favorites.
smartsheet_delete_ groupDelete group.
smartsheet_delete_ shareDelete asset share.
smartsheet_get_ alternate_ emailGet alternate email.
smartsheet_get_ columnGet column.
smartsheet_get_ favoriteIs favorite.
smartsheet_get_ groupGet group.
smartsheet_get_ shareGet asset share.
smartsheet_list_ alternate_ emailsList alternate emails.
smartsheet_list_ favoritesGet favorites.
smartsheet_list_ groupsList org groups.
smartsheet_make_ alternate_ email_ primaryMake alternate email primary.
smartsheet_update_ columnUpdate column.
smartsheet_update_ groupUpdate group.
smartsheet_update_ shareUpdate asset share.
smartsheet_delete_ automation_ ruleDelete an automation rule.
smartsheet_delete_ commentDelete a comment.
smartsheet_get_ automation_ ruleGet an automation rule.
smartsheet_get_ commentGet a comment.
smartsheet_list_ automation_ rulesList all automation rules.
smartsheet_update_ automation_ ruleUpdate an automation rule.
smartsheet_update_ commentEdit a comment.
smartsheet_create_ cross_ sheet_ referenceCreate cross-sheet references.
smartsheet_get_ cross_ sheet_ referenceGet cross-sheet reference.
smartsheet_list_ cross_ sheet_ referencesList cross-sheet references.
smartsheet_search_ sheetSearch sheet.
smartsheet_add_ group_ membersAdd group members.
smartsheet_add_ image_ to_ cellAdd image to cell.
smartsheet_get_ contactGet contact.
smartsheet_import_ sheet_ into_ folderImport sheet into folder.
smartsheet_list_ contactsList contacts.
smartsheet_list_ eventsList events.
smartsheet_list_ filtered_ eventsList filtered events.
smartsheet_list_ image_ urlsList image URLs.
smartsheet_remove_ group_ memberDelete group members.
smartsheet_get_ cell_ historyList cell history.
smartsheet_get_ server_ infoGets application constants.
Credentials off one Smartsheet screen, then an endpoint your client signs into. Nothing to deploy, and nothing to install.
In Smartsheet open Account, Personal settings, API access and generate an access token, then copy it into PopMCP. PopMCP works out by itself whether your account is in the US, Europe, Australia or Smartsheet Gov. The Smartsheet API needs a Business or Enterprise plan.
••••••••••••3f7aAdding, changing and deleting rows, columns, sheets and shares, sending email and creating webhooks wait until an owner or admin allows write actions; new connections start read-only. An access token carries everything its Smartsheet user can do, so the read-only switch is what keeps it to reading.
Drop the PopMCP URL into Claude, ChatGPT, Claude Code, Codex or any other supported client. It signs in through PopMCP with OAuth, so your Smartsheet credential never leaves the server.
app.popmcp.com/mcpAsk for something harmless before the agent changes anything. Writes run as soon as it calls them, so confirm it reads the right account first.
Which tasks in our launch plan are overdue or at risk, and who owns each one?
smartsheet_findok
Then just ask for the work
“Which tasks in our launch plan are overdue or at risk, and who owns each one?”
“Add these five new leads to the Sales pipeline sheet with their company, owner and next step”
“Mark the design review task as done and set its status to Complete”
“Attach this signed contract to the Acme row and leave a comment for the account owner”
“Share the marketing calendar with sam@example.com as an editor”
“Export the budget report as CSV and tell me which lines are over plan”
One hosted endpoint, registered once per client. The same tools and the same permissions, whichever window the request comes from.
Add the PopMCP URL under Customize → Connectors and the tools appear in every chat.
The same endpoint, registered in the browser. Nothing to install on the machine you are working from.
Register PopMCP as a custom connector, then let ChatGPT read and update the account.
Wire the endpoint into Codex or the Codex CLI when a task needs live business context, not a fixture.
Register the remote MCP server in OpenCode's config for terminal-first and scripted agent runs.
Add PopMCP as an MCP server in Z.ai's desktop app and work the account from the same window.
FAQ
What teams ask before putting Smartsheet behind an AI client.
A Smartsheet API access token on a Business or Enterprise plan. In Smartsheet select Account (your picture at the bottom left), then Personal settings, API access and Generate new access token, name it PopMCP and copy it right away: Smartsheet shows it only once. PopMCP checks it, finds your region and stores it encrypted.
Yes. Each region is a separate Smartsheet with its own address and its own tokens. PopMCP tries your token on each one and remembers the region that accepts it, so you never pick a region and every request goes straight to the right place.
Yes. Smartsheet's API addresses every cell by a numeric column id, so PopMCP adds tools that work by column name: smartsheet_get_records reads rows as simple records with filters, and smartsheet_add_records and smartsheet_update_records write them, converting checkboxes, dropdown lists, contacts and formulas for you. smartsheet_find turns a sheet's name into its id.
Exactly what is shared with the Smartsheet user whose token you connect, at the level it is shared: Viewer, Commenter, Editor, Admin or Owner. Connecting PopMCP never widens that. System Admin features such as user management and Event Reporting only work when that user is a System Admin.
Yes. The AI can attach a file or a link to a sheet, row or comment, upload new versions, add images to cells and import a CSV or Excel file as a new sheet, from text, base64 or a public https link PopMCP downloads (up to 25 MB, inside Smartsheet's own 30 MB limit).
Smartsheet allows 300 requests a minute per token, and 30 a minute for file uploads and cell history; PopMCP retries a rate-limited call for you. One request adds or updates up to 500 rows, and PopMCP's row tools split bigger jobs into batches of that size.
Yes. Smartsheet sends events for a sheet when its rows, cells, columns, comments or attachments change, and PopMCP lists those as triggers for the sheets you choose, alongside watches for new sheets, reports, dashboards and workspaces and for summary numbers crossing a level.
No. PopMCP hosts it and gives you a Streamable HTTP MCP URL. There is nothing to deploy, no callback URL to register, and no infrastructure to keep running or patch.
Any client that supports a remote Streamable HTTP MCP server: Claude Desktop, Claude Web, Claude Code, ChatGPT custom connectors, Codex and the Codex CLI, OpenCode and Z.ai's ZCode, as well as editors such as Cursor, Windsurf and Zed. Your client signs in to PopMCP with OAuth; the provider credential never leaves the server.
Connect Smartsheet in PopMCP first, then run claude mcp add --transport http popmcp https://app.popmcp.com/mcp in a terminal. Inside Claude Code, run /mcp and sign in to PopMCP in the browser window it opens, ticking Smartsheet on the consent screen. The Smartsheet tools are then available in that session, and no Smartsheet credential is stored on your machine.
Loading 186 tool definitions into every conversation burns context before the work starts. PopMCP loads a curated 37-tool set covering the everyday workflows and keeps the rest searchable, so your AI pulls a specialist tool only when a task needs it. Every tool stays searchable, and on Scale the owner can load the full catalog for a teammate's connection.
A tool is something your AI calls, and there are 186 here. A trigger is something PopMCP watches for you: 24 Smartsheet events that can start work on the PopMCP side. Triggers never enter your AI client's context, and none of them ask you to paste a callback URL into Smartsheet.
Launch a hosted MCP endpoint for Smartsheet, keep tool access under control, and start testing real workflow prompts right away.