smartsheet

Sheets, rows, and columns

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

Tools

Tool	Description
smartsheet_add_rows	Add rows to a sheet
smartsheet_create_sheet	Create a new sheet
smartsheet_delete_rows	Delete rows from a sheet
smartsheet_get_sheet	Get a specific sheet by ID
smartsheet_list_sheets	List all sheets accessible to the user
smartsheet_update_rows	Update existing rows in a sheet

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

smartsheet_list_sheets

List all sheets accessible to the user

Parameters:

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "includeAll": {
      "type": "boolean",
      "default": false,
      "description": "Include additional sheet information"
    }
  },
  "required": [
    "PCID"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}