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
`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"
}

google-sheets-mcp

get_sheet_cells_by_notation_tool

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from google-sheets-mcp

Related Tools

MCP directory API