Get Sheet Data
smartsheet_get_sheetRetrieve sheet data with columns, rows, and cell values. Filter by column IDs, row IDs, or modification date, and paginate results to get exactly the information you need.
Instructions
Retrieve sheet data from Smartsheet including columns, rows, and cell values. Supports optional filtering by column IDs, row IDs, and pagination via rowsModifiedSince. Use this to read project data, task lists, resource grids, or any tabular data stored in a sheet.
Args:
sheet_id (number): The numeric Smartsheet sheet ID
column_ids (number[], optional): Limit response to specific column IDs
row_ids (number[], optional): Limit response to specific row IDs
rows_modified_since (string, optional): ISO 8601 date; return only rows modified after this date
page_size (number, optional): Rows per page (default 100, max 500)
page (number, optional): Page number (default 1)
include_filters (boolean, optional): Include filter definitions in response
Returns: Sheet metadata, columns array, and rows array with cell values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes | Smartsheet sheet ID | |
| column_ids | No | Filter to specific column IDs | |
| row_ids | No | Filter to specific row IDs | |
| rows_modified_since | No | ISO 8601 datetime — only return rows modified after this | |
| page_size | No | Rows per page (default 100, max 500) | |
| page | No | Page number (default 1) |