{"product_id":"dividend-yield-trap-scanner-n8n-with-google-sheets-openai","title":"Dividend Yield Trap Scanner (n8n) with Google Sheets, OpenAI","description":"\u003ch3\u003eScan dividend stocks weekly and catch potential yield traps with an n8n + Google Sheets + OpenAI workflow\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eDividend Yield Trap Scanner (n8n)\u003c\/strong\u003e automatically checks your Google Sheets dividend watchlist, evaluates upcoming ex-dividend events and fundamentals, flags higher-risk candidates, and generates an \u003cstrong\u003eOpenAI-backed JSON caution explanation\u003c\/strong\u003e—then publishes results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eSupabase\u003c\/strong\u003e, and sends a weekly digest to \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly\u003c\/strong\u003e via an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003eReads your Google Sheets \u003cem\u003eWatchlist\u003c\/em\u003e tab and keeps only rows marked \u003cstrong\u003eenabled\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls an \u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e to fetch upcoming \u003cstrong\u003eex-dividend\u003c\/strong\u003e dates, then filters candidates to those with ex-dividend dates in the \u003cstrong\u003enext 7 days\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls a second \u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e for \u003cstrong\u003edividend fundamentals\u003c\/strong\u003e, merges results with the calendar candidates, and calculates:\n    \u003cul\u003e\n      \u003cli\u003ea \u003cstrong\u003edividend sustainability score\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003eyield-trap risk score\/level\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ea list of \u003cstrong\u003ered-flag conditions\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eFor candidates with a \u003cstrong\u003erisk score of 60+\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a short \u003cstrong\u003eJSON explanation\u003c\/strong\u003e (caution note, key concern, investor question) based only on the supplied metrics.\u003c\/li\u003e\n  \u003cli\u003eLogs flagged results to the Google Sheets \u003cstrong\u003e“Risk Results”\u003c\/strong\u003e tab and inserts the full analysis record into a \u003cstrong\u003eSupabase\u003c\/strong\u003e table.\u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003esorted weekly risk digest\u003c\/strong\u003e to \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e (or a “no-risk” digest if none meet the threshold).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDividend-focused investors maintaining a Google Sheets watchlist and wanting automated weekly screening.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators building a compliance-style reporting workflow around dividend event calendars.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing risk scoring + AI explanations for financial watchlists.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: read watchlist, write to “Risk Results”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP\u003c\/strong\u003e: fetch ex-dividend calendar and dividend fundamentals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: create JSON caution explanations for \u003cstrong\u003erisk score ≥ 60\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupabase\u003c\/strong\u003e: store full analysis records.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e: deliver the weekly digest.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003esupabase\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114709569715,"sku":"N8N-20010","price":67.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PGDHvfxOHh39XiNrLr6mc_H0fJ9R2V.png?v=1790586780","url":"https:\/\/buyflowscripts.com\/products\/dividend-yield-trap-scanner-n8n-with-google-sheets-openai","provider":"N8N Commerce","version":"1.0","type":"link"}