KEEP LEARNING
Build the bigger picture.
The Workflow Engineer connects individual n8n concepts to testing, deployment and running a complete workflow.
Showcase > Content & AI
277-node n8n workflow using OpenAI, Anthropic, Qdrant, and Brave Search to scan stocks, research, and generate YouTube scripts.
A production-grade, 277-node automation system that transforms raw financial data into polished YouTube market analysis scripts. This three-part pipeline demonstrates what is possible when you combine multiple AI models, vector-store retrieval, and relentless orchestration logic within n8n. It is the kind of workflow that replaces an entire content production team.
| Nodes | Category | Complexity | Key Integrations |
|---|---|---|---|
| 277 | Content Creation & AI | Expert | Finviz, Alpha Vantage, OpenAI, Anthropic, Gemini, Mistral, Brave Search, Qdrant, Google Sheets |
2-3 hours including financial API setup, vector store initialization, Redis configuration, and three-part workflow wiring.
Part 1 -- Stock Scanner. The pipeline begins by scanning over 1,000 publicly traded stocks through financial data APIs including Finviz and Alpha Vantage. Each stock passes through a series of Code nodes that calculate technical indicators, filter by configurable criteria (market cap, volume, sector), and normalize the data into a consistent format. AI agents then evaluate the filtered results, scoring each stock on momentum, fundamentals, and sentiment. The top candidates are written to a master Google Sheet that serves as the bridge to Part 2.
Part 2 -- Research Engine. For each high-scoring stock from Part 1, the Research Engine fires off parallel web searches using Brave Search and retrieves relevant context from a Qdrant vector store populated with historical analyses. Cohere embeddings power the RAG pipeline, ensuring the AI retrieves the most semantically relevant prior research. All findings are synthesized by an Anthropic Claude agent into structured research briefs, complete with citations and confidence assessments.
Part 3 -- Script Generator. The final stage consumes the research briefs and transforms them into broadcast-ready YouTube scripts. Multiple AI agents handle different sections: the hook, the analysis body, counterarguments, and the call to action. Redis memory maintains context across the multi-agent conversation, ensuring each section builds logically on the last. The finished script lands in a dedicated Google Sheet, tagged with metadata and ready for recording.
Triggers
AI & Language Models
Data & Integrations
This workflow stands apart on four dimensions:
Tip: Key Techniques Used in This Workflow
- Multi-workflow orchestration -- Three separate workflows communicate through Google Sheets as a shared data layer, enabling independent scaling and debugging of each stage.
- Parallel API batching -- Code nodes manage rate limits and batch HTTP requests to stay within API quotas while maximizing throughput.
- Multi-model routing -- Different AI models handle different task types based on their strengths, a pattern that improves both quality and cost efficiency.
- Accumulative RAG -- The vector store grows with each execution, creating a compounding knowledge advantage over time.
- Redis-backed multi-agent context -- Redis Memory nodes allow multiple AI agents to share conversational context within a single execution, enabling coherent multi-section document generation.
The workflow.json file in this folder can be imported directly into your n8n instance via Settings > Import Workflow.
This build ships with its complete n8n workflow. Download the workflow JSON, then import it in n8n with Workflows, Import from file, and add your own credentials before the first run.
KEEP LEARNING
The Workflow Engineer connects individual n8n concepts to testing, deployment and running a complete workflow.
APPLY IT TO YOUR SYSTEM
Bring the process, the tools involved and an example of where the current workflow gets stuck.