MCP Google Workspace Server

Instructions

Implementation Reference

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

  The tool handler function _handle_sheets_create that processes the tool call arguments and delegates to SheetsService.create_spreadsheet method.

  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)

  Input schema definition for the sheets_create tool within the _get_tools_list method.

  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/sheets/service.py:14-29 (helper)

  Core implementation of spreadsheet creation using Google Sheets API v4 in SheetsService class, called by the handler.

  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)}