u/Medium_Ad7765

Built an n8n pipeline that turns YouTube podcast appearances into qualified sales leads (JSON + FastAPI code inside)

I wanted to find B2B leads for my client : instead of cold-scraping LinkedIn, I look for executives who've already talked publicly about the problems my product solves — by mining podcast transcripts.

Here's the two-workflow pipeline I ended up with (n8n JSON + the FastAPI transcript service ).

Workflow 1 — Podcast discovery

• Reads a list of YouTube channel handles from a Google Sheet
• For each channel, resolves the uploads playlist via the YouTube Data API and pulls every video (auto-paginated, not just the first 50)
• Runs each video through a fast keyword filter (podcast, interview, founder, CEO, panel, etc.) on the title/description
• Anything that doesn't match the keywords still gets a second pass through a small Groq-hosted LLM (Llama 3.1 8B) that classifies it as PODCAST or OTHER — this catches episodes with vague titles that the keyword filter would've missed
• Matches get appended to a "podcast queue" sheet

Workflow 2 — Transcript → lead

• Reads the queued podcast URLs
• Pulls official caption availability from the YouTube Data API, then fetches the actual transcript from a small self-hosted FastAPI wrapper around youtube-transcript-api (works for both manual and auto-generated captions)
• If there's genuinely no captions at all, it's marked no_caption and skipped rather than silently failing
• The transcript goes to an LLM (Gemini Flash Lite in my setup) with a fairly strict prompt: extract the primary guest (not the host), and return a structured JSON profile — name, company, title, whether they look like a decision-maker, a qualification verdict against my ICP, a partnership angle, and a personalization line for outreach
• Everything gets appended to a "qualified leads" sheet, and the source row gets marked Done so nothing gets reprocessed

Sharing the n8n JSON below plus the FastAPI transcript service is on my GitHub.

link : https://github.com/Aimal55/youtubepodcastreseacherwf-