AI Agent: n8n Creator & Workflow Leaderboard Reporter

Unlock Actionable Community Insights with this AI Agent

This powerful AI Agent is designed to automatically gather, analyze, and report on the n8n community's top creators and their impactful workflows. It taps into data from the n8n community leaderboard on GitHub, processes it, and then employs Large Language Models (LLMs) like OpenAI's GPT-4o-mini and Google Gemini to generate insightful, structured reports. This agent essentially acts as your automated community analyst, highlighting key trends, popular solutions, and influential contributors within the n8n ecosystem.

Key Features & Abilities

• Automated Data Sourcing: Fetches the latest creator and workflow statistics directly from the n8n community leaderboard GitHub repository.
• Data Processing & Ranking: Parses, sorts, and filters data to identify top-performing creators and workflows based on metrics like weekly/monthly insertions and visitors.
• AI-Powered Report Generation: Leverages an n8n Langchain Agent with OpenAI (GPT-4o-mini) to create comprehensive Markdown reports. The agent is specifically prompted to analyze contributor impact and workflow details.
• AI-Driven Summarization: Uses Google Gemini to generate concise summaries, like a 'Top 10 Workflows' list, from the main report.
• Multi-Channel Distribution: Delivers reports in various formats (Markdown, HTML for email) and through multiple channels: local file saving, Google Drive uploads, Gmail, and Telegram notifications.
• Scheduled & Triggerable: Can be run on a daily schedule or triggered on-demand by other workflows, ensuring timely insights.
• Customizable Reporting: The depth and focus of the AI-generated reports can be fine-tuned by adjusting the system prompts within the Langchain Agent node.
• Insightful Community Analysis: Helps you understand what makes certain workflows popular, identify emerging trends, and recognize key community contributors.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key with access to GPT-4o-mini or a similar model.
• Google Gemini API Key.
• Credentials for Google Drive and Gmail (OAuth2 setup in n8n).
• Telegram Bot Token and Chat ID (optional, for Telegram notifications; typically set as environment variables).
• Access to the n8n community leaderboard data source on GitHub (public, but ensure URLs in the workflow are current).

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure the 'Global Variables' node if the GitHub data source URLs need updating (defaults to https://raw.githubusercontent.com/teds-tech-talks/n8n-community-leaderboard/refs/heads/main/).
4. In the 'gpt-4o-mini' node (labeled 'OpenAI LLM'), select or create your OpenAI credential.
5. In the 'Google Gemini Chat Model' node, select or create your Google Gemini (PaLM) API credential.
6. Configure credentials for the 'Google Drive', 'Gmail Creators & Workflows Report', and 'Gmail Top 10 Workflows List' nodes.
7. If using Telegram, configure the 'Telegram Top 10 Workflows List' node: select/create your Telegram API credential and set the 'Chat ID' parameter (e.g., {{ $env.TELEGRAM_CHAT_ID }}).
8. Review the 'Save creator-summary.md' node's 'File Name' parameter if you wish to change the local save path (ensure write permissions to the specified directory).
9. Customize the email recipients in the 'Gmail' nodes.
10. Adjust the 'Schedule Trigger' node for desired frequency or use the 'When Executed by Another Workflow' trigger.
11. Activate the workflow.