> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# smartsheet

> Sheets, rows, and columns

**Server path:** `/smartsheet` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                  | Description                            |
| ----------------------------------------------------- | -------------------------------------- |
| [`smartsheet_list_sheets`](#smartsheet_list_sheets)   | List all sheets accessible to the user |
| [`smartsheet_get_sheet`](#smartsheet_get_sheet)       | Get a specific sheet by ID             |
| [`smartsheet_create_sheet`](#smartsheet_create_sheet) | Create a new sheet                     |
| [`smartsheet_add_rows`](#smartsheet_add_rows)         | Add rows to a sheet                    |
| [`smartsheet_update_rows`](#smartsheet_update_rows)   | Update existing rows in a sheet        |
| [`smartsheet_delete_rows`](#smartsheet_delete_rows)   | Delete rows from a sheet               |

***

## smartsheet\_list\_sheets

List all sheets accessible to the user

**Parameters:**

| Parameter    | Type    | Required | Default | Description                          |
| ------------ | ------- | -------- | ------- | ------------------------------------ |
| `includeAll` | boolean | No       | `false` | Include additional sheet information |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "includeAll": {
        "type": "boolean",
        "default": false,
        "description": "Include additional sheet information"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## smartsheet\_get\_sheet

Get a specific sheet by ID

**Parameters:**

| Parameter | Type      | Required | Default | Description                |
| --------- | --------- | -------- | ------- | -------------------------- |
| `sheetId` | string    | Yes      | —       | Sheet ID to retrieve       |
| `include` | string\[] | No       | —       | Additional data to include |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "sheetId": {
        "type": "string",
        "description": "Sheet ID to retrieve"
      },
      "include": {
        "type": "array",
        "items": {
          "type": "string",
          "enum": [
            "discussions",
            "attachments",
            "format",
            "filters"
          ]
        },
        "description": "Additional data to include"
      }
    },
    "required": [
      "PCID",
      "sheetId"
    ]
  }
  ```
</Expandable>

***

## smartsheet\_create\_sheet

Create a new sheet

**Parameters:**

| Parameter | Type      | Required | Default | Description                   |
| --------- | --------- | -------- | ------- | ----------------------------- |
| `name`    | string    | Yes      | —       | Sheet name                    |
| `columns` | object\[] | Yes      | —       | Initial columns for the sheet |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "name": {
        "type": "string",
        "description": "Sheet name"
      },
      "columns": {
        "type": "array",
        "items": {
          "type": "object",
          "properties": {
            "title": {
              "type": "string",
              "description": "Column title"
            },
            "type": {
              "type": "string",
              "enum": [
                "TEXT_NUMBER",
                "DATE",
                "DATETIME",
                "CONTACT_LIST",
                "CHECKBOX",
                "PICKLIST"
              ],
              "description": "Column type"
            },
            "primary": {
              "type": "boolean",
              "description": "Whether this is the primary column"
            }
          }
        },
        "description": "Initial columns for the sheet"
      }
    },
    "required": [
      "PCID",
      "name",
      "columns"
    ]
  }
  ```
</Expandable>

***

## smartsheet\_add\_rows

Add rows to a sheet

**Parameters:**

| Parameter | Type      | Required | Default | Description              |
| --------- | --------- | -------- | ------- | ------------------------ |
| `sheetId` | string    | Yes      | —       | Sheet ID                 |
| `rows`    | object\[] | Yes      | —       | Rows to add              |
| `toTop`   | boolean   | No       | `false` | Add rows to top of sheet |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "sheetId": {
        "type": "string",
        "description": "Sheet ID"
      },
      "rows": {
        "type": "array",
        "items": {
          "type": "object",
          "properties": {
            "cells": {
              "type": "array",
              "items": {
                "type": "object",
                "properties": {
                  "columnId": {
                    "type": "string",
                    "description": "Column ID"
                  },
                  "value": {
                    "type": "any",
                    "description": "Cell value"
                  }
                }
              },
              "description": "Row cells"
            }
          }
        },
        "description": "Rows to add"
      },
      "toTop": {
        "type": "boolean",
        "default": false,
        "description": "Add rows to top of sheet"
      }
    },
    "required": [
      "PCID",
      "sheetId",
      "rows"
    ]
  }
  ```
</Expandable>

***

## smartsheet\_update\_rows

Update existing rows in a sheet

**Parameters:**

| Parameter | Type      | Required | Default | Description    |
| --------- | --------- | -------- | ------- | -------------- |
| `sheetId` | string    | Yes      | —       | Sheet ID       |
| `rows`    | object\[] | Yes      | —       | Rows to update |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "sheetId": {
        "type": "string",
        "description": "Sheet ID"
      },
      "rows": {
        "type": "array",
        "items": {
          "type": "object",
          "properties": {
            "id": {
              "type": "string",
              "description": "Row ID"
            },
            "cells": {
              "type": "array",
              "items": {
                "type": "object",
                "properties": {
                  "columnId": {
                    "type": "string",
                    "description": "Column ID"
                  },
                  "value": {
                    "type": "any",
                    "description": "New cell value"
                  }
                }
              },
              "description": "Updated cells"
            }
          }
        },
        "description": "Rows to update"
      }
    },
    "required": [
      "PCID",
      "sheetId",
      "rows"
    ]
  }
  ```
</Expandable>

***

## smartsheet\_delete\_rows

Delete rows from a sheet

**Parameters:**

| Parameter | Type      | Required | Default | Description                |
| --------- | --------- | -------- | ------- | -------------------------- |
| `sheetId` | string    | Yes      | —       | Sheet ID                   |
| `rowIds`  | string\[] | Yes      | —       | Array of row IDs to delete |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "sheetId": {
        "type": "string",
        "description": "Sheet ID"
      },
      "rowIds": {
        "type": "array",
        "items": {
          "type": "string"
        },
        "description": "Array of row IDs to delete"
      }
    },
    "required": [
      "PCID",
      "sheetId",
      "rowIds"
    ]
  }
  ```
</Expandable>