get_sheet_cells_by_notation_tool
Retrieve cell values from a Google Sheet by specifying cell notations like 'A1', 'B3'. Get a JSON mapping of cell references to their values.
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 mappingInput Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_name | Yes | The name of the Google Spreadsheet | |
| sheet_name | Yes | The name of the sheet to get cells from | |
| cell_notations | Yes | List of cell notations to get values from (e.g., ['A1', 'A6', 'A10', 'E5']) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |