Integration · Projects & tasks

Connect Claude & ChatGPT to Smartsheet

Ask your AI what a sheet says, which rows are behind schedule, or to add a new line to a tracker in Smartsheet. It reads sheets, reports and dashboards, searches cell values, and adds and updates rows. It can also start and reply to conversations on rows and show how a cell has changed over time.

Connect Smartsheet free

Free plan, no credit card. Takes about a minute.

Try asking

“Which rows in the Project tracker have status At risk?”
The AI reads the sheet's columns and rows and lists the rows where Status is At risk, with owner and due date.
“Add a row to the Project tracker: Launch webinar, owner Lars, due 15 November.”
It looks up the column IDs and adds the row at the bottom with task name, owner and due date.
“Set the status of the Launch webinar row to Done.”
It finds the row and updates only the Status cell. The other cells stay as they are.

What your AI can do

Sheets and rows

Read sheets, rows and columns, add and update rows, create sheets in folders or workspaces, and delete rows.

Search, reports and dashboards

Search one sheet or everything you can see, and read reports, dashboards, sheet summaries and cell history.

Conversations and files

Read conversations on sheets and rows, comment on a row, reply to a comment and list attachments.

“Where do we mention supplier Nordtrans?”
It searches all sheets, reports and cell values you can see and lists where the name appears.
“Who changed the budget cell on the Kitchen renovation row, and what was it before?”
It reads the cell history with each earlier value, who changed it and when.
“Ask Mette on the Launch webinar row whether the speaker is confirmed.”
It starts a conversation on the row with your question, visible to everyone who works on the sheet.

173 tools for Smartsheet

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

add_rowsChanges dataAdd one or more rows to a sheet. `body` is a list of rows, each with `cells` ([{columnId, value}]) and a position such as toBottom: true.
archive_userVisible to othersDeactivate a user (user id). Has effects visible outside this system. API summary: Deactivate user.
comment_on_rowChanges dataStart a conversation on a row with a first `comment` ({"text": "..."}); people collaborating on the sheet can see it.
create_alternateemail_makeprimaryVisible to othersCreate a new makeprimary for a alternateemail. Has effects visible outside this system. API summary: Make alternate email primary.
create_attachment_versionChanges dataCreate a new version for a attachment. API summary: Attach new version.
create_comment_documentChanges dataCreate a new document for a comment. API summary: Attach file or URL to comment.
create_favoriteChanges dataCreate a new favorite. Required: body. API summary: Add favorites.
create_fieldChanges dataCreate a new field. Required: items. API summary: Add summary fields.
create_filtered_eventChanges dataCreate a new filtered event. API summary: List filtered events.
create_folderChanges dataCreate a new folder for a folder. API summary: Create folder.
create_folder_moveChanges dataCreate a new move for a folder. Required: destination id or destination type. API summary: Move folder.
create_groupChanges dataCreate a new group. API summary: Add group.
create_group_userChanges dataCreate a new user for a group. Search users first to avoid duplicates. API summary: Add group members.
create_imageurlChanges dataCreate a new imageurl. API summary: List image URLs.
create_messageVisible to othersCreate a new message. Has effects visible outside this system. API summary: Send rows via email.
create_moveChanges dataCreate a new move. API summary: Move rows to another sheet.
create_plan_downgradeChanges dataCreate a new downgrade for a plan. Required: seat type. API summary: Downgrade user.
create_plan_upgradeChanges dataCreate a new upgrade for a plan. API summary: Upgrade user.
create_proof_discussionChanges dataCreate a new discussion for a proof. API summary: Create proof discussion.
create_proof_requestChanges dataCreate a new request for a proof. API summary: Create proof request.
create_proof_versionChanges dataCreate a new version for a proof. API summary: Create proof version.
create_reportChanges dataCreate a new report. Required: name, columns, scope or destination. API summary: Create report.
create_report_columnChanges dataCreate a new column for a report. API summary: Add report columns.
create_report_scopeChanges dataCreate a new scope for a report. API summary: Add report scope.
create_row_documentChanges dataCreate a new document for a row. API summary: Attach file or URL to row.
create_shareChanges dataCreate a new share. Required: asset type or asset id. API summary: Share asset.
create_sheet_columnChanges dataCreate a new column for a sheet. API summary: Add columns.
create_sheet_crosssheetreferenceChanges dataCreate a new crosssheetreference for a sheet. Required: body. API summary: Create cross-sheet references.
create_sheet_discussionChanges dataCreate a new discussion for a sheet. API summary: Create discussion.
create_sheet_documentChanges dataCreate a new document for a sheet. API summary: Attach file or URL to sheet.
create_sheet_in_folderChanges dataCreate a new sheet in a folder. `body` holds the sheet `name` and its `columns` (title, type, one marked primary).
create_sheet_in_workspaceChanges dataCreate a new sheet in a workspace. `body` holds the sheet `name` and its `columns` (title, type, one marked primary).
create_sheet_messageVisible to othersCreate a new message for a sheet. Has effects visible outside this system. API summary: Send sheet via email.
create_sheet_moveChanges dataCreate a new move for a sheet. Required: destination id or destination type. API summary: Move sheet.
create_sheet_updaterequestChanges dataCreate a new updaterequest for a sheet. API summary: Create an update request.
create_sight_moveChanges dataCreate a new move for a sight. Required: destination id or destination type. API summary: Move dashboard.
create_userChanges dataCreate a new user. Search users first to avoid duplicates. API summary: Add user.
create_user_messageVisible to othersCreate a new message for a user. Has effects visible outside this system. API summary: Add alternate emails.
create_user_profileimageChanges dataCreate a new profileimage for a user. API summary: Update user profile image.
create_user_reactivateChanges dataCreate a new reactivate for a user. API summary: Reactivate user.
create_webhookDeletesCreate a new webhook. Destructive action; may require approval. API summary: Create webhook.
create_webhook_reset_shared_secretDeletesCreate a new reset shared secret for a webhook. Destructive action; may require approval.
create_workspaceChanges dataCreate a new workspace. API summary: Create workspace.
create_workspace_folderChanges dataCreate a new folder for a workspace. API summary: Create folder in workspace.
delete_attachment_versionsMoves moneyPermanently delete a version by attachment id. Financial or irreversible action; may require approval. API summary: Delete all versions.
delete_favoriteDeletesPermanently delete a favorite by favorite type. Destructive action; may require approval. API summary: Delete multiple favorites.
delete_favorite_delete_favorites_by_type_and_idDeletesPermanently delete a favorite by favorite id. Destructive action; may require approval. API summary: Delete favorite.
delete_fieldsMoves moneyPermanently delete a field by sheet id. Financial or irreversible action; may require approval. API summary: Delete summary fields.
delete_folderDeletesPermanently delete a folder by folder id. Destructive action; may require approval. API summary: Delete folder.
delete_groupDeletesPermanently delete a group by group id. Destructive action; may require approval. API summary: Delete group.
delete_group_userDeletesPermanently delete a user by user id. Destructive action; may require approval. API summary: Delete group members.
delete_proof_requestsMoves moneyPermanently delete a request by proof id. Financial or irreversible action; may require approval. API summary: Delete proof requests.
delete_proof_versionsMoves moneyPermanently delete a version by proof id. Financial or irreversible action; may require approval. API summary: Delete proof version.
delete_reportDeletesPermanently delete a report by report id. Destructive action; may require approval. API summary: Delete report.
delete_report_columnDeletesPermanently delete a column by column virtual id. Destructive action; may require approval. API summary: Delete report column.
delete_report_scopesMoves moneyPermanently delete a scope by report id. Financial or irreversible action; may require approval. API summary: Remove report scope.
delete_rowsMoves moneyDelete rows from a sheet by their IDs in `ids` (comma-separated). This permanently removes the rows and their comments and attachments.
delete_shareDeletesPermanently delete a share by share id. Destructive action; may require approval. API summary: Delete asset share.
delete_sheetDeletesPermanently delete a sheet by sheet id. Destructive action; may require approval. API summary: Delete sheet.
delete_sheet_automationruleDeletesPermanently delete a automationrule by automation rule id. Destructive action; may require approval. API summary: Delete an automation rule.
delete_sheet_columnDeletesPermanently delete a column by column id. Destructive action; may require approval. API summary: Delete column.
delete_sheet_discussionDeletesPermanently delete a discussion by discussion id. Destructive action; may require approval.
delete_sheet_documentDeletesPermanently delete a document by document id. Destructive action; may require approval. API summary: Delete attachment.
delete_sheet_messageDeletesPermanently delete a message by message id. Destructive action; may require approval. API summary: Delete a comment.
delete_sheet_proofDeletesPermanently delete a proof by proof id. Destructive action; may require approval. API summary: Delete proof.
delete_sheet_sentupdaterequestDeletesPermanently delete a sentupdaterequest by sent update request id. Destructive action; may require approval. API summary: Delete sent update request.
delete_sheet_updaterequestDeletesPermanently delete a updaterequest by update request id. Destructive action; may require approval. API summary: Delete an update request.
delete_sightDeletesPermanently delete a sight by sight id. Destructive action; may require approval. API summary: Delete dashboard.
delete_userDeletesPermanently delete a user by user id. Destructive action; may require approval. API summary: Remove user from organization.
delete_user_messageDeletesPermanently delete a message by alternate email id. Destructive action; may require approval. API summary: Delete alternate email.
delete_user_planDeletesPermanently delete a plan by plan id. Destructive action; may require approval. API summary: Remove user from plan.
delete_webhookDeletesPermanently delete a webhook by webhook id. Destructive action; may require approval. API summary: Delete webhook.
delete_workspaceDeletesPermanently delete a workspace by workspace id. Destructive action; may require approval. API summary: Delete workspace.
get_cell_historySee how one cell's value changed over time: who changed it, when and what it was, by sheet, row and column ID.
get_contactGet one contact by contact id. API summary: Get contact.
get_current_userGet the signed-in user's name, email, time zone and account.
get_dashboardGet a dashboard by ID with its widgets and their content.
get_dashboard_publish_statusVisible to othersPublish a sight (sight id). Has effects visible outside this system. API summary: Get dashboard publish status.
get_favoriteGet one favorite by favorite id. API summary: Is favorite.
get_groupGet one group by group id. API summary: Get group.
get_reportGet a report's columns and rows by `report_id`; use `page`/`limit` for big reports.
get_report_columnGet one column for a report by column virtual id. API summary: Get report column.
get_rowGet one row of a sheet by `sheet_id` and `row_id`, with all its cell values.
get_shareGet one share by share id. API summary: Get asset share.
get_sheetGet a sheet with its columns and rows by `sheet_id`. Limit the size with `row_ids`, `column_ids`, `rows_modified_since` or `page`/`limit` on big sheets.
get_sheet_automationruleGet one automationrule for a sheet by automation rule id. API summary: Get an automation rule.
get_sheet_columnGet one column for a sheet by column id. API summary: Get column.
get_sheet_crosssheetreferenceGet one crosssheetreference for a sheet by cross sheet reference id. API summary: Get cross-sheet reference.
get_sheet_discussionGet one discussion for a sheet by discussion id. API summary: Get discussion.
get_sheet_documentGet one document for a sheet by document id. API summary: Get attachment.
get_sheet_messageGet one message for a sheet by message id. API summary: Get a comment.
get_sheet_proofGet one proof for a sheet by proof id. API summary: Get proof.
get_sheet_publish_statusVisible to othersPublish a sheet (sheet id). Has effects visible outside this system. API summary: Get sheet publish status.
get_sheet_sentupdaterequestGet one sentupdaterequest for a sheet by sent update request id. API summary: Get sent update request.
get_sheet_summaryGet the sheet summary fields of a sheet (e.g. owner, status, budget).
get_sheet_updaterequestGet one updaterequest for a sheet by update request id. API summary: Get an update request.
get_userGet one user by user id. API summary: Get user.
get_user_messageGet one message for a user by alternate email id. API summary: Get alternate email.
get_webhookGet one webhook by webhook id. API summary: Get webhook.
list_attachment_versionsList versions for a attachment. Optional filters: include all. Results are paginated.
list_columnsList a sheet's columns with their IDs, titles and types; column IDs are needed to add or update rows.
list_contactsList contacts. Optional filters: include all, modified since or numeric dates. Results are paginated.
list_dashboardsList the dashboards you have access to.
list_discussion_documentsList documents for a discussion. Optional filters: include all. Results are paginated. API summary: List discussion attachments.
list_eventsList events. Optional filters: since, to, stream position, max count, numeric dates or managed plan id.
list_favoritesList favorites. Optional filters: include all. Results are paginated. API summary: Get favorites.
list_fieldsList fields. Optional filters: include all or exclude. Results are paginated. API summary: Get summary fields.
list_folder_contentsList the sheets, reports, dashboards and subfolders in a folder by `folder_id`.
list_folder_metadataList metadata for a folder. Optional filters: numeric dates. API summary: Get folder metadata.
list_folder_pathsList paths for a folder. API summary: Get folder path.
list_groupsList groups. Optional filters: include all, modified since or numeric dates. Results are paginated. API summary: List org groups.
list_org_sheetsList sheets. Optional filters: modified since. API summary: List org sheets.
list_proof_discussionsList discussions for a proof. Optional filters: include all. Results are paginated. API summary: List proof discussions.
list_proof_documentsList documents for a proof. Optional filters: include all. Results are paginated. API summary: List proof attachments.
list_proof_requestactionsList requestactions for a proof. Optional filters: include all. Results are paginated. API summary: List proof request actions.
list_proof_versionsList versions for a proof. Optional filters: include all. Results are paginated. API summary: List proof versions.
list_report_columnsList columns for a report. Optional filters: last key, max items or level. API summary: List report columns.
list_report_definitionsList definitions for a report. API summary: Get report definition.
list_report_pathsList paths for a report. API summary: Get report path.
list_report_scopesList scopes for a report. Optional filters: last key or max items. API summary: List report scope.
list_reportsList the reports you have access to.
list_row_attachmentsList the files and links attached to one row.
list_row_commentsList the conversations and comments on one row.
list_serverinfosList serverinfos. API summary: Gets application constants.
list_sharesList shares. Optional filters: asset type, asset id, max items, last key or sharing include. API summary: List asset shares.
list_sheet_attachmentsList all files and links attached to a sheet and its rows.
list_sheet_automationrulesList automationrules for a sheet. Optional filters: include all. Results are paginated. API summary: List all automation rules.
list_sheet_commentsList all conversations on a sheet, both sheet-level and on rows; set `include_all` for everything.
list_sheet_crosssheetreferencesList crosssheetreferences for a sheet. Optional filters: include all. Results are paginated. API summary: List cross-sheet references.
list_sheet_pathsList paths for a sheet. API summary: Get sheet path.
list_sheet_proofsList proofs for a sheet. Optional filters: include all. Results are paginated.
list_sheet_sentupdaterequestsList sentupdaterequests for a sheet. Optional filters: include all. Results are paginated. API summary: Lists sent update requests.
list_sheet_updaterequestsList updaterequests for a sheet. Optional filters: include all. Results are paginated. API summary: List update requests.
list_sheet_versionsList versions for a sheet. API summary: Get sheet version.
list_sheetsList the sheets you have access to, with their IDs and last-modified dates; set `include_all` to skip paging.
list_sight_pathsList paths for a sight. API summary: Get dashboard path.
list_user_messagesList messages for a user. API summary: List alternate emails.
list_user_plansList plans for a user. Optional filters: last key, max items or display contributor seat type. API summary: List user plans.
list_usersList the users in your organization, optionally filtered by `email`.
list_webhooksList webhooks. Results are paginated.
list_workspace_contentsList the sheets, reports, dashboards and folders in a workspace by `workspace_id`.
list_workspace_metadataList metadata for a workspace. Optional filters: numeric dates or access api level. API summary: Get workspace metadata.
list_workspacesList the workspaces you have access to, with their IDs.
reply_to_commentChanges dataReply in an existing conversation on a sheet with `discussion_id` and `text`.
search_everythingSearch all sheets, reports, workspaces and cell values you can see for the text in `query`; narrow with `scopes` (e.g. sheetNames, cellData).
search_sheetSearch the cells of one sheet (`sheet_id`) for the text in `query` and get the matching rows.
send_messageVisible to othersSend a message (report id). Has effects visible outside this system. API summary: Send report via email.
set_a_report_s_publish_statusVisible to othersPublish a report (report id). Has effects visible outside this system. API summary: Set a report's publish status.
set_dashboard_publish_statusVisible to othersPublish a sight (sight id). Has effects visible outside this system. API summary: Set dashboard publish status.
set_sheet_publish_statusVisible to othersPublish a sheet (sheet id). Has effects visible outside this system. API summary: Set sheet publish status.
submit_folderVisible to othersCopy a folder (folder id). Has effects visible outside this system. API summary: Copy folder.
submit_reportVisible to othersPublish a report (report id). Has effects visible outside this system. API summary: Gets a report's publish settings.
submit_rowVisible to othersCopy a row (sheet id). Has effects visible outside this system. API summary: Copy rows to another sheet.
submit_sheetVisible to othersCopy a sheet (sheet id). Has effects visible outside this system. API summary: Copy sheet.
submit_sightVisible to othersCopy a sight (sight id). Has effects visible outside this system. API summary: Copy dashboard.
submit_workspaceVisible to othersCopy a workspace (workspace id). Has effects visible outside this system. API summary: Copy workspace.
update_fieldsVisible to othersUpdate an existing field identified by sheet id. Has effects visible outside this system. API summary: Update summary fields.
update_folderChanges dataUpdate an existing folder identified by folder id. API summary: Update folder.
update_groupChanges dataUpdate an existing group identified by group id. API summary: Update group.
update_report_columnChanges dataUpdate an existing column identified by column virtual id. API summary: Update report column.
update_report_definitionsVisible to othersUpdate an existing definition identified by report id. Has effects visible outside this system. API summary: Update report definition.
update_rowsVisible to othersChange cell values in existing rows. `body` is a list of rows, each with its `id` and `cells` ([{columnId, value}]); only the given cells change.
update_shareChanges dataUpdate an existing share identified by share id. Only the fields you pass are changed. API summary: Update asset share.
update_sheetChanges dataUpdate an existing sheet identified by sheet id. API summary: Update sheet.
update_sheet_automationruleChanges dataUpdate an existing automationrule identified by automation rule id. API summary: Update an automation rule.
update_sheet_columnChanges dataUpdate an existing column identified by column id. API summary: Update column.
update_sheet_messageChanges dataUpdate an existing message identified by message id. API summary: Edit a comment.
update_sheet_proofChanges dataUpdate an existing proof identified by proof id. API summary: Update proof status.
update_sheet_updaterequestChanges dataUpdate an existing updaterequest identified by update request id. API summary: Update an update request.
update_sightChanges dataUpdate an existing sight identified by sight id. API summary: Update dashboard.
update_userChanges dataUpdate an existing user identified by user id. API summary: Update user.
update_webhookDeletesUpdate an existing webhook identified by webhook id. Destructive action; may require approval. API summary: Update webhook.
update_workspaceChanges dataUpdate an existing workspace identified by workspace id. API summary: Update workspace.

Set up in three steps

1
Pick the app
Create a free HeyMyApps account and choose Smartsheet from the app list.
2
Paste your key
Paste a Smartsheet API access token. Click your Account (profile image) at the bottom left > Personal Settings > API Access and choose Generate new access token. Copy it right away. API access requires a Smartsheet Business or Enterprise plan.
3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
1. Click your name, then Settings › Connectors › Add custom connector.
2. Paste your link as the Remote MCP server URL.
3. Switch it on from the + menu in a chat.

Questions

What can the AI do in Smartsheet?

The AI can list and read sheets, rows, columns, reports, dashboards, workspaces, folders, users, conversations and attachments, search cell values and read cell history. It can add and update rows, create sheets, comment on rows and reply to comments. It can also delete rows if you switch that tool on.

Does the AI see my Smartsheet access token?

No. Your Smartsheet credentials are encrypted at rest and never shown to the AI. After you save them, they are not shown again, not even to you. The AI only sees the results of the tools it calls.

Can I control what the AI is allowed to do?

Yes. You choose which tools are switched on, so you can start read-only. Deleting rows permanently removes them with their comments and attachments, so it can require your approval before it runs. Every tool call is logged.

Does it work with ChatGPT?

Yes. In ChatGPT go to Settings › Apps & Connectors › Advanced and turn on Developer mode, then add your HeyMyApps link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.

What does it cost?

HeyMyApps has a free plan with no credit card required. Paid plans bill per completed task. You also need your own Smartsheet account on a plan with API access.

Which Smartsheet plan do I need?

API access, which HeyMyApps uses, requires a Smartsheet Business or Enterprise plan. The AI works with the sheets, reports and workspaces that the owner of the access token can see.