Google Workspace MCP Server - Control Gmail, Calendar, Docs, Sheets, Slides, Chat, Forms & Drive

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.

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",
  ]