Detect NSE options anomalies with Supabase, OpenAI, Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on a schedule (every 30 minutes). Along the way it connects Google Sheets, Supabase, OpenAI and Gmail. It also calls 192.168.101.63:5678 over HTTP.
How it runs
Trigger: On a schedule (every 30 minutes).
- Read NSE Watchlist (Google Sheets): uses Google Sheets
- Prepare Watchlist Symbols (Code): runs custom JavaScript code
- Fetch NSE Option Chain (HTTP Request): calls 192.168.101.63:5678
- Normalize Option Contracts (Code): runs custom JavaScript code
- Fetch Historical Option Data (Supabase): get many
- Calculate Option Anomaly (Code): runs custom JavaScript code
- Filter Anomalous Contracts (If): checks a condition and branches into true / false
- Save Option Snapshot (Supabase): uses Supabase
- Generate AI Anomaly Interpretation (OpenAI): uses OpenAI
- Save Anomaly Analysis (Supabase): uses Supabase
…plus 3 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 (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Supabase
n8n-nodes-base.supabase - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs every 30 minutes to scan an NSE options watchlist from Google Sheets, fetch option chain data via HTTP, compare it with historical snapshots in Supabase, generate an OpenAI interpretation for anomalies, log results to Google…