> ## Documentation Index
> Fetch the complete documentation index at: https://docs.r28.ai/charter/llms.txt
> Use this file to discover all available pages before exploring further.

# spreadsheets_values_clear

> Clears values from a spreadsheet.

<div className="tool-route"><span className="tool-row-method" data-method="POST">POST</span><code>{"https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:clear"}</code></div>

```python gsheets_spreadsheets_values_clear.py theme={null}
from charter.packs import gsheets

result = await gsheets.spreadsheets_values_clear.ainvoke({"spreadsheetId": ..., "range": ...})
```

<Note>
  Requires `https://www.googleapis.com/auth/spreadsheets`. Costs 1 against the provider's own quota.
</Note>

## Path parameters

<div className="reference-table">
  | Field                                                                 | Type     | Description                                              |
  | --------------------------------------------------------------------- | -------- | -------------------------------------------------------- |
  | `spreadsheetId` <span className="required" title="required">\*</span> | `string` | The ID of the spreadsheet to update.                     |
  | `range` <span className="required" title="required">\*</span>         | `string` | The A1 notation or R1C1 notation of the values to clear. |
</div>
