🤖🧝‍💻 AI Agent for Top n8n Creators Leaderboard Reporting

Workflow Name

Key Features and Highlights

This workflow automatically aggregates and analyzes creator and workflow statistics from the n8n community’s GitHub repositories. By integrating OpenAI GPT-4o-mini and Google Gemini large language models (LLMs), it generates detailed reports in Markdown format, featuring creator leaderboards, workflow rankings, visitor metrics, and usage statistics. The reports can be saved locally, uploaded to Google Drive, and distributed via email and Telegram, enabling multi-channel sharing and dissemination.

Core Problems Addressed

Automates the processing and summarization of n8n community creator and workflow statistics, eliminating manual collection which is cumbersome and error-prone.
Provides clear, structured reports to help community managers and users gain deep insights into popular workflows and active contributors.
Enhances community transparency and incentive mechanisms, promoting the dissemination and exchange of high-quality workflows.

Use Cases

Community managers monitoring n8n community activity and contributions on a regular basis.
Creators evaluating their own and competitors’ workflow performance to optimize their development focus.
New users quickly discovering popular and high-quality workflows to improve their experience.
Teams automatically generating and sharing workflow usage reports to support decision-making.

Main Workflow Steps

Scheduled Trigger: The workflow is triggered daily via the Schedule Trigger node.
Global Variable Setup: Define basic parameters such as GitHub data source URLs and filenames.
HTTP Requests to Fetch Data: Retrieve JSON statistics for creators and workflows separately.
Data Parsing and Splitting: Split array data to process creator and workflow information independently.
Sorting and Filtering: Sort by weekly unique contributors in descending order, selecting the Top 10 creators and Top 50 workflows.
Data Merging: Merge creator data with corresponding workflows based on usernames.
Data Aggregation: Summarize all filtered data to prepare report content.
AI Report Generation: Invoke OpenAI GPT-4o-mini and Google Gemini models to produce a detailed Markdown report and a Top 10 workflows list.
Report Format Conversion: Convert the Markdown report into HTML format for email and Telegram distribution.
Report Saving and Distribution:
- Optionally save the report locally as a .md file.
- Upload the report to Google Drive.
- Send detailed reports and Top 10 workflow lists via Gmail.
- Push Top 10 workflow leaderboard messages through Telegram.

Systems and Services Involved

GitHub: Original source of statistical data.
OpenAI GPT-4o-mini: Intelligent language model generating creator and workflow reports.
Google Gemini (PaLM): Assists in generating workflow leaderboards and content summaries.
Google Drive: Storage for generated report files.
Gmail: Email service for sending reports to designated recipients.
Telegram: Platform for pushing Top 10 workflow leaderboard notifications.
n8n Built-in Nodes: Including HTTP requests, data processing, file read/write, and Markdown conversion.

Target Users and Value

n8n Community Managers: Effortlessly access community activity data and monitor contribution trends.
Workflow Developers and Creators: Understand the impact of their work and encourage continuous innovation.
New Users and Teams: Quickly access popular workflows to enhance automation efficiency.
Data Analysts and Community Operators: Utilize automated reports to support decision-making and community development.

This workflow establishes an intelligent data insight and report automation toolset for the n8n community ecosystem, significantly improving data utilization efficiency and community transparency, thereby fostering a more vibrant and collaborative open-source automation platform environment.