# SheetsReadDataTool

> **Class** in `langchain_google_community`

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

Tool for reading data from a single range in Google Sheets.

Inherits from
[`BaseReadTool`][langchain_google_community.sheets.read_sheet_tools.BaseReadTool].

Reads data from a single range with support for various rendering options and data
transformations.

## Signature

```python
SheetsReadDataTool()
```

## Description

**Tool Output:**

success (bool): Whether operation succeeded.
spreadsheet_id (str): The spreadsheet ID.
range (str): The actual range that was read (A1 notation).
values (list): Processed data (2D array or list of dictionaries).
major_dimension (str): The major dimension ('ROWS' or 'COLUMNS').
render_options (dict): Applied rendering options.
processing_options (dict): Applied processing options.

???+ example "Basic Usage"

    Read data from a range:

    ```python
    from langchain_google_community.sheets import SheetsReadDataTool

    tool = SheetsReadDataTool(api_key="your_api_key")
    result = tool.run(
        {
            "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
            "range_name": "A1:E10",
        }
    )
    print(result["values"])
    ```

??? example "Convert to Records"

    Convert 2D array to list of dictionaries using first row as headers:

    ```python
    result = tool.run(
        {
            "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
            "range_name": "A1:E10",
            "convert_to_records": True,
        }
    )
    # Returns: [{"Name": "Alice", "Age": 25, ...}, ...]
    ```

??? example "Custom Rendering Options"

    Get unformatted values and formulas:

    ```python
    result = tool.run(
        {
            "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
            "range_name": "A1:E10",
            "value_render_option": "UNFORMATTED_VALUE",
        }
    )
    ```

## Extends

- `BaseReadTool`

## Properties

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

---

[View source on GitHub](https://github.com/langchain-ai/langchain-google/blob/6b6f1e8aa4053d9914ab0b58ee16c21364897842/libs/community/langchain_google_community/sheets/read_sheet_tools.py#L202)