Discover & analyze n8n workflows from GitHub with OpenAI and Google Sheets
π§ Overview Discover and analyze the most valuable community-built n8n workflows on GitHub. This automation searches public repositories, analyzes JSON workflows using AI, and saves a ranked report to Google Sheets β ...
Template notes
π§ Overview Discover and analyze the most valuable community-built n8n workflows on GitHub. This automation searches public repositories, analyzes JSON workflows using AI, and saves a ranked report to Google Sheets β including summaries, use cases, difficulty, stars, node count, and repository links.
---
βοΈ How It Works 1. Search GitHub Code API β queries for extension:json n8n and splits results 2. Fetch & Parse β downloads each candidate fileβs raw JSON and safely parses it 3. Extract Metadata β detects AI-powered flows and collects key node information 4. AI Analysis β evaluates the top N workflows (description, use case, difficulty) 5. Merge Insights β combines AI analysis with GitHub data 6. Save to Google Sheets β appends or updates by workflow name
---
𧩠Setup Instructions (5β10 min) - Open Config node and set: - searchquery β e.g., "openai" extension:json n8n - maxresults β number of results to fetch (1β100) - aianalysistop β number of workflows analyzed with AI - SPREADSHEETID, SHEETNAME β Google Sheets target - Add GitHub PAT via HTTP Header Credential: - Authorization: Bearer <YOURTOKEN> - Connect OpenAI Credential to OpenAI Chat Model - Connect Google Sheets (OAuth2) to Save to Google Sheets - (Optional) Enable Schedule Trigger to run weekly for automatic updates
> π‘ Tip: If you need to show literal brackets, use backticks like <example> (no HTML entities needed).
---
π Use Cases 1) Trend Tracking for AI Automations - Goal: Identify the fastest-growing AI-powered n8n workflows on GitHub. - Output: Sorted list by stars and AI detection, updated weekly.