Google Workspace MCP Server

Instructions

Implementation Reference

• core/comments.py:70-74 (handler)

  The handler function for the 'create_spreadsheet_comment' tool. It is dynamically defined for spreadsheets, decorated with authentication and error handling, and delegates to the implementation helper.
  @require_google_service("drive", "drive_file") @handle_http_errors(create_func_name, service_type="drive") async def create_comment(service, user_google_email: str, spreadsheet_id: str, comment_content: str) -> str: """Create a new comment on a Google Spreadsheet.""" return await _create_comment_impl(service, app_name, spreadsheet_id, comment_content)
• core/comments.py:183-202 (helper)

  The core implementation that uses the Google Drive API to create a comment on the specified spreadsheet, returning a formatted success message.
  async def _create_comment_impl(service, app_name: str, file_id: str, comment_content: str) -> str: """Implementation for creating a comment on any Google Workspace file.""" logger.info(f"[create_{app_name}_comment] Creating comment in {app_name} {file_id}") body = {"content": comment_content} comment = await asyncio.to_thread( service.comments().create( fileId=file_id, body=body, fields="id,content,author,createdTime,modifiedTime" ).execute ) comment_id = comment.get('id', '') author = comment.get('author', {}).get('displayName', 'Unknown') created = comment.get('createdTime', '') return f"Comment created successfully!\\nComment ID: {comment_id}\\nAuthor: {author}\\nCreated: {created}\\nContent: {comment_content}"
• core/comments.py:120-123 (registration)

  Registers the dynamically created comment tools, including 'create_spreadsheet_comment', with the MCP server.
  server.tool()(read_comments) server.tool()(create_comment) server.tool()(reply_to_comment) server.tool()(resolve_comment)
• gsheets/sheets_tools.py:358-366 (registration)

  Triggers the creation and registration of spreadsheet-specific comment tools by calling the factory function.
  # Create comment management tools for sheets _comment_tools = create_comment_tools("spreadsheet", "spreadsheet_id") # Extract and register the functions read_sheet_comments = _comment_tools['read_comments'] create_sheet_comment = _comment_tools['create_comment'] reply_to_sheet_comment = _comment_tools['reply_to_comment'] resolve_sheet_comment = _comment_tools['resolve_comment']
• core/comments.py:114-117 (helper)

  Sets the function names dynamically, e.g., 'create_comment' to 'create_spreadsheet_comment'.
  read_comments.__name__ = read_func_name create_comment.__name__ = create_func_name reply_to_comment.__name__ = reply_func_name resolve_comment.__name__ = resolve_func_name