Automate n8n Creators Leaderboard Reporting with AI & Google

What this workflow does

This workflow automatically pulls data about top n8n workflow creators and their workflows from a GitHub repository.
It joins the data, uses AI to write a neat report, and sends it by email, saves it in Google Drive, and shares on Telegram.
This removes manual work and gives fresh, daily ranked info about popular creators and their workflows.

It takes several raw stats files in JSON, processes and sorts them, then creates a detailed markdown report with charts.
The report highlights the top 10 creators and top 50 workflows by weekly user engagement.

Who should use this workflow

This is useful for community managers who want clear daily stats about active n8n users.
It fits people who like to save time and get reliable fresh data without errors or delays.

Developers interested in AI content generation combined with data reports will also find it helpful.
Users who want to share automated updates across email and Telegram channels are good candidates.

Tools and services used

• GitHub: Hosts the JSON files with workflow and creator stats.
  
• OpenAI GPT-4o Mini: Generates text report in markdown.
  
• Google Gemini: Helps create summary lists and community insights.
  
• Google Drive API: Saves the final reports for backup and sharing.
  
• Gmail API: Sends the report as an email.
  
• Telegram Bot API: Posts summary messages to Telegram channels.
  

Inputs → Processing Steps → Output

Inputs

• Raw JSON stats files of creators and workflows from GitHub.
  
• API Keys for OpenAI, Google Gemini, Google Drive, Gmail, and Telegram.
  
• Configuration data like usernames, emails, folder IDs, and file paths.
  

Processing Steps

• Fetch JSON files using HTTP requests.
  
• Parse and format JSON into arrays.
  
• Split arrays into individual data items for sorting.
  
• Sort creators and workflows by weekly inserter numbers.
  
• Limit results: top 10 creators and top 50 workflows.
  
• Prepare structured data sets for creators and workflows.
  
• Merge creators and workflows on matching usernames.
  
• Aggregate data for AI report generation.
  
• Run AI agents to write markdown reports and summaries.
  
• Convert markdown to HTML and text file formats.
  
• Save the report locally and upload to Google Drive.
  
• Send email via Gmail with HTML content.
  
• Send workflow summaries via Telegram bot messages.
  

Output

• A daily markdown report of top n8n creators and workflows.
  
• HTML email with the report content.
  
• Google Drive backup file of the report.
  
• Telegram messages summarizing top workflows.
  

Beginner step-by-step: How to use this workflow in n8n production

Step 1: Import the workflow

1. Download the workflow file using the "Download" button on this page.
   
2. Open n8n editor and choose "Import from File".
   
3. Select the downloaded workflow file to add it to n8n.
   

Step 2: Add credentials

1. In n8n, open the Credentials section.
   
2. Add OpenAI API Key for GPT-4o Mini.
   
3. Add Google Gemini API credentials.
   
4. Set up Google Drive OAuth credentials.
   
5. Connect Gmail account via OAuth.
   
6. Enter Telegram Bot Token and chat/channel IDs.
   

Step 3: Configure workflow inputs

1. Check the Set Node with global variables to make sure URLs and filenames match the GitHub repo.
   
2. Update any email addresses or folder IDs to your own.
   
3. Make sure local file paths in Read/Write File Node exist and are writable.
   

Step 4: Test the workflow

1. Run the workflow manually using the Execute Workflow Trigger Node.
   
2. Check output at each node panel for data correctness.
   

Step 5: Activate the workflow

1. Enable the Schedule Trigger Node to run daily at 10 PM or change the interval.
   
2. After activation, the workflow runs automatically and sends reports.
   

Following these steps will get the workflow working quickly in your n8n environment.

For self-hosting or advanced setup, see self-host n8n for network and credential tips.

Customization ideas

• Change schedule frequency in the Schedule Trigger Node for reports hourly or weekly.
  
• Add more creator stats like GitHub followers or social media data for a richer profile.
  
• Insert Slack or other chat notifications after report generation.
  
• Disable Google Drive or email if local saving is preferred.
  
• Switch AI models between OpenAI and Google Gemini by updating credentials and nodes.
  

Troubleshooting common issues

• HTTP Request errors 404 or no data: Double check GitHub URL and filenames in global variables.
  
• AI Agent fails or empty reports: Confirm OpenAI API keys are valid and within limits.
  
• Email fails to send: Reauthorize Gmail, verify email addresses, test with simple messages.
  

Pre-production checklist

• Confirm all API credentials are active and correctly set in n8n.
  
• Test GitHub fetch steps separately to be sure JSON returns properly.
  
• Run the workflow manually once to watch progression and output.
  
• Ensure local folders for saving files have write permission.
  
• Review AI-generated report for completeness.
  

Deployment guide

Enable the Schedule Trigger Node for auto daily runs.

From time to time, check logs inside n8n to catch API or network issues early.

If using self-host n8n, confirm network access to APIs.

No complex deployment steps needed after import and config.

Summary and results

✓ Saves hours daily by automating data gathering and report creation.
✓ Provides clear, accurate, and fresh stats about top n8n creators and workflows.
✓ Delivers easy-to-read markdown and HTML reports via email and Telegram.
✓ Reduces errors and delays that happen with manual processing.
✓ Flexible to customize reporting frequency and data fields.