Generate AI stock reports w/ fundamental, technical, & news analysis (Free APIs)
Needs changesWhat this workflow does
This AI workflow has 58 nodes and runs on a schedule (every week at 06:00) (plus 2 other triggers). Along the way it connects Google Gemini Chat Model and OpenAI. It also calls paper-api.alpaca.markets and api.chart-img.com over HTTP.
How it runs
Trigger: On a schedule (every week at 06:00) (plus 2 other triggers).
- Stock List (Edit Fields (Set)): sets 1 field: tickers
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 4 tools (Think, Trends Analysis Tool, Technical Analysis Tool, Fundamental Analysis Tool); memory: Window Buffer Memory; output parser: Structured Output Parser
- Set Ticker for AI Agent (Edit Fields (Set)): sets 1 field: body.ticker
- Split Out: splits a list into separate items
- Buy? (If): checks a condition and branches into true / false
- Generate HTML (HTML): parses or builds HTML
- Execute Workflow (Execute Sub-workflow): calls another n8n workflow
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Buy in Alpaca (HTTP Request): calls paper-api.alpaca.markets (POST)
- Adjust HTML Colors (Code): runs custom JavaScript code
…plus 38 more steps. See the full node list below.
Services it uses
HTTP calls to: paper-api.alpaca.markets, api.chart-img.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (22)
- Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - HTML
n8n-nodes-base.html - Code
n8n-nodes-base.code - Think Tool
@n8n/n8n-nodes-langchain.toolThink - Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Send Email
n8n-nodes-base.emailSend - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Merge
n8n-nodes-base.merge - OpenAI
@n8n/n8n-nodes-langchain.openAi - Edit Fields (Set)
n8n-nodes-base.set - Stop and Error
n8n-nodes-base.stopAndError - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Wait
n8n-nodes-base.wait - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - n8n Form Trigger
n8n-nodes-base.formTrigger - Execute Sub-workflow
n8n-nodes-base.executeWorkflow
From the author
This template deploys a multi-agent system that fully automates advanced stock analysis. It uses a central AI orchestrator to call specialized sub-workflows, synthesizing technical, fundamental, and news sentiment data into a single, actionable report…