# hide_sheet_rows (https://sellersheetai.com/docs/mcp-api/tools/hide_sheet_rows)

> Hide rows in a sheet, or show hidden rows again.

Access: **WRITE** · toolset google_workspace · family null

## Call it

MCP tool call:

```json
{
  "name": "hide_sheet_rows",
  "arguments": {
    "spreadsheet_id": "<spreadsheet_id>",
    "sheet_name": "<sheet_name>",
    "start_row": 1
  }
}
```

Tool API (early access — contact us):

```bash
curl -X POST https://api.sellersheetai.com/api/v1/tools/hide_sheet_rows \
  -H "Authorization: Bearer $SELLERSHEET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"spreadsheet_id":"<spreadsheet_id>","sheet_name":"<sheet_name>","start_row":1}'
```

## Arguments

| Name | Type | Required | Description |
|---|---|---|---|
| `spreadsheet_id` | string | yes | the spreadsheet ID (from its URL or get_sheet_metadata). |
| `sheet_name` | string | yes | the tab name. |
| `start_row` | integer | yes | First row to hide (1-based). |
| `end_row` | integer |  | Last row to hide inclusive (1-based). Defaults to start_row. |
| `hidden` | boolean |  | true (default) hides the rows; false shows them again. |

## Result

- `data.startRow / data.endRow / data.hidden` — the rows changed and their new state.

## Example

- hide_sheet_rows("1ABC...", "SP Campaigns", 1)  # Hide row 1 (machine names) hide_sheet_rows("1ABC...", "SP Campaigns", 1, hidden=False)  # Show it again