Analyze YouTube videos with GPT-4o-mini and get relevance-ranked insights

Description

Submit up to 3 YouTube video URLs using a simple form and the workflow handles everything automatically. It fetches each video's title, channel, views, and duration from YouTube, submits each video to WayinVideo for accurate speaker-labeled transcription, then sends the transcript to GPT-4o-mini for a 6-field analysis tailored to your niche. Every video is logged to Google Sheets and a single Gmail report arrives sorted by relevance score when all videos are processed. Built for content marketers, SEO strategists, and research teams who want structured intelligence from YouTube videos — not just auto-captions.

---

What This Workflow Does

- Fetches real YouTube metadata — Pulls title, channel name, view count, duration, and publish date from the YouTube Data API for each video submitted - Transcribes with speaker labels — Submits each video to WayinVideo for accurate transcription grouped by speaker, not just a flat block of auto-captions - Falls back to video description — If the transcript is empty or too short, the workflow automatically uses the video description so the analysis never fails silently - Scores each video for your niche — GPT-4o-mini rates every video from 1–10 on relevance to your specific industry so you know which videos are worth acting on - Identifies competitor content gaps — For every video, GPT surfaces one thing the video did not cover that would make it more useful for your niche — ready to use as a content brief - Logs every video to Google Sheets — Appends a 15-column row per video with metadata, summary, key topics, best quote, target audience, and relevance score - Sends one Gmail report sorted by relevance — All analyzed videos arrive in a single email ranked from most to least relevant to your niche

---

Setup Requirements

Tools Needed - n8n instance (self-hosted or cloud) - Google Cloud account with YouTube Data API v3 enabled - WayinVideo account with API access - OpenAI account with GPT-4o-mini API access - Google Sheets (one sheet with a tab named YouTube Intelligence) - Gmail account (the account you want to receive the report)