⚙️Get Youtube Transcript Tool

Workflow Overview: YouTube Video Content Ingestion & Repurposing Tool This workflow functions as a powerful, reusable "tool" or sub-workflow designed to be called by other n8n workflows. Its primary purpose is to take a YouTube video URL, extract a comprehensive set of metadata and the full video transcript, and then systematically archive this information into an Airtable base. It acts as the engine for building a structured content library from YouTube videos, which can then be used for analysis, content repurposing, or knowledge management. Technologies & Automation H2: Technologies Used - n8n: The core automation platform coordinating the entire process. - YouTube API: To fetch official video metadata like title, description, tags, and statistics (views, likes, comments). - Airtable: Serves as the database/content library where all the extracted video information is stored. - Make.com (via Webhook): Used as an external service to fetch the video transcript. - LangChain: The framework used for integrating AI capabilities into the flow. - AI Models (OpenRouter & Google Gemini): Provides the AI processing power for specific tasks within the workflow. H2: Automation Value The workflow automates the highly manual and tedious process of content ingestion. Instead of an employee manually watching a video, copying the transcript, finding all relevant metadata (title, tags, stats), and pasting it into a spreadsheet, this workflow does it all in seconds. Given a single YouTube link, it programmatically retrieves, structures, and stores all associated data, creating a rich, queryable content library in Airtable. This saves significant time, eliminates human error, and enables content strategies at scale. AI Integration Analysis This workflow strategically integrates AI in two distinct, value-adding steps: H3: AI-Powered Data Extraction The Information Extractor node, powered by an OpenRouter model (o4-mini-high), is the first point of AI contact. - How it Integrates: It takes the raw YouTube URL provided to the workflow and uses natural language understanding to reliably extract the unique VIDEO_ID.