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.
Server path: /smartsheet | Type: Application | PCID required: Yes
| Tool | Description |
|---|
smartsheet_list_sheets | List all sheets accessible to the user |
smartsheet_get_sheet | Get a specific sheet by ID |
smartsheet_create_sheet | Create a new sheet |
smartsheet_add_rows | Add rows to a sheet |
smartsheet_update_rows | Update existing rows in a sheet |
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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"includeAll": {
"type": "boolean",
"default": false,
"description": "Include additional sheet information"
}
},
"required": [
"PCID"
]
}
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 |
{
"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_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 |
{
"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_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 |
{
"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_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 |
{
"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"
]
}
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 |
{
"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"
]
}
