Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Overview
This node interacts with the Smartsheet API to manage sheets and folders within a Smartsheet account. Specifically, the "Rename Sheet" operation allows users to rename an existing sheet by specifying its ID and the new desired name. This is useful in scenarios where you want to programmatically update sheet names to reflect changes in project status, naming conventions, or organizational standards.
Practical example:
You have a project management sheet named "Q1 Planning" that needs to be renamed to "Q1 2024 Planning" after the start of the new year. Using this node's Rename Sheet operation, you can automate this renaming process without manually opening Smartsheet.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | Select a sheet from the dropdown list or specify a sheet ID via expression to identify which sheet to rename. |
| Name | The new name to assign to the selected sheet. |
Output
The output JSON contains the response from the Smartsheet API after renaming the sheet. Typically, it includes the updated sheet object reflecting the new name and other sheet metadata. The exact structure depends on the Smartsheet API response but generally confirms the successful rename operation.
No binary data output is produced by this operation.
Dependencies
- Requires an active connection to the Smartsheet API using an API key credential configured in n8n.
- The node uses the Smartsheet REST API endpoint
https://api.smartsheet.com/2.0/sheets/{sheetId}with HTTP PUT method to rename the sheet. - Proper permissions on the Smartsheet account are necessary to rename sheets.
Troubleshooting
Common issues:
- Providing an invalid or non-existent sheet ID will cause the API call to fail.
- Insufficient permissions on the Smartsheet account to rename sheets.
- Network connectivity issues preventing access to the Smartsheet API.
Error messages:
"No rows specified"— Not relevant for rename but seen in other operations; ensure required fields are provided.- API errors returned by Smartsheet (e.g., 404 Not Found if sheet ID does not exist, 403 Forbidden if permission denied).
Resolution tips:
- Verify the sheet ID is correct and accessible.
- Confirm the API key has sufficient privileges.
- Check network connectivity and API endpoint availability.
- Use expressions carefully when specifying sheet IDs to avoid invalid values.