YouTube Transcript Analysis Agent: Auto-Transcription → AI Analysis → Airtable Storage + Relay & Slack Distribution

Problem:

A content or marketing team was manually pulling YouTube video transcripts, reading through them to extract insights, logging findings, and then distributing summaries to the team via email and Slack, a slow manual process that made analyzing large volumes of video content at scale impossible.

Solution: Built a webhook-triggered n8n pipeline that receives a YouTube video URL, fetches the full transcript via the YouTube Transcript API, passes it to a Transcript AI Agent (powered by RVSCL model with structured output parsing) for deep content analysis and insight extraction, processes the output through a code block for formatting, creates a structured record in Airtable for permanent storage, sends the analysis to Relay via webhook for email distribution, then routes through a conditional, if distribution succeeds it posts a Slack notification to the team, if it fails it handles gracefully with a No Operation path.

Result:

Delivered a fully automated YouTube content intelligence pipeline, any video URL triggers automatic transcription, AI analysis, permanent Airtable logging, Relay email distribution, and Slack team notification, enabling the team to extract and distribute video insights at scale with zero manual effort.