Convert YouTube videos into published blog articles automatically
Loading workflow…
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Workflow Description
An AI-powered automation that receives YouTube video links via webhook, intelligently processes transcripts with advanced NLP and vector search, and generates polished blog articles using multi-model AI processing, storing results in Google Sheets and notifying your team via Slack.
How it works
- 1.Receive YouTube video URL through webhook and extract transcript content
- 2.Split and embed text using OpenAI embeddings with Pinecone vector database for semantic search
- 3.Process content through intelligent AI agent leveraging context memory and Anthropic capabilities
- 4.Generate professionally formatted article and save to Google Sheets spreadsheet
- 5.Send completion notification to Slack channel with article metadata
Use cases
- Transform long-form YouTube lectures into SEO-optimized blog posts ready for immediate publication
- Automate content repurposing from educational channels and podcasts to your company blog
Requirements
- YouTube access with transcript extraction capability or metadata API integration
- API keys for OpenAI, Anthropic, and Pinecone vector database configuration
- Active Google Sheets document and Slack workspace with message posting permissions
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Nodes Used (12)
Sticky Note
Sticky Note
Webhook Trigger
Webhook
Text Splitter
Text Splitter Character Text Splitter
Embeddings
OpenAI
Pinecone Insert
Vector Store Pinecone
Pinecone Query
Vector Store Pinecone
Vector Tool
Tool Vector Store
Window Memory
Memory Buffer Window
Chat Model
Lm Chat Anthropic
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack
Similar Templates
Intelligent document processing and conversational retrieval
Extract documents from Drive, analyze with OpenAI, save results to Sheets
Intelligent Telegram chatbot with OpenAI-powered responses
Send Google Sheets Data to Slack with Intelligent Agent
Reconcile rent payments from Excel files using AI
Extract Image Data with AI Vision Agent and Save to Google Sheets
Fresh workflows, straight to your inbox
Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.
Email confirmation · Unsubscribe anytime