# Detect dividend yield traps with Google Sheets, Supabase, OpenAI, Slack, and Gmail

> Quick overview This workflow runs weekly to scan a Google Sheets dividend watchlist, pulls upcoming ex-dividend and fundamentals data via HTTP requests, scores yield-trap risk, uses OpenAI to explain high-risk candidates, stores results in Google Sheets and Supabase, and sends a digest to Slack and Gmail. How it works 1. Runs weekly on a schedule trigger. 2. Reads the stock watchlist from Google Sheets and keeps only rows marked as enabled. 3. Fetches upcoming ex-dividend events from an HTTP endpoint and filters them to enabled symbols with ex-dividend dates in the next 7 days. 4. Fetches dividend fundamentals from an HTTP endpoint, merges them with the calendar candidates, and calculates a dividend sustainability score, a yield-trap risk score/level, and a list of red-flag conditions. 5. For candidates with a risk score of 60 or higher, OpenAI generates a short JSON explanation (caution note, key concern, investor question) based only on the supplied metrics. 6. Logs flagged candidate

- **Domain**: `n8n-workflow-20010.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20010
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20010.n8n.io
- Documentation: https://n8n.io/workflows/20010