n8n Creators Leaderboard Chatbot

n8n Creators Leaderboard Chatbot Workflow Overview This workflow functions as an AI-powered chatbot designed to provide detailed statistics and analysis on n8n community workflow creators. When a user sends a chat message asking for stats on a specific creator (e.g., "Tell me about the creator 'joe'"), the workflow retrieves live data from a public GitHub repository, processes it, and generates a comprehensive report in Markdown format. The automation is broken into two primary functions: a conversational AI agent that interprets user requests, and a data-processing pipeline that acts as a "tool" for the agent. This allows users to query a complex dataset using natural language and receive a structured, insightful summary in return. Technologies & Automation This workflow automates the entire lifecycle of a data query, from retrieval to presentation, providing significant value by eliminating manual research and analysis. Technologies Used - Data Source: Raw JSON files hosted on a GitHub repository (teds-tech-talks/n8n-community-leaderboard). - Data Processing: Core n8n nodes like HTTP Request, Set, Split Out, Sort, Limit, Merge, and Filter. - AI & Language Model: LangChain nodes within n8n, specifically the Agent, Tool, and Memory nodes, powered by an OpenAI (gpt-4o-mini) model. An alternative for a local Ollama model is also included but disabled. - Interface: A Chat Trigger to initiate the workflow from a chat interface. What it Automates - Data Aggregation: Automatically fetches the latest creator and workflow statistics from two separate JSON files on GitHub. - Data Transformation: Cleans, sorts, and limits the data to focus on top performers, then merges creator and workflow information into a single, enriched dataset. - Targeted Filtering: Dynamically filters the comprehensive dataset based on the specific username provided in the user's chat query. - Report Generation: Uses an AI agent to automatically generate a detailed, well-structured Markdown report, complete with summaries, tables, and analysis. AI Integration The AI is not just an add-on; it is the core of this workflow's user experience and functionality.