MCP Google Suite

Instructions

Implementation Reference

• src/mcp_google_suite/server.py:356-369 (handler)

  The MCP tool handler for 'sheets_create' that extracts arguments, validates, and delegates to SheetsService.create_spreadsheet.

  async def _handle_sheets_create(
      self, context: GoogleWorkspaceContext, arguments: dict
  ) -> Dict[str, Any]:
      """Handle sheets create requests."""
      title = arguments.get("title")
      sheets = arguments.get("sheets", [])
  
      if not title:
          raise ValueError("Spreadsheet title is required")
  
      logger.debug(f"Creating spreadsheet - Title: {title}, Sheets: {sheets}")
      result = await context.sheets.create_spreadsheet(title=title, sheets=sheets)
      logger.debug(f"Spreadsheet created - ID: {result.get('spreadsheetId')}")
      return result

• src/mcp_google_suite/server.py:120-135 (schema)

  Defines the input schema, description, and name for the 'sheets_create' tool.

  types.Tool(
      name="sheets_create",
      description="Create a new Google Sheet",
      inputSchema={
          "type": "object",
          "properties": {
              "title": {"type": "string", "description": "Title of the spreadsheet"},
              "sheets": {
                  "type": "array",
                  "items": {"type": "string"},
                  "description": "Sheet names",
              },
          },
          "required": ["title"],
      },
  ),

• src/mcp_google_suite/server.py:177-182 (registration)

  Dynamically registers the 'sheets_create' handler in the tool registry based on the tool list.

  for tool in self._get_tools_list():
      handler_name = f"_handle_{tool.name}"
      if hasattr(self, handler_name):
          handler = getattr(self, handler_name)
          self._tool_registry[tool.name] = handler
          logger.debug(f"Registered handler for {tool.name}")

• src/mcp_google_suite/sheets/service.py:14-29 (helper)

  Core implementation that creates the Google Spreadsheet using the Sheets API v4.

  def create_spreadsheet(self, title: str, sheets: Optional[List[str]] = None) -> Dict[str, Any]:
      """Create a new Google Spreadsheet with optional sheets."""
      try:
          spreadsheet_body = {"properties": {"title": title}}
  
          if sheets:
              spreadsheet_body["sheets"] = [
                  {"properties": {"title": sheet_name}} for sheet_name in sheets
              ]
  
          spreadsheet = self.service.spreadsheets().create(body=spreadsheet_body).execute()
  
          return {"success": True, "spreadsheet": spreadsheet}
      except HttpError as error:
          return {"success": False, **self.handle_error(error)}