Manage subscription renewals with Supabase, Gmail, and a payment API

by WeblineIndia ✓ · 1 views · created 2026-09-11 · CRM

What this workflow does

This workflow has 12 nodes and runs on a schedule (every day at 09:00). Along the way it connects Gmail and Supabase. It also calls jsonplaceholder.typicode.com over HTTP.

How it runs

Trigger: On a schedule (every day at 09:00).

1. Get Current Date (Date & Time): formats or calculates dates
2. Check Expiring Subscriptions (Supabase): get many
3. Check Subscription Active (If): checks a condition and branches into true / false
4. Check Expiring Within 3 Days (If): checks a condition and branches into true / false
5. Send Renewal Reminder (Gmail): uses Gmail
6. Send Payment Info to API (HTTP Request): calls jsonplaceholder.typicode.com (POST)
7. Add hasId Flag (Code): runs custom JavaScript code
8. Check Payment Status (If): checks a condition and branches into true / false
9. Update Subscription Active (Supabase): update
10. Send Payment Failure Email (Gmail): uses Gmail

…plus 1 more step. See the full node list below.

Services it uses

GmailSupabase

HTTP calls to: jsonplaceholder.typicode.com

Before you upgrade to n8n 3.0

Nodes used (7)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Date & Timen8n-nodes-base.dateTime
• Gmailn8n-nodes-base.gmail
• Ifn8n-nodes-base.if
• Supabasen8n-nodes-base.supabase
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code

From the author

Quick overview This workflow runs daily to check subscription records in Supabase, email renewal reminders via Gmail for subscriptions expiring within three days, post payment details to an HTTP API, and then update the subscription and send either a renewal…

View the original on n8n.io → Check your own copy