AutomationMart
Home/Browse/Discover & analyze n8n workflows from GitHub with OpenAI and Google Sheets
n8n

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

n8nn8n14 modulesv1.0
SlackGoogle SheetsOpenAIGitHub

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 i

At a glance

Discover & analyze n8n workflows from GitHub with OpenAI and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Google Sheets, OpenAI, GitHub. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, Google Sheets, OpenAI, GitHub
Modules
14
Price
Free
Version
v1.0
Discover & analyze n8n workflows from GitHub with OpenAI and Google Sheets workflow diagram

About this workflow

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. 2) Internal Workflow Benchmarking - Goal: Compare your organization’s workflows against top public examples. - Output: Difficulty, node count, and AI usage metrics in Google Sheets. 3) Market Research for Automation Agencies - Goal: Discover trending integrations and tool combinations (e.g., OpenAI + Slack). - Output: Data-driven insights for client projects and content planning. --- 🧪 Notes & Best Practices - 🔐 No hardcoded secrets — use n8n Credentials - 🧱 Works with self-hosted or cloud n8n - 🧪 Start small (maxresults = 10) before scaling - 🧭 Use “AI Powered” + “Stars” columns in Sheets to identify top templates - 🧩 Uses only Markdown sticky notes — no HTML formatting required --- 🔗 Resources - GitHub (template JSON): github-workflow-finder-ai.json

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Summarize emails with ChatGPT and store on a Google Sheet

This template logs new emails in Google Sheets with generated AI summarizes using ChatGPT for streamlined email management and record-keeping.

Free

Summarize youtube videos from transcript for social media

YouTube Video Summarizer for Social Media Turn any YouTube video into a short, structured summary using AI — perfect for content creators, marketers, or social media managers. --- 🔧 What We Built We created a no-code automation in n8n that: - Accepts a YouTube Video ID via a form - Fetches the video transcript using an external API - Summarizes the transcript using AI (Google Gemini) - Automatically saves the summary to Google Docs for team use --- 🧩 Flow Overview | Step |

Free

Create Facebook posts and images with Google Gemini and Facebook Graph API

This n8n template automates the creation of professional Facebook posts and visually striking illustrations directly from simple raw text. If you want to maintain a consistent social media presence without spending hours writing copy and designing images, this workflow is perfect for you. How it works Trigger & Configuration: The workflow begins with your raw text and brand guidelines, configured entirely within a single Set Context node. AI Copywriting: A Google Gemini Agent analyzes the inpu

Free

Automatically create YouTube metadata with AI

This n8n workflow automates YouTube video metadata generation using AI. It extracts video transcripts, analyzes content, and produces optimized titles, descriptions, tags, hashtags, and call-to-action elements. Additionally, the workflow integrates affiliate and promotional links to enhance overall video performance. Key Features Automated Metadata Generation Utilizes an AI agent integrated with OpenAI GPT-4 to generate engaging metadata based on the provided video transcript. SEO and Engagement

Free

Monitor Google keyword rankings and share on Slack

Track your Google keyword rankings effortlessly with a prebuilt Browse AI robot. This template fetches the top 10 rankings, logs the data into a Google Sheet, and instantly shares the information with your team on Slack. Ensure your robot is configured to fetch 10 rankings for optimal performance.

Free

Send Slack messages for new Pipedrive deals

Stay on top of your sales pipeline by receiving instant notifications! This template ensures that every time a new deal is created in Pipedrive, a message is automatically sent to your designated Slack channel. Streamline your communication and keep your team informed about new opportunities, enhancing collaboration and responsiveness in your sales process.

Free

Generate document drafts from PDFs using Google Drive, GPT-4 & notifications

Automate Drafts From Google Drive This workflow automates the end-to-end process of extracting and summarizing information from PDFs stored in a specific Google Drive folder. When a new PDF or any binary data is added, the workflow is triggered and begins by downloading and processing the PDF to extract all available text. If multiple PDFs are detected, their content is aggregated into a single, combined dataset. This automation eliminates the time consuming task of manually reading, taking not

Free

Chat with GitHub API documentation: RAG-powered chatbot with Pinecone & OpenAI

This workflow demonstrates a Retrieval Augmented Generation (RAG) chatbot that lets you chat with the GitHub API Specification (documentation) using natural language. Built with n8n, OpenAI's LLMs and the Pinecone vector database, it provides accurate and context-aware responses to your questions about how to use the GitHub API. You could adapt this to any OpenAPI specification for any public or private API, thus creating a documentation chatbout that anyone in your company can use. How it works

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free