Generate daily stock market insights with Alpha Vantage, Google Gemini AI and Slack
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model and Slack. It also calls alphavantage.co over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Market Data (HTTP Request): calls alphavantage.co
- Calculate Market Sentiment (Code): runs custom JavaScript code
- API Rate Limit Guard (Wait): pauses before continuing
- Sanitize Stock Ticker (Code): runs custom JavaScript code
- Get Ticker News Context (HTTP Request): calls an HTTP API
- Keep Top 3 Headlines (Limit): keeps the first few items
- Generate Financial Insight (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- Format Slack Report (Edit Fields (Set)): sets 2 fields: final_report, formatted_timestamp
- Post to Portfolio Channel (Slack): uses Slack
Services it uses
HTTP calls to: alphavantage.co
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 (9)
- Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Limit
n8n-nodes-base.limit - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack
From the author
Automated Daily Stock Market Insight Generator > Alpha Vantage, Google Gemini AI and Slack Integration --- This n8n workflow provides an end-to-end solution for automated financial analysis. By combining real-time market data with generative AI, it…