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.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes |