get_sheet_cells_by_range_tool
Retrieve cell data from a specific range in a Google Sheet using A1 notation. Specify spreadsheet name, sheet name, start and end cells, and choose to include headers. Returns JSON with cell data and metadata.
Instructions
Get sheet cells by range.
This tool retrieves cell data from a specific range within a sheet.
You can specify the exact cell range using A1 notation.
Args:
spreadsheet_name: Name of the spreadsheet
sheet_name: Name of the sheet to get cells from
start_cell: Starting cell reference (e.g., 'A1', 'B2')
end_cell: Ending cell reference (e.g., 'C5', 'D10')
include_headers: Whether to include header row
Returns:
JSON string with cells data and metadata
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_cell | Yes | Ending cell reference (e.g., 'C5', 'D10') | |
| include_headers | No | Whether to include header row (default: False) | |
| sheet_name | Yes | The name of the sheet to get cells from | |
| spreadsheet_name | Yes | The name of the Google Spreadsheet | |
| start_cell | Yes | Starting cell reference (e.g., 'A1', 'B2') |
Input Schema (JSON Schema)
{
"properties": {
"end_cell": {
"description": "Ending cell reference (e.g., 'C5', 'D10')",
"title": "End Cell",
"type": "string"
},
"include_headers": {
"default": false,
"description": "Whether to include header row (default: False)",
"title": "Include Headers",
"type": "boolean"
},
"sheet_name": {
"description": "The name of the sheet to get cells from",
"title": "Sheet Name",
"type": "string"
},
"spreadsheet_name": {
"description": "The name of the Google Spreadsheet",
"title": "Spreadsheet Name",
"type": "string"
},
"start_cell": {
"description": "Starting cell reference (e.g., 'A1', 'B2')",
"title": "Start Cell",
"type": "string"
}
},
"required": [
"spreadsheet_name",
"sheet_name",
"start_cell",
"end_cell"
],
"title": "get_sheet_cells_by_range_toolArguments",
"type": "object"
}