write_google_sheet_range

Overwrite one explicit Google Sheet range with cell values.

Parameters

Name	Type	Required	Default	Description
model_name	Annotated[str, Field(description='Name of the Bridge Town model.')]	Yes	—
values	Annotated[list[Annotated[list[Any], Field(min_length=1, max_length=1000)]], Field(min_length=1, max_length=10000, description='Bounded rows and cell values to write.')]	Yes	—
cell_range	Annotated[str, Field(min_length=1, max_length=200, description='Explicit A1 destination, including the tab name.')]	Yes	—
spreadsheet_id	`Annotated[str	None, Field(description=‘Google Spreadsheet ID; provide this or source_name.’)]`	No	None
source_name	`Annotated[str	None, Field(description=‘Connected Sheet data-source name; provide this or spreadsheet_id.’)]`	No	None
value_input_option	Literal['RAW', 'USER_ENTERED']	No	'RAW'
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_written (integer)
• total_rows (integer)

See the response example below for the full payload shape.

Example

Tool Call

{
  "name": "write_google_sheet_range",
  "arguments": {
    "model_name": "forecasts",
    "cell_range": "Forecast!A1:B3",
    "values": [
      [
        "Month",
        "Revenue"
      ],
      [
        "2026-01",
        100
      ],
      [
        "2026-02",
        110
      ]
    ],
    "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG"
  }
}

Response

{
  "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG",
  "ranges_written": 1,
  "total_rows": 3
}

Notes

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