Templates / Discover & analyze n8n workflows from GitHub with OpenAI and Google Sheets

Discover & analyze n8n workflows from GitHub with OpenAI and Google Sheets

Needs changes

by Yusuke ✓ · 407 views · created 2025-11-05 · Market Research, AI Summarization

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What 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).

  1. Config (Edit Fields (Set)): sets or maps fields
  2. GitHub Search (HTTP Request): calls api.github.com
  3. Split Results (Split Out): splits a list into separate items
  4. Fetch Workflow JSON (HTTP Request): calls an HTTP API
  5. Process Workflows (Code): runs custom JavaScript code
  6. Aggregate: combines items into one
  7. Prepare AI Analysis (Code): runs custom JavaScript code
  8. AI Analysis (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
  9. Merge AI Results (Code): runs custom JavaScript code
  10. Save to Google Sheets (Google Sheets): append or update

…plus 1 more step. See the full node list below.

Services it uses

NotionOpenAI Chat ModelGoogle Sheets

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.0Replace 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)

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,…

Excerpt from Yusuke's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.