# SheetsCreateSpreadsheetTool

> **Class** in `langchain_google_community`

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

Tool for creating new Google Spreadsheets.

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

Creates spreadsheets with configurable properties and optional initial data.

!!! note "Authentication Required"
    Requires OAuth2 authentication. Use `api_resource` parameter with
    authenticated Google Sheets service.

## Signature

```python
SheetsCreateSpreadsheetTool()
```

## Description

**Tool Output:**

success (bool): Whether operation succeeded.
spreadsheet_id (str): Unique ID of the created spreadsheet.
spreadsheet_url (str): Direct URL to open the spreadsheet.
title (str): The spreadsheet title.
locale (str): The locale setting.
time_zone (str): The timezone setting.
auto_recalc (str): The recalculation setting.
created (bool): Whether creation succeeded.
initial_data_added (bool): Whether initial data was added (if provided).
initial_data_cells_updated (int): Number of cells updated (if data added).
initial_data_range (str): Range where data was placed (if data added).

???+ example "Basic Usage"

    Create a simple spreadsheet:

    ```python
    from langchain_google_community.sheets import SheetsCreateSpreadsheetTool

    tool = SheetsCreateSpreadsheetTool(api_resource=service)
    result = tool.run({"title": "My New Spreadsheet"})
    print(f"Created: {result['spreadsheet_url']}")
    ```

??? example "With Initial Data"

    Create spreadsheet with pre-populated data:

    ```python
    result = tool.run(
        {
            "title": "Sales Report",
            "initial_data": [
                ["Name", "Region", "Sales"],
                ["Alice", "East", "95000"],
                ["Bob", "West", "87000"],
            ],
            "initial_range": "A1",
        }
    )
    ```

??? example "Custom Configuration"

    Create with locale and timezone settings:

    ```python
    result = tool.run(
        {
            "title": "European Report",
            "locale": "fr_FR",
            "time_zone": "Europe/Paris",
            "auto_recalc": "HOUR",
        }
    )
    ```

## Extends

- `SheetsBaseTool`

## Properties

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

---

[View source on GitHub](https://github.com/langchain-ai/langchain-google/blob/a3f016b2a6c4af535df275545f76fa7424aa39e5/libs/community/langchain_google_community/sheets/create_spreadsheet_tool.py#L62)