Smartsheet icon

Smartsheet

Consume Smartsheet API
Join our community

Actions10

Overview

This node allows you to create a new column in a Smartsheet sheet. It is useful when you need to programmatically add columns of various types (such as text, date, picklist, etc.) to an existing sheet, for example, to automate the setup of new sheets or dynamically adjust sheet structure based on workflow requirements.

Practical examples:

  • Automatically adding a "Status" picklist column to all new project sheets.
  • Adding a "Due Date" column of type "Date" to track deadlines.
  • Creating custom columns for data import workflows.

Properties

Name Meaning
Sheet ID of the sheet where the new column will be created. You must select from your available sheets.
Type The type of the column to create. Options: Checkbox, Contact List, Date, Date & Time, Duration, Multi-Contact List, Picklist, Multi Picklist, Predecessor, Text/Number.
Options (JSON) Comma-separated list of values for the user to choose from. Used for columns that require predefined options, such as Picklist or Multi Picklist.
Validation Boolean value. If enabled and the column type is Picklist, validation will be applied to ensure only allowed values are used.

Output

The output is a JSON object representing the newly created column. Typical fields include:

  • id: The unique identifier of the new column.
  • title: The name/title of the column.
  • type: The type of the column (e.g., TEXT_NUMBER, PICKLIST).
  • options: (If applicable) The list of allowed values for picklist-type columns.
  • Other metadata as provided by the Smartsheet API.

Example output:

{
  "id": 123456789,
  "title": "Status",
  "type": "PICKLIST",
  "options": ["Not Started", "In Progress", "Complete"],
  "validation": true
}

Dependencies

  • Smartsheet API: Requires a valid Smartsheet account and API key.
  • n8n Credentials: You must configure the smartsheetApi credential in n8n with your API token.

Troubleshooting

  • Missing Required Fields: If you do not specify the required "Sheet" property, the node will throw an error.
  • Invalid Column Type: If you select an unsupported column type, the API may reject the request.
  • Options Format Error: For picklist columns, ensure the "Options (JSON)" field is correctly formatted as a comma-separated list or valid JSON array.
  • API Authentication Errors: If your API key is invalid or missing, you will receive authentication errors from the Smartsheet API.

Links and References

Discussion