Transform YouTube transcripts to content assets with AI and Google Sheets

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? - LinkedIn: Gerald Akhidenor - Work with me: dominixai.com - My websites: jobmonkey.dev and mediacraftai.com - Email: [email protected]