LangChain Reference home page

GitHub
Main Docs

Overview
Document Loaders
Vector Stores
Retrievers
Tools

Google GenAI (Gemini)

Google Vertex AI

IBM

⌘I

LangChain Assistant

Ask a question to get started

Enter to send•Shift+Enter new line

Menu

Overview Document Loaders Vector Stores Retrievers Tools

Google GenAI (Gemini)

Google Vertex AI

Language

Theme

Pythonlangchain-google-communitysheetscreate_spreadsheet_tool

Module●Since v3.0

create_spreadsheet_tool

Tool for creating new Google Spreadsheets.

Functions

validate_range_name

Validate and normalize a range name.

Permissive A1 validator. Supports:

Single cells: 'A1', 'Z99'
Areas: 'A1:B2'
Whole columns: 'A:A', 'B:D'
Whole rows: '1:1', '5:10'
Sheet-qualified: 'Sheet1!A1', "'My Sheet'!A1:B2"
Named ranges: 'MyData', 'Sales_2024'

Classes

Base class for Google Sheets tools.

Authentication:

api_resource: OAuth2 credentials for full access (read/write private sheets)
api_key: API key for read-only access (public sheets only)

Write operations require OAuth2 credentials.

CreateSpreadsheetSchema

Input schema for SheetsCreateSpreadsheetTool.

SheetsCreateSpreadsheetTool

Tool for creating new Google Spreadsheets.

Inherits from SheetsBaseTool.

Creates spreadsheets with configurable properties and optional initial data.

Authentication Required

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

View source on GitHub