AI Agent for n8n Creators Leaderboard Stats Analysis

What This Automation Does

This workflow gets data about n8n workflow creators and their workflows from GitHub JSON files.

It finds top creators and popular workflows by counting weekly and monthly inserters and visitors.

It joins creator info with their workflow stats by matching usernames.

You can ask it to focus on one creator by giving a username.

Then, it uses an AI agent with OpenAI GPT-4o-mini to write a Markdown report summarizing stats and community trends.

The report is saved as a Markdown file with a timestamp on your local system.

This saves time by doing all data gathering, processing, and report writing automatically.

Who Should Use This Workflow

Any n8n community member who wants to see leaderboard stats without manual work.

Also good for community managers tracking top workflow creators and popular workflows.

No complex setup needed beyond some API keys and file access.

Tools and Services Used

• GitHub: Hosts the JSON data files with creator and workflow stats.
• n8n: Automation platform that runs this workflow.
• OpenAI GPT-4o-mini: AI model that generates the Markdown report.
• Local File System: Stores the Markdown report files.

Beginner step-by-step: How to build this in n8n

Step 1: Import the Workflow

1. Download the workflow file using the Download button on this page.
2. Open the n8n editor.
3. Click on Import from File and select the downloaded workflow file.

Step 2: Configure Credentials and Variables

1. Add OpenAI API credentials in the gpt-4o-mini node settings.
2. Check the Global Variables node and confirm all GitHub URLs and filenames match your data source.
3. If needed, update any user names, email addresses, folder paths, or other IDs in the workflow nodes.

Step 3: Test the Workflow

1. Run the workflow manually to check if it fetches data from GitHub and generates report content.
2. Look at the execution logs for errors and fix any issues.

Step 4: Activate for Production

1. Enable the workflow to listen to triggers, such as chat messages or API calls.
2. Use commands like show me stats for username joe to generate reports.
3. Check the local file path for saved Markdown files after runs.
4. Consider self hosting n8n (self-host n8n) for more control.

Inputs, Processing, and Outputs

Inputs

• Global Variables node has GitHub base URL and filenames for creators and workflows JSON.
• Chat or API trigger node accepts username input for filtering.

Processing Steps

• stats_aggregate_creators and stats_aggregate_workflows HTTP Request nodes get JSON data.
• Parse nodes extract JSON arrays and split them into individual records.
• Sort nodes order creators and workflows by weekly inserter counts.
• Filter node limits data to the requested username.
• Merge node combines creator and workflow info by username.
• Aggregate node packs all filtered data for the AI prompt.
• gpt-4o-mini node generates the Markdown report text.
• Convert to File and Save nodes write the report locally with timestamp.

Outputs

• Markdown report file saved to local disk, named creator-summary.md with date.

Customizations

• Change AI prompt in the gpt-4o-mini node to create HTML or PDF reports instead of Markdown.
• Modify Filter By Creator Username node to support filtering multiple usernames at once.
• Add nodes to upload the report file to cloud storage automatically, such as Google Drive or Amazon S3.
• Switch AI models between OpenAI or the local Ollama Chat Model depending on API compliance.
• Add a Cron node to schedule automatic periodic report generation.

Troubleshooting

HTTP Request Issues

Check GitHub URLs in Global Variables node for accuracy.

Test URLs in a browser to confirm access.

Add retries or error handling to HTTP Request nodes.

AI Agent Issues

Make sure filtered and aggregated data passed to gpt-4o-mini node is complete.

Refine AI prompt for clearer instructions if report is incomplete.

File Saving Problems

Confirm the local save path exists and has write permissions.

Run workflow with correct system access rights.

Pre-Production Checklist

• Check OpenAI API credentials are valid.
• Verify GitHub URLs and JSON filenames are current.
• Test HTTP Request nodes separately.
• Test username filtering with a known creator.
• Run the workflow manually for full end-to-end check.
• Confirm AI output generates proper Markdown reports.
• Ensure file paths and permissions allow report saving.

Deployment Guide

1. Import the workflow file into your n8n editor using Import from File.
2. Set up OpenAI credentials in the gpt-4o-mini node.
3. Update Global Variables node URLs for GitHub data access.
4. Make the workflow active and ready to listen for triggers.
5. Send chat messages or API commands like show me stats for username joe to run the report.
6. Monitor workflow runs in n8n logs for troubleshooting.
7. Find saved Markdown reports on your configured local disk path.

Summary of Results

✓ Automates leaderboard data gathering from GitHub JSON files.

✓ Produces easy to read Markdown reports about workflow creators and usage.

✓ Saves reports locally for review or sharing anytime.

✓ Cuts down hours of manual data collection and analysis work.

✓ Allows filtering to focus on specific community creators.