Send re-engagement emails to inactive users with Supabase, Claude and SMTP
Ready for 3.0What this workflow does
This workflow has 8 nodes and runs on a schedule (every day at 09:00). Along the way it connects Supabase. It also calls api.anthropic.com over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00).
- ⚙️ Config (Edit Fields (Set)): sets 4 fields: inactiveDays, mailType, fromEmail…
- Get Email Guidance (3 directions) (Supabase): get many
- Get Inactive Users (Supabase): get many
- 🧠 Claude: Write Email (HTTP Request): calls api.anthropic.com (POST)
- Extract Email (Code): runs custom JavaScript code
- Send Email: sends an email over SMTP
- Mark Re-engaged (Supabase): update
Services it uses
HTTP calls to: api.anthropic.com
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 (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Supabase
n8n-nodes-base.supabase - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend
From the author
Quick Overview This workflow runs daily to find inactive users in Supabase, generates personalized re-engagement emails with Anthropic Claude using brand directions stored in an emailguidance table, sends the emails via SMTP, and updates the user record to…