# SheetsClearValuesTool

> **Class** in `langchain_google_community`

📖 [View in docs](https://reference.langchain.com/python/langchain-google-community/sheets/write_sheet_tools/SheetsClearValuesTool)

Tool for clearing values from a Google Spreadsheet range.

Inherits from
[`SheetsBaseTool`][langchain_google_community.sheets.base.SheetsBaseTool].

Clears cell values from a specified range while preserving formatting and
structure.

!!! note "Authentication Required"

    Requires OAuth2 authentication. Use `api_resource` parameter with
    authenticated Google Sheets service.

!!! info "Formatting Preserved"

    Only values are cleared. Formatting, borders, colors, fonts, and data
    validation rules remain intact.

## Signature

```python
SheetsClearValuesTool()
```

## Description

**Tool Output:**

success (bool): Whether operation succeeded.
spreadsheet_id (str): The spreadsheet ID.
cleared_range (str): The A1 notation of the cleared range.

???+ example "Basic Usage"

Clear a range of cells:

```python
from langchain_google_community.sheets import SheetsClearValuesTool

tool = SheetsClearValuesTool(api_resource=service)
result = tool.run(
    {
        "spreadsheet_id": "1TI6vO9eGsAeXcfgEjoEYcu4RgSZCUF4vdWGLBpg9-fg",
        "range": "Sheet1!A1:Z100",
    }
)
```

## Extends

- `SheetsBaseTool`

## Properties

- `name`
- `description`
- `args_schema`

---

[View source on GitHub](https://github.com/langchain-ai/langchain-google/blob/982e4015b249de8b9ba1e787746d8cc1f6d6b790/libs/community/langchain_google_community/sheets/write_sheet_tools.py#L399)