Get Sheet Columns
smartsheet_get_columnsRetrieve column definitions from a Smartsheet sheet, including IDs, types, and dropdown options. Use these IDs to add or update rows.
Instructions
Retrieve all column definitions for a Smartsheet sheet. Returns column IDs, titles, types (TEXT_NUMBER, DATE, PICKLIST, CHECKBOX, CONTACT_LIST, etc.), options for dropdown columns, and whether each column is primary. Use this to get column IDs needed before adding or updating rows.
Args:
sheet_id (number): Target sheet ID
Returns: Array of column definitions with IDs, types, and options.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sheet_id": "<sheet_id>"
},
"name": "smartsheet_get_columns"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes |