append_google_sheet_rows

Append explicit rows to one Google Sheet tab.

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 append.')]	Yes	—
sheet_name	Annotated[str, Field(min_length=1, max_length=100, description='Explicit destination tab name.')]	No	'Sheet1'
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
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": "append_google_sheet_rows",
  "arguments": {
    "model_name": "forecasts",
    "sheet_name": "Forecast",
    "values": [
      [
        "2026-03",
        120
      ]
    ],
    "spreadsheet_id": "1aBcDeFgHiJkLmNoPqRsTuVwXyZ0123456789ABCDEFG"
  }
}

Response

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

Notes

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