> **Building with AI coding agents?** Install the authstack plugin with one command. This equips your agent with accurate Scalekit implementation patterns.
>
> **Recommended** (the `-y` flags skip prompts, so the command runs without an interactive terminal):
> ```bash
> npx -y @scalekit-inc/cli setup -y
> ```
>
> Global:
> ```bash
> npm install -g @scalekit-inc/cli
> scalekit setup -y
> ```
>
> Supports Claude Code, Cursor, GitHub Copilot, Codex + skills for other Agent Skills-compatible agents in `~/.agents/skills`.
> Skills: integrate-agentkit, implement-saaskit, add-mcp-oauth, implement-sso, implement-scim.
> [Full setup guide](https://docs.scalekit.com/dev-kit/build-with-ai/)

---

# Connect AI agents to Smartsheet

The Smartsheet connector lets your AI agent act in each user's Smartsheet account. Each user signs in to Smartsheet once, and Scalekit stores and refreshes their tokens, so your agent never handles credentials. It comes with 27 tools.

**Authentication:** OAuth 2.0
**Categories:** Project Management, Productivity
**Tools:** 27: 18 read, 8 write, 1 destructive
**Users sign in with:** OAuth
**OAuth app:** Your own Smartsheet app
**Built by:** Scalekit connector
**Try it:** [Playground in the Scalekit dashboard](https://app.scalekit.com/ws/signup?sk_intent=playground&provider=SMARTSHEET)

## Setup

1. ### Install the SDK

   **Node.js**

   ```bash
   npm install @scalekit-sdk/node dotenv
   ```

   **Python**

   ```bash
   pip install scalekit-sdk-python python-dotenv
   ```

2. ### Set your credentials

   Add your Scalekit credentials to your `.env` file. Find values in **[app.scalekit.com](https://app.scalekit.com)** > **Developers** > **API Credentials**.

   ```sh title=".env"
   SCALEKIT_ENVIRONMENT_URL=<your-environment-url>
   SCALEKIT_CLIENT_ID=<your-client-id>
   SCALEKIT_CLIENT_SECRET=<your-client-secret>
   ```

3. ### Create the Smartsheet connection

   In **AgentKit > Connections**, create a Smartsheet connection and copy its redirect URI. The name you give it is the `connection_name` your code passes. See [Configure connections](/agentkit/connections/).

4. ### Register an OAuth app

   Smartsheet connections use your own OAuth app. Register one with Smartsheet and add the redirect URI you copied.

   Then enter the app's Client ID and Client Secret on the Smartsheet connection.

5. ### Authorize a user and make your first call

   **Node.js** (`quickstart.mts`)

   ```typescript
   import { ScalekitClient } from '@scalekit-sdk/node'
   import 'dotenv/config'
   import { createInterface } from 'node:readline/promises'

   const scalekit = new ScalekitClient(
     process.env.SCALEKIT_ENVIRONMENT_URL,
     process.env.SCALEKIT_CLIENT_ID,
     process.env.SCALEKIT_CLIENT_SECRET,
   )
   const actions = scalekit.actions

   const connector = 'smartsheet'
   const identifier = 'user_123'

   // Generate an authorization link for the user
   const { link } = await actions.getAuthorizationLink({ connectionName: connector, identifier })
   console.log('Authorize Smartsheet:', link)
   const rl = createInterface({ input: process.stdin, output: process.stdout })
   await rl.question('Press Enter after authorizing...')
   rl.close()

   // Make your first call
   const result = await actions.executeTool({
     connector,
     identifier,
     toolName: 'smartsheet_current_user_get',
     toolInput: {},
   })
   console.log(result)
   ```

   ```bash
   npx tsx quickstart.mts
   ```

   **Python** (`quickstart.py`)

   ```python
   import os
   from scalekit import ScalekitClient
   from dotenv import load_dotenv
   load_dotenv()

   scalekit_client = ScalekitClient(
       env_url=os.getenv("SCALEKIT_ENVIRONMENT_URL"),
       client_id=os.getenv("SCALEKIT_CLIENT_ID"),
       client_secret=os.getenv("SCALEKIT_CLIENT_SECRET"),
   )
   actions = scalekit_client.actions

   connection_name = "smartsheet"
   identifier = "user_123"

   # Generate an authorization link for the user
   link_response = actions.get_authorization_link(
       connection_name=connection_name,
       identifier=identifier,
   )
   print("Authorize Smartsheet:", link_response.link)
   input("Press Enter after authorizing...")

   # Make your first call
   result = actions.execute_tool(
       tool_input={},
       tool_name="smartsheet_current_user_get",
       connection_name=connection_name,
       identifier=identifier,
   )
   print(result)
   ```

   ```bash
   python quickstart.py
   ```

   Each user signs in once. See [Authorize a user](/agentkit/tools/authorize/) for the full flow and statuses.

## Tools

Pass the exact name to `execute_tool`, with an input like each tool's example. To ask for a tool that's missing, use the [request form](https://scalekitsupport.portal.usepylon.com/forms/request-a-connector-tool).

**Node.js**

```typescript
const result = await actions.executeTool({
  toolName: 'smartsheet_attachments_list',
  toolInput: {
    sheet_id: '4583173393803140',
  },
  connector: 'smartsheet',
  identifier: 'user_123',
})
```

**Python**

```python
result = actions.execute_tool(
    tool_name="smartsheet_attachments_list",
    tool_input={
        "sheet_id": "4583173393803140",
    },
    connection_name="smartsheet",
    identifier="user_123",
)
```

`result.data` is the app's response as JSON, and `result.execution_id` (`executionId` in Node.js) is the ID of the call.

### `smartsheet_attachments_list`

List Attachments · Read-only

List all attachments on a sheet, including those on its rows and in its discussions.
Returns each attachment's id, name, attachmentType (FILE, LINK, GOOGLE_DRIVE, and others), mimeType, sizeInKb, parentType, parentId, and createdAt. File contents are not returned.
Use smartsheet_attachments_list to see what files and links a sheet holds.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `include_all` (`boolean`, optional): Set to true to return every item in one response instead of paging. Defaults to false. Example: true.
- `page` (`integer`, optional): Page number to return, starting at 1. Defaults to 1. A page past the end returns the last page. Ignored when include_all is true. Example: 2.
- `page_size` (`integer`, optional): Maximum number of items per page. Defaults to 100. Ignored when include_all is true. Example: 50.

Example input: `{"sheet_id":"4583173393803140"}`

### `smartsheet_columns_list`

List Columns · Read-only

List the columns of a sheet.
Returns each column's id, index, title, type, primary flag, and options (for picklist columns).
Use smartsheet_columns_list to get the column ids that smartsheet_rows_add and smartsheet_rows_update need. Use smartsheet_sheet_get to read columns together with row data.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `include_all` (`boolean`, optional): Set to true to return every item in one response instead of paging. Defaults to false. Example: true.
- `level` (`integer`, optional): Format for multi-contact and multi-picklist cells. 0 (default) returns them as plain text; 1 returns multi-contact cells as objects; 2 also returns multi-picklist cells as objects. Combine with include=objectValue to get contact email addresses. Example: 2. One of: `0`, `1`, `2`.
- `page` (`integer`, optional): Page number to return, starting at 1. Defaults to 1. A page past the end returns the last page. Ignored when include_all is true. Example: 2.
- `page_size` (`integer`, optional): Maximum number of items per page. Defaults to 100. Ignored when include_all is true. Example: 50.

Example input: `{"sheet_id":"4583173393803140"}`

### `smartsheet_current_user_get`

Get Current User · Read-only

Get the profile of the Smartsheet user who authorized this connection.
Returns the user's id, email, first and last name, locale, time zone, account details, and admin flags, plus their groups when requested.
Use it to learn who the connection acts as, for example before sharing an asset or filtering by owner.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `include` (`string`, optional): Set to groups to also return the groups (id, name, description) the user belongs to. Leave empty for the profile only. Example: "groups". One of: `groups`.

Example input: `{}`

### `smartsheet_discussion_get`

Get Discussion · Read-only

Get one discussion on a sheet with all its comments.
Returns the discussion's id, title, parentId, parentType, and comments (id, text, createdBy, createdAt).
Use smartsheet_discussion_get to read a full thread. Use smartsheet_comment_create to reply to it.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `discussion_id` (`string`, required): ID of the discussion, as returned in the id field by smartsheet_discussions_list. Example: "3962273862576004".
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".

Example input: `{"discussion_id":"3962273862576004","sheet_id":"4583173393803140"}`

### `smartsheet_discussions_list`

List Discussions · Read-only

List the discussions (comment threads) on a sheet, including those on its rows.
Returns each discussion's id, title, parentId, parentType (SHEET or ROW), commentCount, and lastCommentedAt, plus the comments when requested.
Use smartsheet_discussions_list to browse conversations on a sheet. Use smartsheet_discussion_get to read one thread in full.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `include` (`string`, optional): Comma-separated extra data: comments (every comment in each thread) and attachments (comment attachments; only works together with comments). Example: "comments".
- `include_all` (`boolean`, optional): Set to true to return every item in one response instead of paging. Defaults to false. Example: true.
- `page` (`integer`, optional): Page number to return, starting at 1. Defaults to 1. A page past the end returns the last page. Ignored when include_all is true. Example: 2.
- `page_size` (`integer`, optional): Maximum number of items per page. Defaults to 100. Ignored when include_all is true. Example: 50.

Example input: `{"sheet_id":"4583173393803140"}`

### `smartsheet_folder_children_list`

List Folder Contents · Read-only

List the sheets, reports, dashboards, sub-folders, and templates directly inside a folder.
Returns each child's id, name, resourceType, and permalink, plus lastKey when more pages exist. Items inside sub-folders are not included.
Use smartsheet_folder_children_list to browse a folder. Use smartsheet_workspace_children_list for the top level of a workspace.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `folder_id` (`string`, required): ID of the folder, as a numeric string. Get it from smartsheet_workspace_children_list or smartsheet_folder_children_list. Example: "5709073300645764".
- `children_resource_types` (`string`, optional): Comma-separated child types to return. Allowed: sheets, reports, sights (dashboards), folders, templates. If you include templates, also include sheets. Leave empty for all types. Example: "sheets,folders".
- `include` (`string`, optional): Comma-separated extra data for each child: source (what it was created from) and ownerInfo (the owner's user). Example: "ownerInfo".
- `last_key` (`string`, optional): Paging token. Pass the lastKey value from the previous response to get the next page; leave empty for the first page. Example: "MTIzNDU2Nzg5".
- `max_items` (`integer`, optional): Maximum number of items to return. The minimum and default is 100, the maximum is 1000. Example: 200.

Example input: `{"folder_id":"5709073300645764"}`

### `smartsheet_folder_get`

Get Folder · Read-only

Get the details of one folder, without its contents.
Returns the folder's id, name, permalink, createdAt, and modifiedAt.
Use smartsheet_folder_get for folder details. Use smartsheet_folder_children_list for the sheets, reports, and sub-folders inside it.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `folder_id` (`string`, required): ID of the folder, as a numeric string. Get it from smartsheet_workspace_children_list or smartsheet_folder_children_list. Example: "5709073300645764".
- `include` (`string`, optional): Set to source to add the object the folder was created from, if any. Example: "source". One of: `source`.

Example input: `{"folder_id":"5709073300645764"}`

### `smartsheet_items_search`

Search Everything · Read-only

Search all sheets, reports, dashboards, workspaces, folders, and templates the user can access for a text.
Returns matching results with objectType, objectId, parentObjectId, text, contextData, and the total count.
Use smartsheet_items_search to find content across the account. Use smartsheet_sheet_search to search inside one sheet and smartsheet_sheets_list to browse sheets by name.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `query` (`string`, required): Text to search for. Wrap it in double quotes to match the exact phrase. Example: "launch plan".
- `include` (`string`, optional): Set to favoriteFlag to mark which results the user has added to Favorites. Example: "favoriteFlag". One of: `favoriteFlag`.
- `modified_since` (`string`, optional): Only return items modified on or after this time, as an ISO 8601 date-time in UTC. Example: "2026-01-01T00:00:00Z".
- `scopes` (`string`, optional): Comma-separated places to search. Allowed: attachments, cellData, comments, folderNames, reportNames, sheetNames, sightNames, summaryFields, templateNames, workspaceNames. Leave empty to search everywhere. Example: "sheetNames,cellData".

Example input: `{"query":"launch plan"}`

### `smartsheet_report_get`

Get Report · Read-only

Get one report with its columns and rows gathered from its source sheets.
Returns the report's id, name, permalink, columns (virtualId, title, type), rows with cells and the sheetId each row comes from, and totalRowCount.
Use smartsheet_report_get to read report data. Use smartsheet_reports_list to find the report id first.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `report_id` (`string`, required): ID of the report, as a numeric string. Get it from smartsheet_reports_list. Example: "4583173393803140".
- `exclude` (`string`, optional): Comma-separated data to leave out. Allowed: linkInFromCellDetails, linksOutToCellsDetails. Example: "linkInFromCellDetails".
- `include` (`string`, optional): Comma-separated extra data to return. Allowed: attachments, discussions, proofs, format, objectValue, scope, source, sourceSheets. Example: "sourceSheets".
- `level` (`integer`, optional): Format for multi-contact and multi-picklist cells. 0 (default) returns them as plain text; 1 returns multi-contact cells as objects; 2 also returns multi-picklist cells as objects. Combine with include=objectValue to get contact email addresses. Example: 2. One of: `0`, `1`, `2`.
- `page` (`integer`, optional): Page of rows to return, starting at 1. Defaults to 1. Example: 2.
- `page_size` (`integer`, optional): Maximum number of rows per page. Defaults to 100; the maximum is 10,000. Example: 500.

Example input: `{"report_id":"4583173393803140"}`

### `smartsheet_reports_list`

List Reports · Read-only

List the reports the user can access.
Returns each report's id, name, accessLevel, permalink, createdAt, and modifiedAt.
Use smartsheet_reports_list to find a report id. Use smartsheet_report_get to read a report's rows.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `modified_since` (`string`, optional): Only return reports modified on or after this time, as an ISO 8601 date-time in UTC. Example: "2026-01-01T00:00:00Z".

Example input: `{}`

### `smartsheet_row_get`

Get Row · Read-only

Get one row of a sheet by its id.
Returns the row's id, rowNumber, parentId, createdAt, modifiedAt, and cells (columnId, value, displayValue), plus columns, discussions, or attachments when requested.
Use smartsheet_row_get when you already have a row id. Use smartsheet_sheet_get to read many rows and smartsheet_sheet_search to find rows by text.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `row_id` (`string`, required): ID of the row, as a numeric string. Get it from the rows array returned by smartsheet_sheet_get or smartsheet_sheet_search. Example: "2361756178769796".
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `exclude` (`string`, optional): Comma-separated data to leave out. Allowed: filteredOutRows, linkInFromCellDetails, linksOutToCellsDetails, nonexistentCells (empty cells). Example: "nonexistentCells".
- `include` (`string`, optional): Comma-separated extra data to return with the row. Allowed: attachments, columns, columnType, discussions, filters, format, objectValue, proofs, rowPermalink, writerInfo. Use columns to get the column titles that match each cell's columnId. Example: "columns,discussions".
- `level` (`integer`, optional): Format for multi-contact and multi-picklist cells. 0 (default) returns them as plain text; 1 returns multi-contact cells as objects; 2 also returns multi-picklist cells as objects. Combine with include=objectValue to get contact email addresses. Example: 2. One of: `0`, `1`, `2`.

Example input: `{"row_id":"2361756178769796","sheet_id":"4583173393803140"}`

### `smartsheet_shares_list`

List Shares · Read-only

List the users and groups an asset is shared with, and their access level.
Returns each share's id, type (USER or GROUP), userId or groupId, email, name, accessLevel, and scope, plus lastKey when more pages exist.
Use smartsheet_shares_list to see who can access a sheet, report, dashboard, or workspace. Use smartsheet_share_create to share it with someone new.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `asset_id` (`string`, required): ID of the asset, matching asset_type. For a sheet use the id from smartsheet_sheets_list, for a workspace the id from smartsheet_workspaces_list. Example: "4583173393803140".
- `asset_type` (`string`, required): Type of the asset: sheet, report, sight (dashboard), workspace, collection, or file. Example: "sheet". One of: `sheet`, `report`, `sight`, `workspace`, `collection`, `file`.
- `last_key` (`string`, optional): Paging token. Pass the lastKey value from the previous response to get the next page; leave empty for the first page. Example: "MTIzNDU2Nzg5".
- `max_items` (`integer`, optional): Maximum number of shares to return. The minimum and default is 100, the maximum is 1000. Example: 200.
- `sharing_include` (`string`, optional): Which shares to return: ITEM for shares made directly on the asset, or WORKSPACE for shares it inherits from its workspace. Leave empty for the default. Example: "ITEM". One of: `ITEM`, `WORKSPACE`.

Example input: `{"asset_id":"4583173393803140","asset_type":"sheet"}`

### `smartsheet_sheet_get`

Get Sheet · Read-only

Get one sheet with its columns and rows, optionally narrowed to some rows or columns.
Returns the sheet's id, name, permalink, columns (id, title, type), and rows with their cells (columnId, value, displayValue), plus totalRowCount.
Use smartsheet_sheet_get to read sheet data. Use smartsheet_row_get for a single row, smartsheet_columns_list for column ids only, and smartsheet_sheet_search to find rows by text.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `column_ids` (`string`, optional): Comma-separated column ids. When set, only these columns and their cells are returned. Get column ids from smartsheet_columns_list. Example: "7960873114331012,642523719853956".
- `exclude` (`string`, optional): Comma-separated data to leave out. Allowed: filteredOutRows, linkInFromCellDetails, linksOutToCellsDetails, nonexistentCells (empty cells). Example: "nonexistentCells".
- `filter_id` (`string`, optional): ID of a saved sheet filter to apply. Rows the filter hides are marked filteredOut: true. Example: "6362915432441732".
- `include` (`string`, optional): Comma-separated extra data to return. Allowed: attachments, columnType, crossSheetReferences, discussions, filters, filterDefinitions, format, ganttConfig, objectValue, ownerInfo, proofs, rowPermalink, source, writerInfo. Example: "rowPermalink,writerInfo".
- `level` (`integer`, optional): Format for multi-contact and multi-picklist cells. 0 (default) returns them as plain text; 1 returns multi-contact cells as objects; 2 also returns multi-picklist cells as objects. Combine with include=objectValue to get contact email addresses. Example: 2. One of: `0`, `1`, `2`.
- `page` (`integer`, optional): Page of rows to return, starting at 1. Defaults to 1. Example: 2.
- `page_size` (`integer`, optional): Maximum number of rows per page. Defaults to 100. Example: 500.
- `row_ids` (`string`, optional): Comma-separated row ids. When set, only these rows are returned. Example: "2361756178769796,6865355806140292".
- `row_numbers` (`string`, optional): Comma-separated row numbers (the 1-based position shown in Smartsheet). Row numbers that do not exist are ignored. Example: "1,2,10".
- `rows_modified_since` (`string`, optional): Only return rows modified on or after this time, as an ISO 8601 date-time in UTC. Example: "2026-01-01T00:00:00Z".

Example input: `{"sheet_id":"4583173393803140"}`

### `smartsheet_sheet_search`

Search Sheet · Read-only

Search the rows of one sheet for a text.
Returns matching results with objectType, objectId (the row id), parentObjectId (the sheet id), text, and contextData.
Use smartsheet_sheet_search to find rows in a known sheet. Use smartsheet_items_search to search across all sheets, then smartsheet_row_get to read a matching row.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `query` (`string`, required): Text to search for. Wrap it in double quotes to match the exact phrase. Example: "Acme Corp".
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".

Example input: `{"query":"Acme Corp","sheet_id":"4583173393803140"}`

### `smartsheet_sheets_list`

List Sheets · Read-only

List every sheet the user can access, across all workspaces and folders.
Returns sheet id, name, accessLevel, permalink, createdAt, and modifiedAt for each sheet, with page and total counts.
Use smartsheet_sheets_list to browse or find a sheet id by name. Use smartsheet_items_search for a text search inside sheets, and smartsheet_workspace_children_list to stay inside one workspace.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `include` (`string`, optional): Extra data to add to each sheet: sheetVersion (current version number; do not combine with paging) or source (the sheet or template it was created from). Example: "source". One of: `sheetVersion`, `source`.
- `include_all` (`boolean`, optional): Set to true to return every item in one response instead of paging. Defaults to false. Example: true.
- `modified_since` (`string`, optional): Only return sheets modified on or after this time, as an ISO 8601 date-time in UTC. Example: "2026-01-01T00:00:00Z".
- `page` (`integer`, optional): Page number to return, starting at 1. Defaults to 1. A page past the end returns the last page. Ignored when include_all is true. Example: 2.
- `page_size` (`integer`, optional): Maximum number of items per page. Defaults to 100. Ignored when include_all is true. Example: 50.

Example input: `{}`

### `smartsheet_workspace_children_list`

List Workspace Contents · Read-only

List the sheets, reports, dashboards, folders, and templates directly inside a workspace.
Returns each child's id, name, resourceType, and permalink, plus lastKey when more pages exist. Items inside sub-folders are not included.
Use smartsheet_workspace_children_list to browse a workspace. Use smartsheet_folder_children_list to go into a folder it returns.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `workspace_id` (`string`, required): ID of the workspace, as a numeric string. Get it from smartsheet_workspaces_list. Example: "7116448184199044".
- `children_resource_types` (`string`, optional): Comma-separated child types to return. Allowed: sheets, reports, sights (dashboards), folders, templates. If you include templates, also include sheets. Leave empty for all types. Example: "sheets,folders".
- `include` (`string`, optional): Comma-separated extra data for each child: source (what it was created from) and ownerInfo (the owner's user). Example: "ownerInfo".
- `last_key` (`string`, optional): Paging token. Pass the lastKey value from the previous response to get the next page; leave empty for the first page. Example: "MTIzNDU2Nzg5".
- `max_items` (`integer`, optional): Maximum number of items to return. The minimum and default is 100, the maximum is 1000. Example: 200.

Example input: `{"workspace_id":"7116448184199044"}`

### `smartsheet_workspace_get`

Get Workspace · Read-only

Get the details of one workspace, without its contents.
Returns the workspace's id, name, accessLevel, permalink, createdAt, and modifiedAt.
Use smartsheet_workspace_get for workspace details. Use smartsheet_workspace_children_list for the sheets, reports, and folders inside it.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `workspace_id` (`string`, required): ID of the workspace, as a numeric string. Get it from smartsheet_workspaces_list. Example: "7116448184199044".
- `include` (`string`, optional): Set to source to add the object the workspace was created from, if any. Example: "source". One of: `source`.

Example input: `{"workspace_id":"7116448184199044"}`

### `smartsheet_workspaces_list`

List Workspaces · Read-only

List the workspaces the user can access.
Returns workspace id, name, accessLevel, and permalink for each workspace, plus lastKey when more pages exist.
Use smartsheet_workspaces_list to find a workspace id. Use smartsheet_workspace_children_list to see what a workspace contains.

Read only: yes. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `last_key` (`string`, optional): Paging token. Pass the lastKey value from the previous response to get the next page; leave empty for the first page. Example: "MTIzNDU2Nzg5".
- `max_items` (`integer`, optional): Maximum number of workspaces to return. The minimum and default is 100, the maximum is 1000. Example: 200.

Example input: `{}`

### `smartsheet_columns_add`

Add Columns · Write

Add one or more columns to an existing sheet.
Returns the created columns with their new ids, index, title, and type.
Use smartsheet_columns_add to extend a sheet's structure. Use smartsheet_sheet_create to make a new sheet with columns.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `columns` (`array`, required): Columns to add. Each needs a title, a type (TEXT_NUMBER, DATE, DATETIME, CONTACT_LIST, MULTI_CONTACT_LIST, CHECKBOX, PICKLIST, MULTI_PICKLIST, DURATION, PREDECESSOR, or ABSTRACT_DATETIME), and an index, the zero-based position to insert at. All columns in one call must use the same index; they are inserted there in the order given. PICKLIST columns take their choices in options. Example: [{"title": "Owner", "type": "CONTACT_LIST", "index": 2}, {"title": "Priority", "type": "PICKLIST", "options": ["High", "Medium", "Low"], "index": 2}].
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".

Example input: `{"columns":[],"sheet_id":"4583173393803140"}`

### `smartsheet_comment_create`

Add Comment · Write

Add a comment to an existing discussion on a sheet or row.
Returns the new comment's id, text, createdBy, and createdAt.
Use smartsheet_comment_create to reply in a thread. Use smartsheet_discussion_create or smartsheet_row_discussion_create to start a new thread.
Get the discussion id from smartsheet_discussions_list first.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `discussion_id` (`string`, required): ID of the discussion, as returned in the id field by smartsheet_discussions_list. Example: "3962273862576004".
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `text` (`string`, required): Text of the comment. Example: "Done, moved to Friday.".

Example input: `{"discussion_id":"3962273862576004","sheet_id":"4583173393803140","text":"Done, moved to Friday."}`

### `smartsheet_discussion_create`

Create Sheet Discussion · Write

Start a new discussion on a sheet as a whole, with a first comment.
Returns the new discussion's id, title, and its first comment.
Use smartsheet_discussion_create for a sheet-level thread. Use smartsheet_row_discussion_create to comment on a specific row, and smartsheet_comment_create to reply in an existing thread.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `text` (`string`, required): Text of the first comment in the discussion. Example: "Budget numbers are updated for Q3.".

Example input: `{"sheet_id":"4583173393803140","text":"Budget numbers are updated for Q3."}`

### `smartsheet_row_discussion_create`

Create Row Discussion · Write

Start a new discussion on one row of a sheet, with a first comment.
Returns the new discussion's id, title, and its first comment.
Use smartsheet_row_discussion_create to comment on a specific row. Use smartsheet_discussion_create for a sheet-level thread and smartsheet_comment_create to reply in an existing thread.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `row_id` (`string`, required): ID of the row, as a numeric string. Get it from the rows array returned by smartsheet_sheet_get or smartsheet_sheet_search. Example: "2361756178769796".
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `text` (`string`, required): Text of the first comment in the discussion. Example: "Can we move this due date to Friday?".

Example input: `{"row_id":"2361756178769796","sheet_id":"4583173393803140","text":"Can we move this due date to Friday?"}`

### `smartsheet_rows_add`

Add Rows · Write

Add one or more rows to a sheet, with cell values and an optional position.
Returns the created rows with their new ids, rowNumber, and cells, plus a result code.
Use smartsheet_rows_add for new rows. Use smartsheet_rows_update to change existing rows.
Call smartsheet_columns_list first to get the column ids the cells refer to.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `rows` (`array`, required): Rows to add. Each row object takes a cells array; each cell names a column by its columnId (from smartsheet_columns_list) and gives a value, for example {"columnId": 7960873114331012, "value": "In progress"}. Use strict: false on a cell to let Smartsheet coerce the value, or formula instead of value to set a formula such as "=SUM([Cost]1:[Cost]5)". To choose where a row goes, add one location setting: toTop: true, toBottom: true (the default is the bottom), parentId to make it the first child of another row, or siblingId to place it right below another row. All rows in one call must use the same location setting. Example: [{"toBottom": true, "cells": [{"columnId": 7960873114331012, "value": "Write launch post"}, {"columnId": 642523719853956, "value": "Not started"}]}].
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `allow_partial_success` (`boolean`, optional): Set to true to add the valid rows even when some rows fail; the response lists the failed ones. Defaults to false (all or nothing). Example: true.
- `override_validation` (`boolean`, optional): Set to true to accept cell values outside a column's validation rules (the cell must also set strict: false). Defaults to false. Example: true.

Example input: `{"rows":[],"sheet_id":"4583173393803140"}`

### `smartsheet_rows_update`

Update Rows · Write

Update cell values, position, or expanded state of one or more existing rows in a sheet.
Returns the updated rows with their cells, plus a result code.
Use smartsheet_rows_update to change existing rows. Use smartsheet_rows_add for new rows and smartsheet_rows_delete to remove rows.
Get row ids from smartsheet_sheet_get and column ids from smartsheet_columns_list first.

Read only: no. Destructive: no. Idempotent (safe to retry): yes.

Inputs:

- `rows` (`array`, required): Rows to update. Each row object needs its id; only the cells you list change. Each row object takes a cells array; each cell names a column by its columnId (from smartsheet_columns_list) and gives a value, for example {"columnId": 7960873114331012, "value": "In progress"}. Use strict: false on a cell to let Smartsheet coerce the value, or formula instead of value to set a formula such as "=SUM([Cost]1:[Cost]5)". To move a row, add one location setting (toTop, toBottom, parentId, siblingId) or indent/outdent: 1. To clear a cell, set its value to an empty string. Example: [{"id": 2361756178769796, "cells": [{"columnId": 642523719853956, "value": "Done"}]}].
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `allow_partial_success` (`boolean`, optional): Set to true to apply the valid updates even when some rows fail; the response lists the failed ones. Defaults to false (all or nothing). Example: true.
- `override_validation` (`boolean`, optional): Set to true to accept cell values outside a column's validation rules (the cell must also set strict: false). Defaults to false. Example: true.

Example input: `{"rows":[],"sheet_id":"4583173393803140"}`

### `smartsheet_share_create`

Share Asset · Write

Share a sheet, report, dashboard, or workspace with one user (by email) or one group, at a given access level, optionally emailing them.
Returns the created share with its id, type, email or groupId, accessLevel, and scope.
Use smartsheet_share_create to give someone access. Use smartsheet_shares_list to check existing access first.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `access_level` (`string`, required): Access to grant: VIEWER, COMMENTER, EDITOR, EDITOR_SHARE (edit and share), ADMIN, or OWNER. Example: "EDITOR". One of: `VIEWER`, `COMMENTER`, `EDITOR`, `EDITOR_SHARE`, `ADMIN`, `OWNER`.
- `asset_id` (`string`, required): ID of the asset, matching asset_type. Example: "4583173393803140".
- `asset_type` (`string`, required): Type of the asset to share: sheet, report, sight (dashboard), workspace, collection, or file. Example: "sheet". One of: `sheet`, `report`, `sight`, `workspace`, `collection`, `file`.
- `cc_me` (`boolean`, optional): Set to true to send a copy of the notification email to the user who shares. Only used when send_email is true. Example: true.
- `email` (`string`, optional): Primary email address of the user to share with. Set either email or group_id, not both. Example: "jane.doe@example.com".
- `group_id` (`integer`, optional): ID of the group to share with. Set either email or group_id, not both. Example: 2331373580117892.
- `message` (`string`, optional): Body of the notification email. Only used when send_email is true. Example: "Please review the timeline by Friday.".
- `send_email` (`boolean`, optional): Set to true to email the recipient about the share. Defaults to false. subject, message, and cc_me only apply when this is true. Example: true.
- `subject` (`string`, optional): Subject of the notification email. Only used when send_email is true. Example: "Sharing the Q3 plan".

Example input: `{"access_level":"EDITOR","asset_id":"4583173393803140","asset_type":"sheet"}`

### `smartsheet_sheet_create`

Create Sheet · Write

Create a new sheet with the given columns in the user's Sheets folder.
Returns the new sheet's id, name, permalink, accessLevel, and its columns with their ids.
Use smartsheet_sheet_create to start a new sheet. Use smartsheet_columns_add to add columns to an existing sheet and smartsheet_rows_add to fill it.

Read only: no. Destructive: no. Idempotent (safe to retry): no.

Inputs:

- `columns` (`array`, required): Columns of the new sheet, in order. Each column needs a title and a type: TEXT_NUMBER, DATE, DATETIME, CONTACT_LIST, MULTI_CONTACT_LIST, CHECKBOX, PICKLIST, MULTI_PICKLIST, DURATION, PREDECESSOR, or ABSTRACT_DATETIME. Exactly one column must be the primary column (primary: true, type TEXT_NUMBER). PICKLIST columns take their choices in options; CHECKBOX columns can set a symbol such as FLAG or STAR. Example: [{"title": "Task", "type": "TEXT_NUMBER", "primary": true}, {"title": "Status", "type": "PICKLIST", "options": ["Not started", "In progress", "Done"]}, {"title": "Due", "type": "DATE"}].
- `name` (`string`, required): Name of the new sheet. Example: "Q3 Launch Plan".

Example input: `{"columns":[],"name":"Q3 Launch Plan"}`

### `smartsheet_rows_delete`

Delete Rows · Destructive

Permanently delete one or more rows from a sheet. Child rows of a deleted row are deleted too.
Returns the ids of the deleted rows and a result code.
Use smartsheet_rows_delete only to remove rows. Use smartsheet_rows_update to clear or change cell values instead.

Read only: no. Destructive: yes. Idempotent (safe to retry): yes.

Inputs:

- `ids` (`string`, required): Comma-separated ids of the rows to delete. Get them from smartsheet_sheet_get or smartsheet_sheet_search. Example: "2361756178769796,6865355806140292".
- `sheet_id` (`string`, required): ID of the sheet, as a numeric string. Get it from smartsheet_sheets_list, smartsheet_items_search, or a sheet URL's properties in Smartsheet. Example: "4583173393803140".
- `ignore_rows_not_found` (`boolean`, optional): Set to true to delete the rows that exist and skip ids that are not found. Defaults to false, which deletes nothing and returns an error when any id is not found. Example: true.

Example input: `{"ids":"2361756178769796,6865355806140292","sheet_id":"4583173393803140"}`

## Related

Other Project Management connectors ([all 67](/agentkit/connectors/?category=project-management)):

- [Notion](/agentkit/connectors/notion/): Scalekit connector, OAuth, 51 tools
- [Linear](/agentkit/connectors/linear/): Scalekit connector, OAuth, 64 tools
- [Airtable](/agentkit/connectors/airtable/): Scalekit connector, OAuth, 26 tools


---

## More Scalekit documentation

| Resource | What it contains | When to use it |
|----------|-----------------|----------------|
| [/llms.txt](/llms.txt) | Structured index with routing hints per product area | Start here — find which documentation set covers your topic before loading full content |
| [/llms-full.txt](/llms-full.txt) | Complete documentation for all Scalekit products in one file | Use when you need exhaustive context across multiple products or when the topic spans several areas |
| [sitemap-0.xml](https://docs.scalekit.com/sitemap-0.xml) | Full URL list of every documentation page | Use to discover specific page URLs you can fetch for targeted, page-level answers |
