Actions10
Overview
This node allows you to interact with the Smartsheet API, specifically to delete a sheet from your Smartsheet account. The "Delete a sheet" operation is useful when you need to automate the removal of outdated or unnecessary sheets as part of a workflow. For example, you might use this node in an n8n automation that cleans up temporary project sheets after a project is completed.
Properties
| Name | Meaning |
|---|---|
| Sheet | ID of the sheet to be deleted. You must select which sheet you want to remove. |
| Validation | (Only shown for PICKLIST type columns) A boolean option related to validation. Not relevant for deleting a sheet and will not appear for this operation. |
Output
- The output will be a JSON object summarizing the result of the delete operation. Typically, it may include confirmation of deletion or details about the deleted sheet.
- No binary data is produced by this operation.
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 ID: If the provided Sheet ID does not exist or has already been deleted, the operation will fail.
- Authentication Errors: If the Smartsheet API credentials are missing or incorrect, authentication errors will occur.
- Permission Denied: If your Smartsheet account does not have permission to delete the specified sheet, the operation will fail.
Error Messages and Resolutions:
"Sheet not found": Ensure the correct Sheet ID is selected."Unauthorized": Check your Smartsheet API credentials in n8n."Insufficient permissions": Verify your user role in Smartsheet allows sheet deletion.