{"product_id":"nse-options-anomaly-detector-n8n-supabase-openai-gmail","title":"NSE Options Anomaly Detector n8n: Supabase, OpenAI \u0026 Gmail","description":"\u003ch3\u003eDetect unusual NSE options activity every 30 minutes—then email a clear digest\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eNSE Options Anomaly Detector n8n (Supabase, OpenAI \u0026amp; Gmail)\u003c\/strong\u003e workflow automatically scans your NSE options watchlist, compares the latest option chain to historical snapshots in \u003cstrong\u003eSupabase\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to interpret anomalies, logs results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a \u003cstrong\u003eGmail\u003c\/strong\u003e alert digest.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e every 30 minutes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your watchlist from Google Sheets\u003c\/strong\u003e and keeps only symbols marked as \u003cem\u003eenabled\u003c\/em\u003e, including their scan settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches the latest option chain data\u003c\/strong\u003e for each enabled symbol via a configured \u003cstrong\u003eHTTP request\u003c\/strong\u003e endpoint, then normalizes contracts into a consistent structure.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares against historical snapshots in Supabase\u003c\/strong\u003e and calculates anomaly signals such as \u003cstrong\u003evolume ratio\u003c\/strong\u003e, \u003cstrong\u003eopen-interest ratio\u003c\/strong\u003e, and a \u003cstrong\u003ez-score\u003c\/strong\u003e to flag anomalous contracts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFor anomalies:\u003c\/strong\u003e saves the full option snapshot to \u003cstrong\u003eSupabase\u003c\/strong\u003e, then asks \u003cstrong\u003eOpenAI\u003c\/strong\u003e for a concise plain-text interpretation (observation, possible interpretation, and a risk note).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs and alerts:\u003c\/strong\u003e 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 \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSpot unusual volume\/open-interest shifts in \u003cstrong\u003eNSE options\u003c\/strong\u003e for an actively monitored watchlist.\u003c\/li\u003e\n  \u003cli\u003eGive \u003cstrong\u003eSaaS operators\u003c\/strong\u003e and automation teams a hands-off daily workflow for alerts and reporting.\u003c\/li\u003e\n  \u003cli\u003eCatch potentially risk-relevant contract behavior and receive an emailed, human-readable summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n schedule\u003c\/strong\u003e (every 30 minutes)\u003c\/li\u003e\n  \u003cli\u003eNodes used: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003esupabase\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (watchlist + log), \u003cstrong\u003eSupabase\u003c\/strong\u003e (snapshots + anomalies), \u003cstrong\u003eOpenAI\u003c\/strong\u003e (anomaly interpretations), \u003cstrong\u003eGmail\u003c\/strong\u003e (digest email)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSetup requires connecting \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e credentials, updating spreadsheet IDs\/tabs, and pointing the \u003cstrong\u003eHTTP request URL\u003c\/strong\u003e to an endpoint that returns the expected option contract fields.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114712420531,"sku":"N8N-20003","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZFS5Z-WtjaFyEbaY4qUBU_s53d6WWF.png?v=1790586967","url":"https:\/\/buyflowscripts.com\/products\/nse-options-anomaly-detector-n8n-supabase-openai-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}