Smartsheet icon

Smartsheet

Consume Smartsheet API
Join our community

Actions10

Overview

The "Update a sheet" operation for the "Sheets" resource in this custom n8n node allows you to update the name of an existing Smartsheet sheet. This is useful when you need to programmatically rename sheets as part of your workflow automation, such as after processing data or to reflect a new status.

Common scenarios:

  • Renaming a sheet after importing or transforming its data.
  • Updating sheet names to match project phases or milestones.
  • Automating naming conventions across multiple sheets.

Practical example:
You have a workflow that processes sales data and, upon completion, renames the relevant Smartsheet sheet to include the current month (e.g., "Sales Data - June 2024").

Properties

Name Meaning
Sheet ID of the sheet to update. You must select from available sheets in your Smartsheet account.
Sheet Name The new name for the sheet. Enter the desired name as a string (e.g., "Call Tracker").
Validation (Only shown for columns of type PICKLIST) Whether to enable validation for picklist values. Not relevant for updating a sheet name.

Output

The output will be a JSON object representing the updated sheet. Typical fields may include:

{
  "id": "123456789",
  "name": "New Sheet Name",
  "permalink": "https://app.smartsheet.com/sheets/...",
  // ...other sheet metadata fields
}
  • The structure includes at least the sheet's id and the new name.
  • 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 selected sheet does not exist or has been deleted, the operation will fail. Ensure the "Sheet" property references a valid, existing sheet.
  • Insufficient Permissions: If your Smartsheet API key does not have permission to edit the sheet, you will receive an authorization error. Make sure your API user has the necessary rights.
  • Name Conflicts: Attempting to rename a sheet to a name already used by another sheet may result in an error, depending on Smartsheet's rules.

Error messages and resolutions:

  • "Sheet not found": Double-check the selected sheet in the "Sheet" property.
  • "Access denied": Verify your API credentials and permissions.
  • "Invalid request": Ensure all required properties are filled and the new name is valid.

Links and References

Discussion