Discover & analyze n8n workflows from GitHub with OpenAI and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 14 nodes and runs on a schedule (every day). Along the way it connects Notion, OpenAI Chat Model and Google Sheets. It also calls api.github.com over HTTP.
How it runs
Trigger: On a schedule (every day).
- Config (Edit Fields (Set)): sets or maps fields
- GitHub Search (HTTP Request): calls api.github.com
- Split Results (Split Out): splits a list into separate items
- Fetch Workflow JSON (HTTP Request): calls an HTTP API
- Process Workflows (Code): runs custom JavaScript code
- Aggregate: combines items into one
- Prepare AI Analysis (Code): runs custom JavaScript code
- AI Analysis (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Merge AI Results (Code): runs custom JavaScript code
- Save to Google Sheets (Google Sheets): append or update
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.github.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Analysis1 (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Analysis1 (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- Notion
n8n-nodes-base.notion - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets
From the author
🧠 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,…