Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API
Join our community

Actions13

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 change the name of an existing sheet by specifying its ID and the new desired name.

Common scenarios where this node is beneficial include:

  • Automating organizational workflows by renaming sheets based on project phases or statuses.
  • Standardizing sheet names across teams or departments.
  • Integrating with other systems that require dynamic sheet naming.

For example, after completing a data import process, you might rename the sheet from "Import in Progress" to "Completed Import - April 2024" automatically.

Properties

Name Meaning
Sheet Name or ID Select a sheet from the dropdown list or specify its ID via expression. This identifies 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. It typically includes the updated sheet object reflecting the new name and other sheet metadata.

No binary data 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 PUT /sheets/{sheetId} to perform the rename action.
  • Proper permissions on the Smartsheet account are necessary to rename sheets.

Troubleshooting

  • Error: No sheet specified or invalid sheet ID
    Ensure that the "Sheet Name or ID" property is correctly set and corresponds to an existing sheet accessible by the API credentials.

  • Error: Insufficient permissions
    The API key used must have permission to edit the target sheet. Verify the API key's access rights in Smartsheet.

  • API rate limits or network issues
    If requests fail intermittently, check for network connectivity and Smartsheet API rate limits.

  • Invalid new name
    The new sheet name should comply with Smartsheet naming rules (e.g., length limits, no forbidden characters).

If the node throws an error message containing details from the Smartsheet API, review the message to adjust inputs accordingly.

Links and References

Discussion