Scan multi-timeframe stock breakouts with Google Sheets, GPT-4.1 and Slack
Ready for 3.0What this workflow does
This AI workflow has 15 nodes and runs on a schedule (every 24 hours). Along the way it connects Google Sheets, Slack and OpenAI. It also calls 192.168.101.63:5678 over HTTP.
How it runs
Trigger: On a schedule (every 24 hours).
- Read Breakout Watchlist (Google Sheets): uses Google Sheets
- Prepare Active Watchlist (Code): runs custom JavaScript code
- Fetch Daily OHLCV Data (HTTP Request): calls 192.168.101.63:5678
- Store Daily Market Data (Code): runs custom JavaScript code
- Fetch Weekly OHLCV Data (HTTP Request): calls 192.168.101.63:5678
- Normalize Market Data (Code): runs custom JavaScript code
- Detect Daily Breakout (Code): runs custom JavaScript code
- Build Multi Timeframe Signal (Code): runs custom JavaScript code
- Check Multi Timeframe Confirmation (If): checks a condition and branches into true / false
- Generate AI Breakout Analysis (OpenAI): uses OpenAI
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: 192.168.101.63:5678
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 (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick overview This workflow runs daily to scan a Google Sheets watchlist for active tickers, fetches daily and weekly OHLCV data via an HTTP API, uses OpenAI to summarize confirmed multi-timeframe breakouts, logs signals back to Google Sheets, and posts…