Transform YouTube Transcripts to Content Assets with AI, Youtube-transcript.io and Google Sheets
For content creators, marketers, and video strategists who want to transform YouTube competitors' video transcripts into production-ready content assets using AI-powered automation.
Overview
This template demonstrates two approaches to YouTube transcript extraction and AI content generation: automated Google Sheets monitoring for batch processing, and direct webhook API calls for on-demand extraction. The workflow includes intelligent parsing, metadata extraction, and AI-powered content transformation.
Key Features
Dual Workflow Architecture
- Google Sheets integration for automated monitoring and batch processing
- Webhook endpoint for real-time API access and instant responses
- Both paths share core extraction logic while serving different use cases
Smart YouTube Parsing
- Extracts video IDs from multiple URL formats (youtube.com, youtu.be, embed)
- Regex-based parsing handles edge cases reliably
- Graceful error handling for invalid URLs
Rich Metadata Extraction
- Video title, channel name, and publish date
- Duration and category information
- Transcript text with full timestamp data
- Fallback handling for videos without transcripts
AI Content Generation
- Transforms raw transcripts into structured content assets
- Generates Veo3-optimized scripts (8-second scene format)
- Creates SEO-optimized titles, thumbnail concepts, tags, descriptions
- Includes virality optimization suggestions (hooks, CTAs)
- Uses OpenRouter for flexible LLM selection
Structured Output Parsing
- Custom code nodes parse AI responses into consistent formats
- Organized by content type (Script, Titles, Thumbnails, Tags, etc.)
- Ready for direct insertion into Google Sheets or API responses
Technical Implementation
Nodes Used
- Google Sheets (Trigger & Operations)
- Webhook (Trigger & Response)
- HTTP Request (YouTube Transcript API)
- Code (JavaScript for parsing)
- LangChain LLM Chain (Content generation)
- OpenRouter Chat Model
External Dependencies
- YouTube Transcript API (youtube-transcript.io or similar)
- Google Sheets API credentials
- OpenRouter API access
Use Cases
- Content Repurposing: Transform successful videos into new content formats
- Competitive Analysis: Batch analyze competitor video strategies
- Research & Documentation: Build searchable transcript databases
- Accessibility: Generate captions and text alternatives
- SEO Analysis: Extract and analyze video content at scale
- Content Strategy: Develop data-driven video concepts
Setup Requirements
- YouTube Transcript API credentials
- Google Sheets with specified column structure (for automated workflow)
- OpenRouter API key for AI content generation
- n8n instance (cloud or self-hosted)
Customization Options
The workflow is designed for easy extension:
- Swap AI providers by changing the LangChain model node
- Modify prompt engineering in the Chain LLM nodes
- Add additional parsing logic in Code nodes
- Connect to databases, CMS, or other storage solutions
- Integrate text analysis, summarization, or translation steps
- Add notification systems for workflow completion
Need Help?