Send adaptive daily Supabase product pulse emails with Claude and SMTP
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 workflow has 14 nodes and runs on a schedule (every day at 08:00). It uses only n8n's built-in nodes. It also calls api.anthropic.com over HTTP.
How it runs
Trigger: On a schedule (every day at 08:00).
- ⚙️ Config (Edit Fields (Set)): sets 9 fields: supabaseUrl, reportEmail, fromEmail…
- 🗂️ Discover Schema (HTTP Request): calls an HTTP API
- 🧩 Read Schema (Code): runs custom JavaScript code
- 🧠 Plan Queries (HTTP Request): calls api.anthropic.com (POST)
- ✅ Validate & Resolve (Code): runs custom JavaScript code
- 🔎 Run Query (HTTP Request): calls an HTTP API
- 🧮 Collect Results (Code): runs custom JavaScript code
- Found requirement data? (If): checks a condition and branches into true / false
- 🧠 Write Report (HTTP Request): calls api.anthropic.com (POST)
- 🛟 Build Not-Found Email (Code): runs custom JavaScript code
…plus 3 more steps. See the full node list below.
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 - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend - If
n8n-nodes-base.if
From the author
Quick overview This scheduled workflow reads your Supabase project’s live schema, uses Anthropic Claude to plan safe PostgREST queries from a plain-English requirement, computes the requested metrics, and sends a daily pulse email via SMTP with results or a…