read_google_sheet_ranges

Read bounded A1 ranges from one connected Google Sheet.

read-only · idempotent

Parameters

Name	Type	Required	Default	Description
model_name	Annotated[str, Field(description='Name of the Bridge Town model.')]	Yes	—
ranges	Annotated[list[Annotated[str, Field(min_length=1, max_length=200)]], Field(min_length=1, max_length=100, description="Bounded A1-notation ranges, such as ['Sheet1!A1:D10'].")]	Yes	—
spreadsheet_id	`Annotated[str	None, Field(description=‘Google Spreadsheet ID from the sheet URL.’)]`	No	None
source_name	`Annotated[str	None, Field(description=‘Logical name of the connected Google Sheet data source.’)]`	No	None
workspace_id	`Annotated[str	None, Field(description=WORKSPACE_ID_FIELD_DESCRIPTION)]`	No	None

Returns

Returns a structured object. Top-level fields:

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

See the response example below for the full payload shape.

Example

Tool Call

{
  "name": "read_google_sheet_ranges",
  "arguments": {
    "model_name": "forecasts",
    "ranges": [
      "Forecast!A1:C4"
    ],
    "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG"
  }
}

Response

{
  "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG",
  "ranges": [
    {
      "range": "Forecast!A1:C4",
      "values": [
        [
          "Month",
          "Revenue"
        ]
      ]
    }
  ]
}

Notes

• Module: Google Sheets
• Requires authentication via API token or Auth0 JWT.