Actions10
Overview
This node allows you to delete a column from a specified sheet in Smartsheet. It is useful for automating the management of your Smartsheet documents, especially when you need to programmatically remove columns as part of a workflow (e.g., cleaning up data structures, removing obsolete fields, or preparing sheets for export).
Example scenarios:
- Automatically deleting temporary or unused columns after data processing.
- Streamlining sheets by removing columns based on user input or business logic.
- Integrating with other systems that require specific sheet formats.
Properties
| Name | Meaning |
|---|---|
| Sheet | ID of the sheet containing the column you want to delete. You must select an existing sheet. |
| Column | ID of the column to be deleted. The list of columns is dynamically loaded based on the selected sheet. |
Output
The output will be a JSON object summarizing the result of the column deletion operation. Typically, this includes confirmation of the deletion and may include metadata such as the column ID or status message.
Example output:
[
{
"message": "Column deleted successfully",
"columnID": "1234567890"
}
]
Note: The actual structure may vary depending on the Smartsheet API response.
Dependencies
- External Service: Requires access to the Smartsheet API.
- API Key: You must configure Smartsheet API credentials in n8n under the name
smartsheetApi.
Troubleshooting
Common Issues:
- Invalid Sheet or Column ID: If the provided Sheet or Column does not exist, the node will fail. Ensure you select valid options from the dropdowns.
- Insufficient Permissions: The API key used must have permission to modify the target sheet and delete columns.
- Network/API Errors: Connectivity issues or Smartsheet API downtime can cause failures.
Error Messages:
"Sheet not found"or"Column not found": Double-check the selected Sheet and Column."Access denied": Verify your API credentials and permissions."Request failed with status code 4xx/5xx": Indicates an issue with the request or server; check details in the error message.