Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API

Actions13

Overview

This node interacts with the Smartsheet API to perform various sheet management operations. Specifically, the "Get Sheet Using ID" operation retrieves a full sheet by its unique identifier, including all rows and columns, and formats the data for easier consumption.

Common scenarios where this node is useful include:

  • Fetching an entire Smartsheet to analyze or process its data in workflows.
  • Integrating Smartsheet data into other systems by extracting structured sheet content.
  • Automating reporting or data synchronization tasks that require reading sheet contents.

For example, you might use this node to get a project tracking sheet by its ID, then filter or transform the rows before sending them to a database or notification system.

Properties

Name Meaning
Sheet Name or ID Select a sheet from the dropdown list or specify its ID directly (supports expressions). This identifies which sheet to retrieve.

The dropdown options are dynamically loaded from your Smartsheet account using the "listSheets" method, showing available sheets by name and their IDs.

Output

The output JSON contains the full sheet data as returned by the Smartsheet API, enhanced with a formattedRows field:

  • formattedRows: An array of row objects where each row includes:

    • rowId: The unique ID of the row.
    • rowNumber: The position number of the row in the sheet.
    • Columns mapped by their titles as keys, with corresponding cell values.

  • firstRow: The first item in formattedRows or an empty object if no rows exist.

This structure simplifies accessing row data by column names instead of column IDs.

No binary data output is produced by this operation.

Dependencies

  • Requires a valid API authentication token credential for Smartsheet.
  • The node uses the official Smartsheet REST API v2 endpoint (https://api.smartsheet.com/2.0).
  • The user must have appropriate permissions to read the specified sheet.

Troubleshooting

  • Error: Sheet not found or invalid ID
    Ensure the provided Sheet ID exists and the API token has access rights to it.

  • Empty output or no rows returned
    The sheet may be empty or filtered out; verify the sheet contents in Smartsheet.

  • API rate limits or connectivity issues
    Check network connectivity and Smartsheet API usage limits.

  • Invalid expression in Sheet ID property
    If using expressions, confirm they resolve correctly to a valid sheet ID.

Links and References

Discussion