Track gym renewals, inactivity, and check-in streaks with Supabase and WhatsApp
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 11 nodes and runs on a schedule (every day at 08:00). Along the way it connects Supabase and WhatsApp Business Cloud.
How it runs
Trigger: On a schedule (every day at 08:00).
- Set Configuration (Edit Fields (Set)): sets 6 fields: gym_name, whatsapp_phone_number_id, trainer_notify_number…
- Fetch Members (Supabase): get many
- Compute Member Status (Code): runs custom JavaScript code
- Is Expiring Soon? (If): checks a condition and branches into true / false
- Is Inactive? (If): checks a condition and branches into true / false
- Reached New Milestone? (If): checks a condition and branches into true / false
- Send Renewal Reminder (WhatsApp Business Cloud): send
- Notify Trainer - Member Going Cold (WhatsApp Business Cloud): send
- Send Streak Celebration (WhatsApp Business Cloud): send
- Update Milestone Notified (Supabase): update
Services it uses
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)
- Edit Fields (Set)
n8n-nodes-base.set - Supabase
n8n-nodes-base.supabase - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow runs daily to pull gym members from Supabase, calculate membership expiry and check-in activity, and send WhatsApp messages for renewal reminders, trainer inactivity alerts, and check-in streak milestone celebrations. How it works…