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 integrates with the Smartsheet API to manage folders and sheets within a Smartsheet workspace. Specifically, the Manage Folder - Get Sheets List operation retrieves all sheets contained in a specified folder. This is useful when you want to programmatically list or process sheets grouped under a particular folder without manually navigating the Smartsheet UI.

Common scenarios include:

  • Automating workflows that need to fetch all sheets inside a project folder for reporting or data aggregation.
  • Dynamically populating dropdowns or selections in other automation steps based on available sheets in a folder.
  • Synchronizing or backing up sheet metadata from a specific folder.

Example: Given a folder ID, the node returns a JSON object containing the folder details and a dictionary mapping each sheet name to its sheet ID.

Properties

Name Meaning
Folder ID The unique identifier of the folder whose sheets you want to list.

Output

The output JSON contains two main parts:

  • folder: An object representing the folder's metadata (such as its ID, name, and other folder properties).
  • namedSheets: An object where each key is a sheet name and the corresponding value is the sheet's unique ID.

Example output structure:

{
  "folder": {
    "id": "123456789",
    "name": "Project Folder",
    "...": "other folder properties"
  },
  "namedSheets": {
    "Sheet A": 11111111,
    "Sheet B": 22222222,
    "Sheet C": 33333333
  }
}

No binary data output is produced by this operation.

Dependencies

  • Requires an active connection to the Smartsheet API via an API key credential configured in n8n.
  • The node uses the Smartsheet REST API endpoint GET /folders/{folderId} to retrieve folder and sheets information.
  • Proper permissions on the Smartsheet account are necessary to access the folder and its sheets.

Troubleshooting

  • Error: Folder not found or access denied
    Ensure the provided Folder ID is correct and that the API key has sufficient permissions to access the folder.

  • Empty sheets list returned
    The folder may exist but contain no sheets. Verify the folder contents in Smartsheet UI.

  • API rate limits or connectivity issues
    Network problems or hitting Smartsheet API rate limits can cause failures. Retry after some time or check network connectivity.

  • Invalid Folder ID format
    Confirm the Folder ID is a valid string matching Smartsheet folder IDs.

If the node throws errors related to missing parameters, verify that the required Folder ID property is set and non-empty.

Links and References

Discussion