🧬 RAG & Knowledge Advanced 🧠 AI-powered 🧬 RAG
Product-Video-Generator A 68-step rag & knowledge automation, triggered by schedule, connecting OpenAI (LLM), Google Sheets, HTTP / REST API, OpenRouter (LLM), OpenAI Embeddings, with built-in AI reasoning.
⬇ Download workflow JSON 💡
What this does for your business In plain terms: this turns your documents into a smart Q&A brain. It reads and remembers your content, then answers questions accurately using OpenAI (LLM), Google Sheets, OpenRouter (LLM), OpenAI Embeddings — great for support and internal knowledge.
🚀 Deploy this workflow Deploy this automation in minutes Log in and we'll walk you through every key step by step, then deploy it for you.
Get started free Log in 🏗️ Architecture diagram The real node graph exported from n8n — triggers (green), AI nodes (violet), services and logic — laid out as they run.
▶ Trigger: Start Daily … scheduleTrigger 🧠 AI Agent: Generate Cr… agent 🧠 Tool: Inject Creative… toolThink 🧠 LLM: Generate Raw Ide… lmChatOpenAi 🧠 Parse AI Output (Idea… outputParserStructu… 📊 Save Idea & Metadata … googleSheets 🧠 AI Agent: Generate De… agent 🧠 LLM: Draft Video Prom… lmChatOpenAi 🧠 Tool: Refine and Vali… toolThink 🧠 Parse Structured Vide… outputParserStructu… • Extract Individual Sc… code 🌐 Generate Video Clips … httpRequest • Wait for Clip Generat… wait 🌐 Retrieve Video Clips httpRequest 🌐 Generate ASMR Sound (… httpRequest • Wait for Sound Genera… wait 🌐 Retrieve Final Sound … httpRequest • List Clip URLs for St… code 🌐 Merge Clips into Fina… httpRequest • Wait for Video Render… wait 🌐 Retrieve Final Merged… httpRequest 📊 URL Final Video googleSheets • Assign Social Media I… set 📊 Get my video googleSheets 🌐 Upload Video to Blota… httpRequest 🌐 INSTAGRAM httpRequest 🌐 YOUTUBE httpRequest 🌐 TIKTOK httpRequest 🌐 LINKEDIN httpRequest 🌐 BLUESKY httpRequest 📊 Update Production googleSheets 🌐 TWITTER httpRequest 🧠 OpenRouter Chat Model1 lmChatOpenRouter • Pinecone Vector Store1 vectorStorePinecone 🧬 Embeddings OpenAI1 embeddingsOpenAi • Pinecone Vector Store vectorStorePinecone 🧬 Embeddings OpenAI embeddingsOpenAi 🧠 OpenRouter Chat Model lmChatOpenRouter • If if ▶ Trigger: Start Daily … scheduleTrigger 🧠 AI Agent: Generate Cr… agent 🧠 Tool: Inject Creative… toolThink 🧠 Parse AI Output (Idea… outputParserStructu… 📊 Save Idea & Metadata … googleSheets 🧠 AI Agent: Generate De… agent 🧠 Tool: Refine and Vali… toolThink 🧠 Parse Structured Vide… outputParserStructu… • Extract Individual Sc… code • Wait for Clip Generat… wait 🌐 Retrieve Video Clips1 httpRequest 🌐 Generate ASMR Sound (… httpRequest • Wait for Sound Genera… wait 🌐 Retrieve Final Sound … httpRequest 🌐 Generate Video Clips … httpRequest • List Clip URLs for St… code 🌐 Merge Clips into Fina… httpRequest • Wait for Video Render… wait 🌐 Retrieve Final Merged… httpRequest 📊 URL Final Video1 googleSheets 📊 Get my video1 googleSheets • Assign Social Media I… set 🌐 Upload Video to Blota… httpRequest 🌐 INSTAGRAM1 httpRequest 🌐 YOUTUBE1 httpRequest 🌐 TIKTOK1 httpRequest 🌐 LINKEDIN1 httpRequest 🌐 BLUESKY1 httpRequest 🌐 TWITTER1 httpRequest ⚙️ How it works Trigger: Start Daily Content Generation · scheduleTrigger Tool: Inject Creative Perspective (Idea) · toolThink LLM: Generate Raw Idea (GPT-4.1) · lmChatOpenAi Parse AI Output (Idea, Environment, Sound) · outputParserStructured LLM: Draft Video Prompt Details (GPT-4.1) · lmChatOpenAi Tool: Refine and Validate Prompts1 · toolThink Parse Structured Video Prompt Output · outputParserStructured OpenRouter Chat Model1 · lmChatOpenRouter Embeddings OpenAI1 · embeddingsOpenAi Embeddings OpenAI · embeddingsOpenAi OpenRouter Chat Model · lmChatOpenRouter Trigger: Start Daily Content Generation1 · scheduleTrigger Tool: Inject Creative Perspective (Idea)1 · toolThink Parse AI Output (Idea, Environment, Sound)1 · outputParserStructured 💼 Business analysis 🎯
Business use case Builds a retrieval-augmented knowledge system: content is embedded into a vector store and served back as grounded, citeable answers. Ideal for support deflection, internal knowledge bases, and AI assistants that must stay factual.
📈
Market need Generic chatbots hallucinate; companies need answers grounded in their own documents. RAG is the proven pattern, and a working pipeline is scarce and valuable.
💰
Market value RAG assistant implementations typically run $5,000–$20,000 bespoke. Packaged, it underpins support-deflection tools that sell for $99–$999/mo.
🧩 Integrations & stack 🧠 OpenAI (LLM) 📊 Google Sheets 🌐 HTTP / REST API 🧠 OpenRouter (LLM) 🧬 OpenAI Embeddings
Node types scheduleTrigger, agent, toolThink, lmChatOpenAi, outputParserStructured, googleSheets, code, httpRequest, wait, set, lmChatOpenRouter, vectorStorePinecone, embeddingsOpenAi, if Workflow ID VLHDLisL1Qs2fi1L