NSE Options Anomaly Detector n8n: Supabase, OpenAI & Gmail

Detect unusual NSE options activity every 30 minutes—then email a clear digest

The NSE Options Anomaly Detector n8n (Supabase, OpenAI & Gmail) workflow automatically scans your NSE options watchlist, compares the latest option chain to historical snapshots in Supabase, uses OpenAI to interpret anomalies, logs results to Google Sheets, and sends a Gmail alert digest.

What this workflow does

• Runs on a schedule every 30 minutes.
• Reads your watchlist from Google Sheets and keeps only symbols marked as enabled, including their scan settings.
• Fetches the latest option chain data for each enabled symbol via a configured HTTP request endpoint, then normalizes contracts into a consistent structure.
• Compares against historical snapshots in Supabase and calculates anomaly signals such as volume ratio, open-interest ratio, and a z-score to flag anomalous contracts.
• For anomalies: saves the full option snapshot to Supabase, then asks OpenAI for a concise plain-text interpretation (observation, possible interpretation, and a risk note).
• Logs and alerts: writes AI-enriched anomaly records to a Supabase anomalies table, appends anomaly details to Google Sheets, builds a single digest text, and sends it via Gmail.

Use cases

• Spot unusual volume/open-interest shifts in NSE options for an actively monitored watchlist.
• Give SaaS operators and automation teams a hands-off daily workflow for alerts and reporting.
• Catch potentially risk-relevant contract behavior and receive an emailed, human-readable summary.

Technical details

• n8n schedule (every 30 minutes)
• Nodes used: if, code, gmail, supabase, sticky note, http request
• Integrations: Google Sheets (watchlist + log), Supabase (snapshots + anomalies), OpenAI (anomaly interpretations), Gmail (digest email)

Setup requires connecting Google Sheets credentials, updating spreadsheet IDs/tabs, and pointing the HTTP request URL to an endpoint that returns the expected option contract fields.