Smartsheet MCP Server for Cloudflare Workers
132 tools available in the Smartsheet MCP server. Each tool can be called by AI assistants to perform specific actions.
smartsheet_get_groupGet a group by ID.
{
"type": "object",
"required": [
"groupId"
],
"properties": {
"groupId": {
"type": "number",
"description": "Group ID"
}
}
}smartsheet_delete_dashboardDelete a dashboard.
{
"type": "object",
"required": [
"dashboardId"
],
"properties": {
"dashboardId": {
"type": "number",
"description": "Dashboard ID to delete"
}
}
}smartsheet_update_sheet_shareUpdate a sheet share's access level.
{
"type": "object",
"required": [
"sheetId",
"shareId"
],
"properties": {
"shareId": {
"type": "string",
"description": "Share ID"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_delete_sheet_shareRemove a share from a sheet.
{
"type": "object",
"required": [
"sheetId",
"shareId"
],
"properties": {
"shareId": {
"type": "string",
"description": "Share ID to remove"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_remove_favoriteRemove an item from favorites.
{
"type": "object",
"required": [
"type",
"objectId"
],
"properties": {
"type": {
"enum": [
"sheet",
"folder",
"report",
"template",
"workspace",
"sight"
],
"type": "string",
"description": "Type of item"
},
"objectId": {
"type": "number",
"description": "ID of the item to remove from favorites"
}
}
}smartsheet_delete_report_shareRemove a share from a report.
{
"type": "object",
"required": [
"reportId",
"shareId"
],
"properties": {
"shareId": {
"type": "string",
"description": "Share ID to remove"
},
"reportId": {
"type": "number",
"description": "Report ID"
}
}
}smartsheet_get_homeGet the home folder contents.
{
"type": "object",
"properties": {}
}smartsheet_list_contactsList all contacts for the current user.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_contactGet a contact by ID.
{
"type": "object",
"required": [
"contactId"
],
"properties": {
"contactId": {
"type": "string",
"description": "Contact ID"
}
}
}smartsheet_test_connectionTest the connection to Smartsheet API.
{
"type": "object",
"properties": {}
}smartsheet_share_sheetShare a sheet with users or groups.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"sheetId": {
"type": "number",
"minimum": 1,
"description": "Sheet ID"
},
"sendEmail": {
"type": "boolean",
"description": "Send notification email"
}
}
}smartsheet_add_favoritesAdd multiple items to favorites.
{
"type": "object",
"required": [
"favorites",
"objectId"
],
"properties": {
"objectId": {
"type": "number",
"description": "ID of the item"
},
"favorites": {
"type": "array",
"items": {
"type": "number"
},
"description": "Type of item"
}
}
}smartsheet_list_sheet_attachmentsList all attachments on a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_list_row_attachmentsList all attachments on a row.
{
"type": "object",
"required": [
"sheetId",
"rowId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"rowId": {
"type": "number",
"description": "Row ID"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_attachmentGet attachment details and download URL.
{
"type": "object",
"required": [
"sheetId",
"attachmentId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"attachmentId": {
"type": "number",
"description": "Attachment ID"
}
}
}smartsheet_attach_url_to_sheetAttach a URL to a sheet.
{
"type": "object",
"required": [
"sheetId",
"name",
"url",
"attachmentType"
],
"properties": {
"url": {
"type": "string",
"description": "URL to attach"
},
"name": {
"type": "string",
"description": "Attachment name"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"description": {
"type": "string",
"description": "Attachment description"
},
"attachmentType": {
"enum": [
"LINK",
"BOX_COM",
"DROPBOX",
"EGNYTE",
"EVERNOTE",
"GOOGLE_DRIVE",
"ONEDRIVE"
],
"type": "string",
"description": "Type of URL attachment"
}
}
}smartsheet_attach_url_to_rowAttach a URL to a row.
{
"type": "object",
"required": [
"sheetId",
"rowId",
"name",
"url",
"attachmentType"
],
"properties": {
"url": {
"type": "string",
"description": "URL to attach"
},
"name": {
"type": "string",
"description": "Attachment name"
},
"rowId": {
"type": "number",
"description": "Row ID"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"description": {
"type": "string",
"description": "Attachment description"
},
"attachmentType": {
"enum": [
"LINK",
"BOX_COM",
"DROPBOX",
"EGNYTE",
"EVERNOTE",
"GOOGLE_DRIVE",
"ONEDRIVE"
],
"type": "string",
"description": "Type of URL attachment"
}
}
}smartsheet_attach_url_to_commentAttach a URL to a comment.
{
"type": "object",
"required": [
"sheetId",
"commentId",
"name",
"url",
"attachmentType"
],
"properties": {
"url": {
"type": "string",
"description": "URL to attach"
},
"name": {
"type": "string",
"description": "Attachment name"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"commentId": {
"type": "number",
"description": "Comment ID"
},
"description": {
"type": "string",
"description": "Attachment description"
},
"attachmentType": {
"enum": [
"LINK",
"BOX_COM",
"DROPBOX",
"EGNYTE",
"EVERNOTE",
"GOOGLE_DRIVE",
"ONEDRIVE"
],
"type": "string",
"description": "Type of URL attachment"
}
}
}smartsheet_delete_attachmentDelete an attachment from a sheet.
{
"type": "object",
"required": [
"sheetId",
"attachmentId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"attachmentId": {
"type": "number",
"description": "Attachment ID to delete"
}
}
}smartsheet_list_discussion_attachmentsList all attachments in a discussion.
{
"type": "object",
"required": [
"sheetId",
"discussionId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
},
"discussionId": {
"type": "number",
"description": "Discussion ID"
}
}
}smartsheet_list_columnsList all columns in a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_columnGet details of a specific column.
{
"type": "object",
"required": [
"sheetId",
"columnId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"columnId": {
"type": "number",
"description": "Column ID"
}
}
}smartsheet_add_columnAdd a new column to a sheet.
{
"type": "object",
"required": [
"sheetId",
"title"
],
"properties": {
"index": {
"type": "number",
"description": "Column position (0-indexed)"
},
"title": {
"type": "string",
"description": "Column title"
},
"width": {
"type": "number",
"description": "Column width in pixels"
},
"hidden": {
"type": "boolean",
"description": "Hide the column"
},
"symbol": {
"type": "string",
"description": "Symbol type (for CHECKBOX columns)"
},
"formula": {
"type": "string",
"description": "Column formula"
},
"options": {
"type": "array",
"items": {
"type": "string"
},
"description": "Options for PICKLIST columns"
},
"primary": {
"type": "boolean",
"description": "Is primary column"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"validation": {
"type": "boolean",
"description": "Enable validation"
},
"description": {
"type": "string",
"description": "Column description"
}
}
}smartsheet_add_columnsAdd multiple columns to a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"sheetId": {
"type": "number",
"minimum": 1,
"description": "Sheet ID"
}
}
}smartsheet_update_columnUpdate an existing column.
{
"type": "object",
"required": [
"sheetId",
"columnId"
],
"properties": {
"index": {
"type": "number",
"description": "New column position"
},
"title": {
"type": "string",
"description": "New column title"
},
"width": {
"type": "number",
"description": "New column width"
},
"hidden": {
"type": "boolean",
"description": "Hide/show column"
},
"symbol": {
"type": "string",
"description": "New symbol type"
},
"formula": {
"type": "string",
"description": "New column formula"
},
"options": {
"type": "array",
"items": {
"type": "string"
},
"description": "New options for PICKLIST"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"columnId": {
"type": "number",
"description": "Column ID"
},
"validation": {
"type": "boolean",
"description": "Enable/disable validation"
},
"description": {
"type": "string",
"description": "New column description"
}
}
}smartsheet_delete_columnDelete a column from a sheet.
{
"type": "object",
"required": [
"sheetId",
"columnId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"columnId": {
"type": "number",
"description": "Column ID to delete"
}
}
}smartsheet_list_dashboardsList all dashboards accessible to the user.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_dashboardGet a dashboard by ID with its widgets.
{
"type": "object",
"required": [
"dashboardId"
],
"properties": {
"dashboardId": {
"type": "number",
"description": "Dashboard ID"
}
}
}smartsheet_copy_dashboardCopy a dashboard.
{
"type": "object",
"required": [
"dashboardId",
"newName"
],
"properties": {
"newName": {
"type": "string",
"description": "Name for the copied dashboard"
},
"dashboardId": {
"type": "number",
"description": "Dashboard ID to copy"
},
"destinationId": {
"type": "number",
"description": "Destination folder or workspace ID"
},
"destinationType": {
"enum": [
"folder",
"workspace",
"home"
],
"type": "string",
"description": "Type of destination"
}
}
}smartsheet_move_dashboardMove a dashboard to a new location.
{
"type": "object",
"required": [
"dashboardId",
"destinationId",
"destinationType"
],
"properties": {
"dashboardId": {
"type": "number",
"description": "Dashboard ID to move"
},
"destinationId": {
"type": "number",
"description": "Destination folder or workspace ID"
},
"destinationType": {
"enum": [
"folder",
"workspace",
"home"
],
"type": "string",
"description": "Type of destination"
}
}
}smartsheet_list_sheet_discussionsList all discussions on a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all discussions"
}
}
}smartsheet_list_row_discussionsList all discussions on a row.
{
"type": "object",
"required": [
"sheetId",
"rowId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"rowId": {
"type": "number",
"description": "Row ID"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all discussions"
}
}
}smartsheet_get_discussionGet a discussion by ID.
{
"type": "object",
"required": [
"sheetId",
"discussionId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"discussionId": {
"type": "number",
"description": "Discussion ID"
}
}
}smartsheet_create_sheet_discussionCreate a new discussion on a sheet.
{
"type": "object",
"required": [
"sheetId",
"comment"
],
"properties": {
"comment": {
"type": "string",
"description": "Initial comment text"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_create_row_discussionCreate a new discussion on a row.
{
"type": "object",
"required": [
"sheetId",
"rowId",
"comment"
],
"properties": {
"rowId": {
"type": "number",
"description": "Row ID"
},
"comment": {
"type": "string",
"description": "Initial comment text"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_delete_discussionDelete a discussion.
{
"type": "object",
"required": [
"sheetId",
"discussionId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"discussionId": {
"type": "number",
"description": "Discussion ID to delete"
}
}
}smartsheet_add_commentAdd a comment to a discussion.
{
"type": "object",
"required": [
"sheetId",
"discussionId",
"text"
],
"properties": {
"text": {
"type": "string",
"description": "Comment text"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"discussionId": {
"type": "number",
"description": "Discussion ID"
}
}
}smartsheet_get_commentGet a comment by ID.
{
"type": "object",
"required": [
"sheetId",
"commentId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"commentId": {
"type": "number",
"description": "Comment ID"
}
}
}smartsheet_update_commentUpdate a comment.
{
"type": "object",
"required": [
"sheetId",
"commentId",
"text"
],
"properties": {
"text": {
"type": "string",
"description": "New comment text"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"commentId": {
"type": "number",
"description": "Comment ID"
}
}
}smartsheet_delete_commentDelete a comment.
{
"type": "object",
"required": [
"sheetId",
"commentId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"commentId": {
"type": "number",
"description": "Comment ID to delete"
}
}
}smartsheet_list_foldersList folders in the user's home.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_list_workspace_foldersList folders in a workspace.
{
"type": "object",
"required": [
"workspaceId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID"
}
}
}smartsheet_list_folder_foldersList subfolders within a folder.
{
"type": "object",
"required": [
"folderId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"folderId": {
"type": "number",
"description": "Parent folder ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_folderGet details of a specific folder including its contents.
{
"type": "object",
"required": [
"folderId"
],
"properties": {
"folderId": {
"type": "number",
"description": "Folder ID"
}
}
}smartsheet_create_folder_in_workspaceCreate a new folder in a workspace.
{
"type": "object",
"required": [
"workspaceId",
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Folder name"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID"
}
}
}smartsheet_create_folder_in_folderCreate a new subfolder in an existing folder.
{
"type": "object",
"required": [
"folderId",
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Folder name"
},
"folderId": {
"type": "number",
"description": "Parent folder ID"
}
}
}smartsheet_create_folder_in_homeCreate a new folder in the user's home.
{
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Folder name"
}
}
}smartsheet_update_folderUpdate a folder's name.
{
"type": "object",
"required": [
"folderId",
"name"
],
"properties": {
"name": {
"type": "string",
"description": "New folder name"
},
"folderId": {
"type": "number",
"description": "Folder ID"
}
}
}smartsheet_delete_folderDelete a folder and all its contents.
{
"type": "object",
"required": [
"folderId"
],
"properties": {
"folderId": {
"type": "number",
"description": "Folder ID to delete"
}
}
}smartsheet_copy_folderCopy a folder to a new location.
{
"type": "object",
"required": [
"folderId",
"destinationId",
"destinationType"
],
"properties": {
"newName": {
"type": "string",
"description": "New name for the copied folder"
},
"folderId": {
"type": "number",
"description": "Folder ID to copy"
},
"destinationId": {
"type": "number",
"description": "Destination folder or workspace ID"
},
"destinationType": {
"enum": [
"folder",
"workspace",
"home"
],
"type": "string",
"description": "Type of destination"
}
}
}smartsheet_move_folderMove a folder to a new location.
{
"type": "object",
"required": [
"folderId",
"destinationId",
"destinationType"
],
"properties": {
"folderId": {
"type": "number",
"description": "Folder ID to move"
},
"destinationId": {
"type": "number",
"description": "Destination folder or workspace ID"
},
"destinationType": {
"enum": [
"folder",
"workspace",
"home"
],
"type": "string",
"description": "Type of destination"
}
}
}smartsheet_list_groupsList all groups in the organization.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_create_groupCreate a new group.
{
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Group name"
},
"description": {
"type": "string",
"description": "Group description"
}
}
}smartsheet_update_groupUpdate a group's name or description.
{
"type": "object",
"required": [
"groupId"
],
"properties": {
"name": {
"type": "string",
"description": "New group name"
},
"groupId": {
"type": "number",
"description": "Group ID"
},
"ownerId": {
"type": "number",
"description": "New owner user ID"
},
"description": {
"type": "string",
"description": "New group description"
}
}
}smartsheet_delete_groupDelete a group.
{
"type": "object",
"required": [
"groupId"
],
"properties": {
"groupId": {
"type": "number",
"description": "Group ID to delete"
}
}
}smartsheet_add_group_membersAdd members to a group.
{
"type": "object",
"required": [
"groupId"
],
"properties": {
"groupId": {
"type": "number",
"minimum": 1,
"description": "Group ID"
}
}
}smartsheet_remove_group_memberRemove a member from a group.
{
"type": "object",
"required": [
"groupId",
"userId"
],
"properties": {
"userId": {
"type": "number",
"description": "User ID to remove"
},
"groupId": {
"type": "number",
"description": "Group ID"
}
}
}smartsheet_list_public_templatesList all public templates available.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_list_user_templatesList templates created by the current user.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_list_favoritesList all favorites for the current user.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_add_favoriteAdd an item to favorites.
{
"type": "object",
"required": [
"type",
"objectId"
],
"properties": {
"type": {
"enum": [
"sheet",
"folder",
"report",
"template",
"workspace",
"sight"
],
"type": "string",
"description": "Type of item to favorite"
},
"objectId": {
"type": "number",
"description": "ID of the item to favorite"
}
}
}smartsheet_list_cross_sheet_referencesList all cross-sheet references for a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_cross_sheet_referenceGet a cross-sheet reference by ID.
{
"type": "object",
"required": [
"sheetId",
"crossSheetReferenceId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"crossSheetReferenceId": {
"type": "number",
"description": "Cross-sheet reference ID"
}
}
}smartsheet_create_cross_sheet_referenceCreate a cross-sheet reference.
{
"type": "object",
"required": [
"sheetId",
"name",
"sourceSheetId"
],
"properties": {
"name": {
"type": "string",
"description": "Name for the cross-sheet reference"
},
"sheetId": {
"type": "number",
"description": "Sheet ID where the reference will be used"
},
"endRowId": {
"type": "number",
"description": "End row ID"
},
"startRowId": {
"type": "number",
"description": "Start row ID"
},
"endColumnId": {
"type": "number",
"description": "End column ID"
},
"sourceSheetId": {
"type": "number",
"description": "ID of the source sheet"
},
"startColumnId": {
"type": "number",
"description": "Start column ID"
}
}
}smartsheet_list_automation_rulesList all automation rules for a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_automation_ruleGet an automation rule by ID.
{
"type": "object",
"required": [
"sheetId",
"automationRuleId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"automationRuleId": {
"type": "number",
"description": "Automation rule ID"
}
}
}smartsheet_update_automation_ruleUpdate an automation rule.
{
"type": "object",
"required": [
"sheetId",
"automationRuleId",
"enabled"
],
"properties": {
"enabled": {
"type": "boolean",
"description": "Enable or disable the rule"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"automationRuleId": {
"type": "number",
"description": "Automation rule ID"
}
}
}smartsheet_delete_automation_ruleDelete an automation rule.
{
"type": "object",
"required": [
"sheetId",
"automationRuleId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"automationRuleId": {
"type": "number",
"description": "Automation rule ID to delete"
}
}
}smartsheet_list_update_requestsList all update requests for a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_update_requestGet an update request by ID.
{
"type": "object",
"required": [
"sheetId",
"updateRequestId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"updateRequestId": {
"type": "number",
"description": "Update request ID"
}
}
}smartsheet_create_update_requestCreate an update request to request row updates from users.
{
"type": "object",
"required": [
"sheetId",
"rowIds"
],
"properties": {
"ccMe": {
"type": "boolean",
"description": "CC the sender"
},
"rowIds": {
"type": "array",
"items": {
"type": "number"
},
"description": "Row IDs to request updates for"
},
"message": {
"type": "string",
"description": "Email message"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"subject": {
"type": "string",
"description": "Email subject"
},
"columnIds": {
"type": "array",
"items": {
"type": "number"
},
"description": "Column IDs to include in the request"
},
"includeAttachments": {
"type": "boolean",
"description": "Include attachments"
},
"includeDiscussions": {
"type": "boolean",
"description": "Include discussions"
}
}
}smartsheet_delete_update_requestDelete an update request.
{
"type": "object",
"required": [
"sheetId",
"updateRequestId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"updateRequestId": {
"type": "number",
"description": "Update request ID to delete"
}
}
}smartsheet_list_sent_update_requestsList all sent update requests for a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_sent_update_requestGet a sent update request by ID.
{
"type": "object",
"required": [
"sheetId",
"sentUpdateRequestId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"sentUpdateRequestId": {
"type": "number",
"description": "Sent update request ID"
}
}
}smartsheet_delete_sent_update_requestDelete a sent update request.
{
"type": "object",
"required": [
"sheetId",
"sentUpdateRequestId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"sentUpdateRequestId": {
"type": "number",
"description": "Sent update request ID to delete"
}
}
}smartsheet_list_eventsList events (audit log) for the organization.
{
"type": "object",
"properties": {
"since": {
"type": "string",
"description": "ISO 8601 timestamp to get events since"
},
"maxCount": {
"type": "number",
"description": "Maximum number of events to return"
},
"numericDates": {
"type": "boolean",
"description": "Return dates as milliseconds since epoch"
},
"streamPosition": {
"type": "string",
"description": "Stream position for pagination"
}
}
}smartsheet_get_server_infoGet Smartsheet server information including supported features.
{
"type": "object",
"properties": {}
}smartsheet_list_reportsList all reports accessible to the user.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_reportGet a report by ID with its data.
{
"type": "object",
"required": [
"reportId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"level": {
"type": "number",
"description": "Level of detail (0-3)"
},
"include": {
"type": "array",
"items": {
"type": "string"
},
"description": "Elements to include: attachments, discussions, format, sourceSheets"
},
"pageSize": {
"type": "number",
"description": "Number of rows per page"
},
"reportId": {
"type": "number",
"description": "Report ID"
}
}
}smartsheet_get_report_publish_statusGet the publish status of a report.
{
"type": "object",
"required": [
"reportId"
],
"properties": {
"reportId": {
"type": "number",
"description": "Report ID"
}
}
}smartsheet_set_report_publish_statusSet the publish status of a report.
{
"type": "object",
"required": [
"reportId",
"readOnlyFullEnabled"
],
"properties": {
"reportId": {
"type": "number",
"description": "Report ID"
},
"readOnlyFullEnabled": {
"type": "boolean",
"description": "Enable read-only full view"
},
"readOnlyFullAccessibleBy": {
"enum": [
"ALL",
"ORG"
],
"type": "string",
"description": "Who can access: ALL (anyone with link) or ORG (organization members)"
}
}
}smartsheet_get_rowGet a single row from a sheet.
Args:
{
"type": "object",
"required": [
"sheetId",
"rowId"
],
"properties": {
"rowId": {
"type": "number",
"description": "Row ID"
},
"exclude": {
"type": "array",
"items": {
"type": "string"
},
"description": "Elements to exclude"
},
"include": {
"type": "array",
"items": {
"type": "string"
},
"description": "Elements to include"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_add_rowsAdd one or more rows to a sheet.
Each row can specify cell values and positioning (toTop, toBottom, parentId, siblingId). Maximum 500 rows per request.
{
"type": "object",
"required": [
"sheetId",
"rows"
],
"properties": {
"rows": {
"type": "array",
"items": {
"type": "string"
},
"description": "Rows to add"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_update_rowsUpdate one or more rows in a sheet.
Each row must include its ID and the cells/properties to update. Maximum 500 rows per request.
{
"type": "object",
"required": [
"sheetId",
"rows"
],
"properties": {
"rows": {
"type": "array",
"items": {
"type": "string"
},
"description": "Rows to update"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_delete_rowsDelete one or more rows from a sheet.
Maximum ~300 rows per request due to URL length limits.
{
"type": "object",
"required": [
"sheetId",
"rowIds"
],
"properties": {
"rowIds": {
"type": "array",
"items": {
"type": "number"
},
"description": "Row IDs to delete"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"ignoreRowsNotFound": {
"type": "boolean",
"description": "Ignore errors for non-existent rows"
}
}
}smartsheet_copy_rows_to_sheetCopy rows from one sheet to another.
The destination sheet must have compatible columns.
{
"type": "object",
"required": [
"sheetId",
"rowIds",
"destinationSheetId"
],
"properties": {
"rowIds": {
"type": "array",
"items": {
"type": "number"
},
"description": "Row IDs to copy"
},
"sheetId": {
"type": "number",
"description": "Source sheet ID"
},
"destinationSheetId": {
"type": "number",
"description": "Destination sheet ID"
}
}
}smartsheet_move_rows_to_sheetMove rows from one sheet to another.
The destination sheet must have compatible columns. Rows will be removed from the source sheet.
{
"type": "object",
"required": [
"sheetId",
"rowIds",
"destinationSheetId"
],
"properties": {
"rowIds": {
"type": "array",
"items": {
"type": "number"
},
"description": "Row IDs to move"
},
"sheetId": {
"type": "number",
"description": "Source sheet ID"
},
"destinationSheetId": {
"type": "number",
"description": "Destination sheet ID"
}
}
}smartsheet_get_cell_historyGet the modification history of a specific cell.
{
"type": "object",
"required": [
"sheetId",
"rowId",
"columnId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"rowId": {
"type": "number",
"description": "Row ID"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"columnId": {
"type": "number",
"description": "Column ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
}
}
}smartsheet_searchSearch across all sheets, reports, dashboards, and folders.
{
"type": "object",
"required": [
"query"
],
"properties": {
"query": {
"type": "string",
"description": "Search query"
},
"scopes": {
"type": "array",
"items": {
"type": "string"
},
"description": "Scopes to search within"
},
"include": {
"type": "array",
"items": {
"type": "string"
},
"description": "Additional information to include"
},
"modifiedSince": {
"type": "string",
"description": "ISO 8601 date to filter by modification time"
}
}
}smartsheet_search_sheetSearch within a specific sheet.
{
"type": "object",
"required": [
"sheetId",
"query"
],
"properties": {
"query": {
"type": "string",
"description": "Search query"
},
"sheetId": {
"type": "number",
"description": "Sheet ID to search"
}
}
}smartsheet_list_sheet_sharesList all shares for a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_sheet_shareGet a specific share for a sheet.
{
"type": "object",
"required": [
"sheetId",
"shareId"
],
"properties": {
"shareId": {
"type": "string",
"description": "Share ID"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_list_workspace_sharesList all shares for a workspace.
{
"type": "object",
"required": [
"workspaceId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID"
}
}
}smartsheet_share_workspaceShare a workspace with users or groups.
{
"type": "object",
"required": [
"workspaceId"
],
"properties": {
"sendEmail": {
"type": "boolean",
"description": "Send notification email"
},
"workspaceId": {
"type": "number",
"minimum": 1,
"description": "Workspace ID"
}
}
}smartsheet_update_workspace_shareUpdate a workspace share's access level.
{
"type": "object",
"required": [
"workspaceId",
"shareId"
],
"properties": {
"shareId": {
"type": "string",
"description": "Share ID"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID"
}
}
}smartsheet_delete_workspace_shareRemove a share from a workspace.
{
"type": "object",
"required": [
"workspaceId",
"shareId"
],
"properties": {
"shareId": {
"type": "string",
"description": "Share ID to remove"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID"
}
}
}smartsheet_list_report_sharesList all shares for a report.
{
"type": "object",
"required": [
"reportId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"reportId": {
"type": "number",
"description": "Report ID"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_share_reportShare a report with users or groups.
{
"type": "object",
"required": [
"reportId"
],
"properties": {
"reportId": {
"type": "number",
"minimum": 1,
"description": "Report ID"
},
"sendEmail": {
"type": "boolean",
"description": "Send notification email"
}
}
}smartsheet_list_sheetsList all sheets accessible to the user.
Returns a paginated list of sheets with their IDs, names, and access levels.
{
"type": "object",
"properties": {
"page": {
"type": "integer",
"minimum": 1,
"description": "Page number (1-indexed)"
},
"pageSize": {
"type": "integer",
"maximum": 500,
"minimum": 1,
"description": "Number of sheets per page (default: 100)"
},
"includeAll": {
"type": "boolean",
"description": "Include all results (ignore pagination)"
}
}
}smartsheet_get_sheetGet a sheet by ID with all its data including columns and rows.
Args:
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"rowIds": {
"type": "array",
"items": {
"type": "number"
},
"description": "Specific row IDs to include"
},
"exclude": {
"type": "array",
"items": {
"type": "string"
},
"description": "Elements to exclude"
},
"include": {
"type": "array",
"items": {
"type": "string"
},
"description": "Elements to include: attachments, discussions, format, filterDefinitions, objectValue, ownerInfo, rowPermalink, rowWriterInfo, source, summary, writerInfo"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"pageSize": {
"type": "number",
"description": "Number of rows per page"
},
"columnIds": {
"type": "array",
"items": {
"type": "number"
},
"description": "Specific column IDs to include"
}
}
}smartsheet_create_sheetCreate a new sheet in the user's Sheets folder.
Args:
{
"type": "object",
"required": [
"name",
"columns"
],
"properties": {
"name": {
"type": "string",
"description": "Sheet name"
},
"columns": {
"type": "array",
"items": {
"type": "string"
},
"description": "Column definitions (first should be primary)"
}
}
}smartsheet_create_sheet_in_folderCreate a new sheet in a specific folder.
{
"type": "object",
"required": [
"folderId",
"name",
"columns"
],
"properties": {
"name": {
"type": "string",
"description": "Sheet name"
},
"columns": {
"type": "array",
"items": {
"type": "string"
},
"description": "Column definitions"
},
"folderId": {
"type": "number",
"description": "Folder ID"
}
}
}smartsheet_create_sheet_in_workspaceCreate a new sheet in a specific workspace.
{
"type": "object",
"required": [
"workspaceId",
"name",
"columns"
],
"properties": {
"name": {
"type": "string",
"description": "Sheet name"
},
"columns": {
"type": "array",
"items": {
"type": "string"
},
"description": "Column definitions"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID"
}
}
}smartsheet_create_sheet_from_templateCreate a new sheet from an existing template.
{
"type": "object",
"required": [
"name",
"fromId"
],
"properties": {
"name": {
"type": "string",
"description": "New sheet name"
},
"fromId": {
"type": "number",
"description": "Template ID to create from"
},
"includes": {
"type": "array",
"items": {
"type": "string"
},
"description": "Elements to include: data, attachments, discussions, cellLinks, forms"
}
}
}smartsheet_update_sheetUpdate a sheet's name.
{
"type": "object",
"required": [
"sheetId",
"name"
],
"properties": {
"name": {
"type": "string",
"description": "New sheet name"
},
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_delete_sheetDelete a sheet permanently.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID to delete"
}
}
}smartsheet_copy_sheetCopy a sheet to a new location.
{
"type": "object",
"required": [
"sheetId",
"destinationId",
"destinationType"
],
"properties": {
"newName": {
"type": "string",
"description": "New name for the copied sheet"
},
"sheetId": {
"type": "number",
"description": "Sheet ID to copy"
},
"destinationId": {
"type": "number",
"description": "Destination folder or workspace ID"
},
"destinationType": {
"enum": [
"folder",
"workspace",
"home"
],
"type": "string",
"description": "Type of destination"
}
}
}smartsheet_move_sheetMove a sheet to a new location.
{
"type": "object",
"required": [
"sheetId",
"destinationId",
"destinationType"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID to move"
},
"destinationId": {
"type": "number",
"description": "Destination folder or workspace ID"
},
"destinationType": {
"enum": [
"folder",
"workspace",
"home"
],
"type": "string",
"description": "Type of destination"
}
}
}smartsheet_get_sheet_publish_statusGet the publish status of a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
}
}
}smartsheet_set_sheet_publish_statusSet the publish status of a sheet.
{
"type": "object",
"required": [
"sheetId"
],
"properties": {
"sheetId": {
"type": "number",
"description": "Sheet ID"
},
"icalEnabled": {
"type": "boolean",
"description": "Enable iCal feed"
},
"readWriteEnabled": {
"type": "boolean",
"description": "Enable read-write view"
},
"readOnlyFullEnabled": {
"type": "boolean",
"description": "Enable read-only full view"
},
"readOnlyLiteEnabled": {
"type": "boolean",
"description": "Enable read-only lite view"
}
}
}smartsheet_get_current_userGet the current user's profile information.
{
"type": "object",
"properties": {}
}smartsheet_list_usersList all users in the organization (requires admin privileges).
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"email": {
"type": "string",
"description": "Filter by email address"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_userGet a user by ID (requires admin privileges).
{
"type": "object",
"required": [
"userId"
],
"properties": {
"userId": {
"type": "number",
"description": "User ID"
}
}
}smartsheet_add_userAdd a new user to the organization (requires admin privileges).
{
"type": "object",
"required": [
"email"
],
"properties": {
"admin": {
"type": "boolean",
"description": "Grant admin privileges"
},
"email": {
"type": "string",
"description": "User email address"
},
"lastName": {
"type": "string",
"description": "Last name"
},
"firstName": {
"type": "string",
"description": "First name"
},
"groupAdmin": {
"type": "boolean",
"description": "Grant group admin privileges"
},
"resourceViewer": {
"type": "boolean",
"description": "Grant resource viewer access"
},
"licensedSheetCreator": {
"type": "boolean",
"description": "Grant sheet creator license"
}
}
}smartsheet_update_userUpdate a user's information (requires admin privileges).
{
"type": "object",
"required": [
"userId"
],
"properties": {
"admin": {
"type": "boolean",
"description": "Admin privileges"
},
"userId": {
"type": "number",
"description": "User ID"
},
"lastName": {
"type": "string",
"description": "Last name"
},
"firstName": {
"type": "string",
"description": "First name"
},
"groupAdmin": {
"type": "boolean",
"description": "Group admin privileges"
},
"resourceViewer": {
"type": "boolean",
"description": "Resource viewer access"
},
"licensedSheetCreator": {
"type": "boolean",
"description": "Sheet creator license"
}
}
}smartsheet_remove_userRemove a user from the organization (requires admin privileges).
{
"type": "object",
"required": [
"userId"
],
"properties": {
"userId": {
"type": "number",
"description": "User ID to remove"
},
"transferTo": {
"type": "number",
"description": "User ID to transfer sheets to"
},
"transferSheets": {
"type": "boolean",
"description": "Transfer sheets to another user"
},
"removeFromSharing": {
"type": "boolean",
"description": "Remove from all shared items"
}
}
}smartsheet_list_alternate_emailsList alternate email addresses for a user.
{
"type": "object",
"required": [
"userId"
],
"properties": {
"userId": {
"type": "number",
"description": "User ID"
}
}
}smartsheet_add_alternate_emailAdd an alternate email address for a user.
{
"type": "object",
"required": [
"userId",
"email"
],
"properties": {
"email": {
"type": "string",
"description": "Alternate email address"
},
"userId": {
"type": "number",
"description": "User ID"
}
}
}smartsheet_delete_alternate_emailDelete an alternate email address for a user.
{
"type": "object",
"required": [
"userId",
"alternateEmailId"
],
"properties": {
"userId": {
"type": "number",
"description": "User ID"
},
"alternateEmailId": {
"type": "number",
"description": "Alternate email ID"
}
}
}smartsheet_make_alternate_email_primaryMake an alternate email address the primary email for a user.
{
"type": "object",
"required": [
"userId",
"alternateEmailId"
],
"properties": {
"userId": {
"type": "number",
"description": "User ID"
},
"alternateEmailId": {
"type": "number",
"description": "Alternate email ID to make primary"
}
}
}smartsheet_list_webhooksList all webhooks for the user.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_webhookGet a webhook by ID.
{
"type": "object",
"required": [
"webhookId"
],
"properties": {
"webhookId": {
"type": "number",
"description": "Webhook ID"
}
}
}smartsheet_create_webhookCreate a new webhook for a sheet.
{
"type": "object",
"required": [
"name",
"callbackUrl",
"scope",
"scopeObjectId",
"events"
],
"properties": {
"name": {
"type": "string",
"description": "Webhook name"
},
"scope": {
"enum": [
"sheet"
],
"type": "string",
"description": "Webhook scope (currently only sheet is supported)"
},
"events": {
"type": "array",
"items": {
"type": "string"
},
"description": "Events to subscribe to (e.g., *.*, row.created, cell.updated)"
},
"version": {
"type": "number",
"description": "Webhook version (1 for legacy, 2 for current)"
},
"callbackUrl": {
"type": "string",
"description": "URL to receive webhook callbacks"
},
"scopeObjectId": {
"type": "number",
"description": "ID of the sheet to monitor"
}
}
}smartsheet_update_webhookUpdate a webhook.
{
"type": "object",
"required": [
"webhookId"
],
"properties": {
"events": {
"type": "array",
"items": {
"type": "string"
},
"description": "Events to subscribe to"
},
"enabled": {
"type": "boolean",
"description": "Enable or disable the webhook"
},
"webhookId": {
"type": "number",
"description": "Webhook ID"
}
}
}smartsheet_delete_webhookDelete a webhook.
{
"type": "object",
"required": [
"webhookId"
],
"properties": {
"webhookId": {
"type": "number",
"description": "Webhook ID to delete"
}
}
}smartsheet_reset_webhook_shared_secretReset the shared secret for a webhook.
{
"type": "object",
"required": [
"webhookId"
],
"properties": {
"webhookId": {
"type": "number",
"description": "Webhook ID"
}
}
}smartsheet_list_workspacesList all workspaces accessible to the user.
{
"type": "object",
"properties": {
"page": {
"type": "number",
"description": "Page number"
},
"pageSize": {
"type": "number",
"description": "Number of results per page"
},
"includeAll": {
"type": "boolean",
"description": "Include all results"
}
}
}smartsheet_get_workspaceGet details of a specific workspace including its contents.
{
"type": "object",
"required": [
"workspaceId"
],
"properties": {
"loadAll": {
"type": "boolean",
"description": "Load all nested contents"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID"
}
}
}smartsheet_create_workspaceCreate a new workspace.
{
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Workspace name"
}
}
}smartsheet_update_workspaceUpdate a workspace's name.
{
"type": "object",
"required": [
"workspaceId",
"name"
],
"properties": {
"name": {
"type": "string",
"description": "New workspace name"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID"
}
}
}smartsheet_delete_workspaceDelete a workspace and all its contents.
{
"type": "object",
"required": [
"workspaceId"
],
"properties": {
"workspaceId": {
"type": "number",
"description": "Workspace ID to delete"
}
}
}smartsheet_copy_workspaceCopy a workspace.
{
"type": "object",
"required": [
"workspaceId",
"newName"
],
"properties": {
"newName": {
"type": "string",
"description": "Name for the copied workspace"
},
"workspaceId": {
"type": "number",
"description": "Workspace ID to copy"
},
"destinationId": {
"type": "number",
"description": "Destination folder or workspace ID"
},
"destinationType": {
"enum": [
"folder",
"workspace",
"home"
],
"type": "string",
"description": "Type of destination"
}
}
}