Detect dividend yield traps with Google Sheets, Supabase, OpenAI, Slack, 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 23 nodes and runs on a schedule (every week at 09:00). Along the way it connects Google Sheets, Supabase, Slack and Gmail and 1 more. It also calls 192.168.101.63:5678 over HTTP.
How it runs
Trigger: On a schedule (every week at 09:00).
- Read Dividend Watchlist (Google Sheets): uses Google Sheets
- Prepare Watchlist Context (Code): runs custom JavaScript code
- Get Upcoming Ex-Dividend Data (HTTP Request): calls 192.168.101.63:5678
- Prepare Fundamentals Request (Code): runs custom JavaScript code
- Get Dividend Fundamentals (HTTP Request): calls 192.168.101.63:5678
- Normalize Fundamentals (Code): runs custom JavaScript code
- Merge Calendar and Fundamentals (Code): runs custom JavaScript code
- Calculate Dividend Sustainability (Code): runs custom JavaScript code
- Calculate Yield Trap Risk (Code): runs custom JavaScript code
- Identify Yield Trap Red Flags (Code): runs custom JavaScript code
…plus 12 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 (9)
- Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Supabase
n8n-nodes-base.supabase - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
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…