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).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | No | A | |
| sheet_name | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |