YouTube Video Transcript to Structured Metadata
detail.loadingPreview
Automatically extracts YouTube video transcripts, generates structured metadata (main idea, key takeaways) using an LLM, and updates an Airtable base.
About This Workflow
This workflow automates the process of transforming YouTube video content into structured metadata. It begins by fetching new YouTube video links from an Airtable base, then uses a RapidAPI service to retrieve the video transcripts. Subsequently, it leverages a LangChain node (an LLM integration) to extract a main idea and key takeaways from the transcript. Finally, it updates the original Airtable record with this generated metadata and marks it as processed.
Key Features
- Airtable Integration: Reads new video ideas from Airtable and writes back generated metadata.
- YouTube Transcript Extraction: Utilizes a RapidAPI service to get video transcripts.
- LLM-powered Summarization: Employs a LangChain node for intelligent extraction of main ideas and key takeaways.
- Automated Metadata Generation: Creates structured content insights.
- Configurable Schedule: Triggers the workflow at a defined interval (e.g., every 5 minutes).
- Video ID Extraction: Parses YouTube URLs to extract video IDs for API calls.
How To Use
- Trigger: The
Schedule Triggernode initiates the workflow at a set interval. - Data Source: The
Airtablenode queries your Airtable base for new YouTube video entries with specific criteria (e.g., empty status, type 'Youtube Video'). - Video ID Extraction: The
Get Video IDnode extracts the YouTube video ID from the provided URL. - Transcript Retrieval: The
Get video transcriptnode sends the video ID to a RapidAPI endpoint to fetch the video's transcript. - Transcript Aggregation: The
Get All TranscriptsandCombine Transcriptsnodes process the raw transcript data into a single, usable text field. - Metadata Extraction: The
Get Full Transcriptnode prepares the combined transcript for the LLM. TheExtract detailed summarynode uses the LangChain integration to generate a 'Main Idea' and 'Key Takeaways' based on the provided prompt and schema. - Data Structuring: The
Get Main Idea & Key Takeawaysnode maps the LLM's output into distinct fields. - Update Airtable: The
Update Airtablenode writes the generated 'Main Idea' and 'Key Takeaways' back to the corresponding record in your Airtable base and updates the 'Status' field.
Apps Used
Workflow JSON
{
"id": "e404c05e-fdf5-4dc5-8dba-84ae4bb2ccaa",
"name": "YouTube Video Transcript to Structured Metadata",
"nodes": 22,
"category": "Content Creation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: e404c05e-fdf5...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Automated News to Newsletter AI Agents
This workflow automates the process of news aggregation, summarization, and newsletter creation using AI agents.
PDF to Blog Post Generator
Automates the process of converting PDF documents into engaging blog posts, ready for publishing.
Automated Blog Post Generation with AI and WordPress Integration
Automate blog post creation from Google Sheets ideas, using AI for content and image generation, and publishing to WordPress.