get_last_row
Find the last row with data in a specified column of a Google Sheets spreadsheet. Returns the 1-based row number to determine the active data range.
Instructions
Find the last row with data in a column.
Args: spreadsheet_id: The ID of the spreadsheet. sheet_name: Name of the sheet. column: Column letter to check (default "A").
Returns: JSON with the last row number (1-based).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheet_id": "<spreadsheet_id>",
"sheet_name": "<sheet_name>"
},
"name": "get_last_row"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | No | A | |
| sheet_name | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |