Add Rows to Sheet
smartsheet_add_rowsAdd rows to a Smartsheet sheet with cells specified as column-value pairs. Position rows at top, bottom, or relative to parent or sibling rows for hierarchical structures.
Instructions
Add one or more rows to a Smartsheet sheet. Each row specifies cells as columnId/value pairs. Rows can be positioned at top, bottom, or relative to a parent/sibling row for hierarchical (indent) structures.
Args:
sheet_id (number): Target sheet ID
rows (array): Array of row objects, each containing:
cells (array): Array of {columnId, value} objects
to_top (boolean, optional): Insert at top of sheet
to_bottom (boolean, optional): Insert at bottom (default)
parent_id (number, optional): Make this a child of this row ID
sibling_id (number, optional): Insert as sibling below this row ID
expanded (boolean, optional): Whether row is expanded (default true)
Returns: Newly created row IDs and updated sheet version.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes | Target sheet ID | |
| rows | Yes | Rows to add |