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

google-sheets-mcp

get_sheet_cells_by_range_tool

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from google-sheets-mcp

Related Tools

MCP directory API