Actions10
Overview
This node interacts with the Smartsheet API to fetch information about a specific column within a sheet. It is useful in scenarios where you need to retrieve metadata or configuration details for a particular column, such as its title, type, or validation settings. For example, you might use this node to dynamically adapt workflows based on column properties, validate data before insertion, or generate reports about sheet structure.
Practical Example:
Suppose you have an automation that processes rows in a Smartsheet and needs to know if a certain column enforces picklist validation. You can use this node to fetch the column's details and adjust your workflow accordingly.
Properties
| Name | Meaning |
|---|---|
| Sheet | ID of the sheet. Select from available sheets. This property is required to specify which sheet contains the column you want to fetch. |
| Column | ID of the column. Select from columns available in the chosen sheet. This property is required to specify which column to fetch. |
| Validation | Indicates whether picklist validation is enabled for the column. Only shown for columns of type "PICKLIST". Options: true (enabled), false (disabled). |
Output
The output is a JSON object containing the details of the fetched column. The structure typically includes:
{
"id": "COLUMN_ID",
"title": "Column Name",
"type": "COLUMN_TYPE",
"validation": true,
// ...other column properties as provided by the Smartsheet API
}
id: The unique identifier of the column.title: The name of the column.type: The data type of the column (e.g., TEXT_NUMBER, PICKLIST).validation: Boolean indicating if picklist validation is enabled (for PICKLIST columns).- Additional fields may be present depending on the column's configuration in Smartsheet.
Dependencies
- External Service: Requires access to the Smartsheet API.
- API Key: You must configure n8n with valid Smartsheet API credentials (
smartsheetApi). - n8n Configuration: No additional environment variables are required beyond standard credential setup.
Troubleshooting
Common Issues:
- Invalid Sheet or Column Selection: If the selected sheet or column does not exist or is inaccessible, the node will fail.
- Missing Credentials: If Smartsheet API credentials are not configured, the node cannot authenticate requests.
- Insufficient Permissions: The API key used must have permission to view the specified sheet and column.
Error Messages and Resolutions:
"Request failed with status code 404": The specified sheet or column was not found. Double-check the IDs."Authentication failed": Ensure your Smartsheet API credentials are correctly set up in n8n."You do not have access to this resource": Verify that your API user has the necessary permissions for the target sheet and column.