create_spreadsheet
Generate a new Google Spreadsheet with specified title and optional sheet names. Input user Google email and receive details like ID and URL of the created spreadsheet.
Instructions
Creates a new Google Spreadsheet.
Args:
user_google_email (str): The user's Google email address. Required.
title (str): The title of the new spreadsheet. Required.
sheet_names (Optional[List[str]]): List of sheet names to create. If not provided, creates one sheet with default name.
Returns:
str: Information about the newly created spreadsheet including ID and URL.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| service | Yes | ||
| sheet_names | No | ||
| title | Yes | ||
| user_google_email | Yes |
Implementation Reference
- gsheets/sheets_tools.py:261-307 (handler)The core handler function decorated with @server.tool() that implements the create_spreadsheet MCP tool using Google Sheets API to create a new spreadsheet with given title and optional sheets.@server.tool() @handle_http_errors("create_spreadsheet", service_type="sheets") @require_google_service("sheets", "sheets_write") async def create_spreadsheet( service, user_google_email: str, title: str, sheet_names: Optional[List[str]] = None, ) -> str: """ Creates a new Google Spreadsheet. Args: user_google_email (str): The user's Google email address. Required. title (str): The title of the new spreadsheet. Required. sheet_names (Optional[List[str]]): List of sheet names to create. If not provided, creates one sheet with default name. Returns: str: Information about the newly created spreadsheet including ID and URL. """ logger.info(f"[create_spreadsheet] Invoked. Email: '{user_google_email}', Title: {title}") spreadsheet_body = { "properties": { "title": title } } if sheet_names: spreadsheet_body["sheets"] = [ {"properties": {"title": sheet_name}} for sheet_name in sheet_names ] spreadsheet = await asyncio.to_thread( service.spreadsheets().create(body=spreadsheet_body).execute ) spreadsheet_id = spreadsheet.get("spreadsheetId") spreadsheet_url = spreadsheet.get("spreadsheetUrl") text_output = ( f"Successfully created spreadsheet '{title}' for {user_google_email}. " f"ID: {spreadsheet_id} | URL: {spreadsheet_url}" ) logger.info(f"Successfully created spreadsheet for {user_google_email}. ID: {spreadsheet_id}") return text_output
- gsheets/__init__.py:7-23 (registration)Registers the create_spreadsheet tool by importing and including it in __all__ for module-level exposure.from .sheets_tools import ( list_spreadsheets, get_spreadsheet_info, read_sheet_values, modify_sheet_values, create_spreadsheet, create_sheet, ) __all__ = [ "list_spreadsheets", "get_spreadsheet_info", "read_sheet_values", "modify_sheet_values", "create_spreadsheet", "create_sheet", ]