get_sheet_cells_by_notation_tool
Extract values from specific Google Sheets cells using A1 notation. Input spreadsheet name, sheet name, and cell notations to retrieve mapped JSON data for efficient spreadsheet data retrieval.
Instructions
Get values from specific cells in a sheet.
This tool retrieves values from multiple cells in a sheet using A1 notation.
Args:
spreadsheet_name: Name of the spreadsheet
sheet_name: Name of the sheet to get cells from
cell_notations: List of cell notations to get values from (e.g., ['A1', 'A6', 'A10', 'E5'])
Returns:
JSON string with cell values and mapping
Input Schema
Name | Required | Description | Default |
---|---|---|---|
cell_notations | Yes | List of cell notations to get values from (e.g., ['A1', 'A6', 'A10', 'E5']) | |
sheet_name | Yes | The name of the sheet to get cells from | |
spreadsheet_name | Yes | The name of the Google Spreadsheet |
Input Schema (JSON Schema)
{
"properties": {
"cell_notations": {
"description": "List of cell notations to get values from (e.g., ['A1', 'A6', 'A10', 'E5'])",
"items": {
"type": "string"
},
"title": "Cell Notations",
"type": "array"
},
"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"
}
},
"required": [
"spreadsheet_name",
"sheet_name",
"cell_notations"
],
"title": "get_sheet_cells_by_notation_toolArguments",
"type": "object"
}