🧬 RAG & KnowledgeIntermediate🧠 AI-powered🧬 RAG

Viral Generator

A 36-step rag & knowledge automation, triggered by schedule, connecting Google Sheets, HTTP / REST API, OpenAI Embeddings, OpenRouter (LLM), 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 Google Sheets, OpenAI Embeddings, OpenRouter (LLM) — great for support and internal knowledge.

36
Nodes
4
Integrations
35
Connections
Schedule
Trigger

🚀 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🧠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🌐Generate Video Clips …httpRequestWait for Clip Generat…wait🌐Retrieve Video ClipshttpRequest🌐Generate ASMR Sound (…httpRequestWait for Sound Genera…wait🌐Retrieve Final Sound …httpRequestList Clip URLs for St…code🌐Merge Clips into Fina…httpRequestWait for Video Render…wait🌐Retrieve Final Merged…httpRequest📊URL Final VideogoogleSheetsAssign Social Media I…set📊Get my videogoogleSheets🌐Upload Video to Blota…httpRequest🌐INSTAGRAMhttpRequest🌐YOUTUBEhttpRequest🌐TIKTOKhttpRequest🌐LINKEDINhttpRequest🌐BLUESKYhttpRequest📊Update ProductiongoogleSheets🌐TWITTERhttpRequestPinecone Vector StorevectorStorePinecone🧬Embeddings OpenAIembeddingsOpenAi🧠OpenRouter Chat ModellmChatOpenRouter🧠OpenRouter Chat Model1lmChatOpenRouterPinecone Vector Store1vectorStorePinecone🧬Embeddings OpenAI1embeddingsOpenAi

⚙️ How it works

  1. Trigger: Start Daily Content Generation · scheduleTrigger
  2. Tool: Inject Creative Perspective (Idea) · toolThink
  3. Parse AI Output (Idea, Environment, Sound) · outputParserStructured
  4. Tool: Refine and Validate Prompts1 · toolThink
  5. Parse Structured Video Prompt Output · outputParserStructured
  6. Embeddings OpenAI · embeddingsOpenAi
  7. OpenRouter Chat Model · lmChatOpenRouter
  8. OpenRouter Chat Model1 · lmChatOpenRouter
  9. Embeddings OpenAI1 · embeddingsOpenAi
  10. AI Agent: Generate Creative Video Idea · agent
  11. AI Agent: Generate Detailed Video Prompts · agent
  12. Pinecone Vector Store · vectorStorePinecone
  13. Pinecone Vector Store1 · vectorStorePinecone
  14. Save Idea & Metadata to Google Sheets · googleSheets

💼 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

📊Google Sheets🌐HTTP / REST API🧬OpenAI Embeddings🧠OpenRouter (LLM)
Node typesscheduleTrigger, agent, toolThink, outputParserStructured, googleSheets, code, httpRequest, wait, set, vectorStorePinecone, embeddingsOpenAi, lmChatOpenRouterWorkflow IDu5dDKprsdaJqOUja
⬇ Download workflow JSON ← Back to library