batch_read_gsheet_ranges

Read multiple ranges from a connected Google Sheet in a single API call. Returns the values for each requested A1-notation range. Target the sheet by source_name (from list_data_sources) OR spreadsheet_id. Requires at least Viewer role on the project. Returns: spreadsheet_id, ranges (list of {range, values}), sheet_url. On error: error, message, hint.

read-only · idempotent

Parameters

Name	Type	Required	Default	Description
`project_name`	`str`	Yes	—
`ranges`	`list[str]`	Yes	—
`spreadsheet_id`	`str	None`	No	`None`
`source_name`	`str	None`	No	`None`

Returns

Returns a structured object. Top-level fields:

spreadsheet_id (string)
ranges (array<object>)
sheet_url (string)

See the response example below for the full payload shape.

Example

Tool Call

{
  "name": "batch_read_gsheet_ranges",
  "arguments": {
    "project_name": "forecasts",
    "ranges": [
      "Forecast!A1:B3",
      "Notes!A1"
    ],
    "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG"
  }
}

Response

{
  "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG",
  "ranges": [
    {
      "range": "Forecast!A1:B3",
      "values": [
        [
          "Month",
          "Revenue"
        ],
        [
          "2026-01",
          100
        ],
        [
          "2026-02",
          110
        ]
      ]
    },
    {
      "range": "Notes!A1",
      "values": [
        [
          "Generated by run 66666666-6666-6666-6666-666666666666"
        ]
      ]
    }
  ],
  "sheet_url": "https://docs.google.com/spreadsheets/d/1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG/edit"
}

Notes

Module: Export to Sheets
Requires authentication via API token or Auth0 JWT.