Manage your spreadsheets and data with Smartsheet.
Manage your spreadsheets and data with Smartsheet, including retrieving all sheets, reading sheet data, managing rows and columns, and handling spreadsheet operations for efficient data organization and collaboration within the Smartsheet platform.
Required:
action
- The operation to perform (get-all-sheets, get-sheet-data)Optional:
sheet-id
- Smartsheet sheet IDinclude-columns
- Include column informationinclude-rows
- Include row informationRetrieve a list of all your Smartsheet sheets
Parameters:
Example:
Response:
Read data from a specific Smartsheet sheet
Parameters:
sheet-id
(required) - Smartsheet sheet IDinclude-columns
(optional) - Include column information (default: true)include-rows
(optional) - Include row information (default: true)Example:
Response:
Smartsheet API uses custom proxy integration through Paragon. Sheet IDs are numeric identifiers found in sheet URLs. Each sheet contains columns and rows with cells that store data. Columns are identified by ID and have types like TEXT_NUMBER, DATE, PICKLIST. Rows contain cells that reference column IDs for data organization. The API supports both reading sheet lists and detailed sheet data including cell values and formatting information.