> ## 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_batch_clear

> Clears one or more ranges of 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:batchClear"}</code></div>

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

result = await gsheets.spreadsheets_values_batch_clear.ainvoke({"spreadsheetId": ..., "ranges": ...})
```

<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. |
</div>

## Body

<div className="reference-table">
  | Field                                                          | Type        | Description                                                                                                  |
  | -------------------------------------------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------ |
  | `ranges` <span className="required" title="required">\*</span> | `string`\[] | The ranges to clear, in A1 notation or R1C1 notation. <span className="field-constraints">min 1 items</span> |
</div>