Smartsheet

Manage Smartsheet sheets, columns, rows, and sharing with an API token.

Add column

Add a column to an existing Smartsheet sheet.

Parameters

Parameter	Type	Required	Description
`sheet_id`	number	Yes	Smartsheet sheet ID.
`title`	string	Yes	Column title.
`type`	string	Yes	Column type (TEXT_NUMBER, DATE, etc.).
`primary`	boolean	No	Whether the column is primary.

Response

{
  "message": "SUCCESS",
  "result": [
    {
      "id": 444555666,
      "title": "Status"
    }
  ],
  "resultCode": 0
}

Add rows

Add rows to a Smartsheet sheet.

Parameters

Parameter	Type	Required	Description
`sheet_id`	number	Yes	Smartsheet sheet ID.
`rows`	array	Yes	Rows to add with cell values.

Response

{
  "message": "SUCCESS",
  "result": [
    {
      "cells": [],
      "id": 111222333
    }
  ],
  "resultCode": 0
}

Create sheet

Create a new Smartsheet sheet with columns.

Parameters

Parameter	Type	Required	Description
`name`	string	Yes	Sheet name.
`columns`	array	Yes	List of column definitions with title and type.

Response

{
  "message": "SUCCESS",
  "result": {
    "id": 987654321,
    "name": "New Sheet"
  },
  "resultCode": 0
}

Get sheet details

Retrieve full details of a specific Smartsheet sheet.

Parameters

Parameter	Type	Required	Description
`sheet_id`	number	Yes	Smartsheet sheet ID.

Response

{
  "columns": [],
  "id": 123456789,
  "name": "Project Plan",
  "rows": []
}

List sheets

Retrieve all sheets accessible to the connected Smartsheet account.

Response

[
  {
    "accessLevel": "ADMIN",
    "id": 123456789,
    "name": "Project Plan"
  }
]

Share a Smartsheet sheet with a collaborator.

Parameters

Parameter	Type	Required	Description
`sheet_id`	number	Yes	Smartsheet sheet ID.
`email`	string	Yes	Email address to share with.
`access_level`	string	Yes	Access level (VIEWER, EDITOR, ADMIN).

Response

{
  "message": "SUCCESS",
  "result": [
    {
      "accessLevel": "EDITOR",
      "email": "user@example.com",
      "id": "share_123"
    }
  ],
  "resultCode": 0
}

Update row cells

Update cell values in a specific row.

Parameters

Parameter	Type	Required	Description
`sheet_id`	number	Yes	Smartsheet sheet ID.
`row_id`	number	Yes	Row ID to update.
`cells`	array	Yes	List of cell updates.

Response

{
  "message": "SUCCESS",
  "result": [
    {
      "cells": [],
      "id": 111222333
    }
  ],
  "resultCode": 0
}

Smartsheet

On this page