Overview

This node operation retrieves a Smartsheet sheet by its ID. It fetches the sheet's data including rows and columns, then formats the rows by mapping column IDs to their titles and including cell values. This operation is useful for scenarios where you need to read and process the full content of a specific Smartsheet sheet, such as for reporting, data analysis, or integration with other systems.

Use Case Examples

1. Retrieve a project tracking sheet by its ID to analyze task statuses.
2. Fetch a budget sheet to extract financial data for further processing.

Properties

Output

JSON

• id - The unique identifier of the sheet.
• name - The name of the sheet.
• rows - Array of rows in the sheet, each containing rowId, rowNumber, and cell values keyed by column titles.
• columns - Array of columns in the sheet.
• formattedRows - Array of rows with cell values mapped to column titles for easier reading.
• firstRow - The first row of the formatted rows, if any.

Dependencies

• Smartsheet API with an API key credential

Troubleshooting

• Ensure the provided sheet ID is correct and accessible with the API credentials.
• If the sheet is large, the API call might take longer or hit rate limits; consider pagination or filtering if supported.
• Common error: 'Sheet not found' indicates an invalid or inaccessible sheet ID.
• Handle API errors gracefully and check for network connectivity issues.

Links

• Smartsheet API Documentation - Official API documentation for Smartsheet, useful for understanding endpoints and data structures.