clear_google_sheets_range
Clear cell values and formulas without deleting rows or formatting.
clear_google_sheets_range(sheet_id: str, range: str, sheet_name: str = None) -> dictRequires Editor access. Clears values/formulas in a bounded A1 rectangle of at most 10,000 cells; preserves formatting, notes, validation and row positions. Returns success and range. Does not delete rows, insert rows, or resize the tab. A timeout does not prove whether the write committed.
Example
clear_google_sheets_range("SHEET_ID", "A2:C100", sheet_name="Reports")See Google Sheets: tables, ranges and reliability for access, limits, merged cells, cache freshness and safe recovery after failures.