Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Overview
This node integrates with the Smartsheet API to manage sheets and folders. Specifically, for the Manage Smartsheet resource and the Add New Column operation, it allows users to add a new column to an existing Smartsheet sheet. This is useful when you want to extend your sheet structure dynamically by adding columns with specific data types and configurations.
Common scenarios include:
- Expanding a project management sheet by adding new fields such as dates, checkboxes, or contact lists.
- Automating sheet schema updates in workflows where new data categories are introduced.
- Customizing sheets on-the-fly based on incoming data or user input.
Example: Adding a "Due Date" column of type DATE to a project tracking sheet to track task deadlines.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select the target sheet by name or specify its ID where the new column will be added. The list is dynamically loaded from your Smartsheet account. |
| Title | The title (name) of the new column to be created in the sheet. |
| Type | The data type of the new column. Options include: - ABSTRACT DATETIME - CHECK BOX - CONTACT LIST - DATE - DATETIME - DURATION - MULTI CONTACT LIST - MULTI PICKLIST - PICKLIST - PREDECESSOR - TEXT NUMBER |
| Additional Fields | Optional extra settings for the new column: - Description: Text description of the column. - Format: Formatting string for the column. - Formula: A formula to calculate values. - Hidden: Whether the column is hidden. - Index: Position index of the column. - Validation: Enable validation rules. |
Output
The output JSON contains the response from the Smartsheet API after creating the new column. It includes details about the newly created column such as its ID, title, type, and any additional properties set.
No binary data is output by this operation.
Dependencies
- Requires a valid Smartsheet API authentication token configured in n8n credentials.
- The node uses the Smartsheet REST API v2 endpoint
https://api.smartsheet.com/2.0. - The user must have appropriate permissions to modify the target sheet.
Troubleshooting
- Error: No rows specified — This error can occur if required row IDs or data are missing when performing row-related operations (not directly related to adding columns but common in this node). Ensure all required inputs are provided.
- Column titled "X" not found — When updating or finding columns, ensure the column title matches exactly and exists in the sheet.
- API Authentication Errors — Verify that the API key credential is correctly set up and has sufficient permissions.
- Invalid Column Type or Parameters — Make sure the column type and additional fields conform to Smartsheet API specifications.
- Index Out of Range — If specifying the column index, ensure it is within the valid range of existing columns.
If errors occur, enabling detailed logging in n8n can help identify the exact API request and response.