write_google_sheets_range

write_google_sheets_range(sheet_id: str, range: str, values: list, sheet_name: str = None, *, value_input_option: str = "RAW") -> dict

Requires Editor access. Supply a complete rectangular matrix matching a bounded range of at most 10,000 cells. Strings, numbers and booleans are supported. RAW stores literal values; USER_ENTERED interprets formulas/dates. Empty strings clear values. Returns success, range and updatedCells. Does not insert rows or resize the tab. A timeout does not prove whether the write committed.

Example

write_google_sheets_range(
    "SHEET_ID", "A1:C2",
    [["Report", "Date", "Public or DM?"], ["Weekly", "2026-10-13", "DM"]],
    sheet_name="Reports",
)

See Google Sheets: tables, ranges and reliability for access, limits, merged cells, cache freshness and safe recovery after failures.