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

> Insert rows or columns in a sheet.

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

## Call it

MCP tool call:

```json
{
  "name": "insert_sheet_rows_cols",
  "arguments": {
    "spreadsheet_id": "<spreadsheet_id>",
    "sheet_name": "<sheet_name>",
    "dimension": "<dimension>",
    "start_index": 1,
    "end_index": 1
  }
}
```

Tool API (early access — contact us):

```bash
curl -X POST https://api.sellersheetai.com/api/v1/tools/insert_sheet_rows_cols \
  -H "Authorization: Bearer $SELLERSHEET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"spreadsheet_id":"<spreadsheet_id>","sheet_name":"<sheet_name>","dimension":"<dimension>","start_index":1,"end_index":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. |
| `dimension` | string | yes | 'ROWS' or 'COLUMNS'. |
| `start_index` | integer | yes | Start index (0-based). |
| `end_index` | integer | yes | End index (exclusive). |

## Result

- Success confirmation.

## Example

- insert_sheet_rows_cols("1ABC...", "Sheet1", "ROWS", 5, 10)  # Insert 5 rows at index 5