Track analyst target and rating drift with Yahoo Finance MCP, OpenAI, and Telegram
Ready for 3.0What this workflow does
This AI workflow has 25 nodes and runs on a schedule (every day at 07:00) (plus 1 other trigger). Along the way it connects OpenAI Chat Model and Telegram.
How it runs
Trigger: On a schedule (every day at 07:00) (plus 1 other trigger).
- Settings (Edit Fields (Set)): sets 8 fields: tickers, mcp_url, target_move_pct…
- Ask What The Server Offers (HTTP Request): calls an HTTP API (POST)
- Check The Tools Are There (Code): runs custom JavaScript code
- Read What We Saw Last Time (Data table): get
- Pick The Watchlist (Code): runs custom JavaScript code
- Ask For The Price Targets (HTTP Request): calls an HTTP API (POST)
- Ask For The Ratings (HTTP Request): calls an HTTP API (POST)
- Ask For The Price (HTTP Request): calls an HTTP API (POST)
- Read The Price Targets (Code): runs custom JavaScript code
- Read The Ratings (Code): runs custom JavaScript code
…plus 11 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)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Data table
n8n-nodes-base.dataTable - Merge
n8n-nodes-base.merge - Filter
n8n-nodes-base.filter - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Telegram
n8n-nodes-base.telegram - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow runs every weekday morning, pulls analyst price targets and consensus ratings for a stock watchlist via a self-hosted Yahoo Finance MCP server, stores daily snapshots in an n8n Data Table, and sends a Telegram digest only when…