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 workspace. Specifically, the "Get Sheet Using ID" operation retrieves detailed information about a sheet by its unique identifier. It fetches the sheet's metadata, rows, and columns, then formats the row data by mapping column IDs to their titles for easier consumption.

Common scenarios where this node is beneficial include:

  • Automating data retrieval from Smartsheet for reporting or integration with other systems.
  • Synchronizing Smartsheet data with databases or CRMs.
  • Extracting sheet content dynamically based on user input or workflow conditions.

For example, you might use this node to pull the latest project status from a Smartsheet sheet identified by its ID and then send a summary email or update another system accordingly.

Properties

Name Meaning
Sheet Name or ID Select a sheet from the dropdown list or specify a sheet 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 ID.

Output

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

  • formattedRows: An array of objects representing each row in the sheet. Each object includes:

    • rowId: The unique ID of the row.
    • rowNumber: The position number of the row.
    • Additional key-value pairs where keys are column titles and values are the corresponding cell values for that row.

  • firstRow: The first item of formattedRows if any rows exist; otherwise an empty object.

This structure makes it easy to access row data by column names rather than column IDs.

No binary data output is produced by this operation.

Dependencies

  • Requires an active Smartsheet API credential configured in n8n with appropriate permissions to read sheets.
  • Uses the Smartsheet REST API v2 endpoint https://api.smartsheet.com/2.0/sheets/{sheetId}.
  • The node depends on internal helper functions to make authenticated HTTP requests to Smartsheet.

Troubleshooting

  • Error: No rows specified — Occurs if operations expecting row IDs receive none. Ensure you provide valid row IDs when deleting or updating rows.
  • Column titled "X" not found — Happens when referencing a column title that does not exist in the sheet. Verify column names carefully.
  • API request failures — Could be due to invalid credentials, insufficient permissions, or network issues. Check your Smartsheet API key and connectivity.
  • If the sheet ID is invalid or the sheet is inaccessible, the node will throw an error indicating the resource was not found.
  • When using expressions for sheet ID, ensure they resolve correctly at runtime.

To resolve errors, verify all input parameters, confirm API credentials, and check Smartsheet API status.

Links and References

Discussion