Generate institutional-style stock price targets and BUY/HOLD/SELL alerts with ChatGPT and Gemini
Ready for 3.0What this workflow does
This AI workflow has 79 nodes and runs on a schedule (every 3 days at 16:00). Along the way it connects Google Sheets, Telegram, OpenAI and Google Gemini.
How it runs
Trigger: On a schedule (every 3 days at 16:00).
- Read_tickers_from_Sheet (Google Sheets): uses Google Sheets
- loop_over_tickers (Loop Over Items (Split in Batches)): loops over the items in batches
- Build Summary (Code): runs custom JavaScript code
- Cache Lookup (Google Sheets): uses Google Sheets
- Seekingalpha Articles (HTTP Request): calls an HTTP API
- Send a text message (Telegram): uses Telegram
- Check the cache (Code): runs custom JavaScript code
- Clean the news (Code): runs custom JavaScript code
- Is Cache Valid? (If): checks a condition and branches into true / false
- If: checks a condition and branches into true / false
…plus 68 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - XML
n8n-nodes-base.xml - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Telegram
n8n-nodes-base.telegram - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini
From the author
AI Institutional Stock Valuation Engine with Risk Scoring & Scenario Targets A professional-grade AI equity analysis automation built on n8n that ingests live financial data and news, runs it through a dual-LLM valuation engine with a built-in tiebreaker, and…