get_google_spreadsheet_metadata

Get a connected Google Sheet’s title, tabs, and dimensions.

read-only · idempotent

Parameters

Name	Type	Required	Default	Description
model_name	Annotated[str, Field(description='Name of the Bridge Town model.')]	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)
• title (string)
• sheets (array<object>)

See the response example below for the full payload shape.

Example

Tool Call

{
  "name": "get_google_spreadsheet_metadata",
  "arguments": {
    "model_name": "forecasts",
    "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG"
  }
}

Response

{
  "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG",
  "title": "FY26 Forecast",
  "sheets": [
    {
      "sheetId": 0,
      "title": "Forecast",
      "index": 0
    }
  ]
}

Notes

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