Subscription renewal reminders on WhatsApp
Seven days before a client's subscription or membership ends, remind them on WhatsApp and tell your team.
How it works
Trigger: Schedule — every day at 10:00
- Read your Clients sheet (name, phone, plan, renews_on, reminded).
- Keep clients whose renewal date is exactly 7 days away and who haven't been reminded.
- Send a WhatsApp template with their plan and renewal date.
- Mark them as reminded and post the list to your team on Telegram.
Diagram
Trigger App Code
Code
JavaScript used in the Code step — already included in the template below.
// Clients sheet columns: name | phone | plan | renews_on (YYYY-MM-DD) | reminded
// Keeps clients whose renewal is exactly 7 days away and who haven't been reminded yet.
const DAYS_BEFORE = 7;
const target = new Date();
target.setDate(target.getDate() + DAYS_BEFORE);
const day = target.toISOString().slice(0, 10);
return $input.all()
.map((item) => item.json)
.filter((r) => r.phone && String(r.renews_on).slice(0, 10) === day && String(r.reminded).toLowerCase() !== "yes")
.map((r) => ({ json: { ...r, phone: String(r.phone).replace(/[^0-9]/g, "") } }));Build it
Pick your tool — same automation, step by step.
Copy and paste straight into an n8n canvas (Ctrl+V), or download and use Import from File. Then connect your own credentials and replace every YOUR_… placeholder.
Show code (231 lines)
{
"name": "Subscription renewal reminders on WhatsApp (Flowngn)",
"nodes": [
{
"parameters": {
"content": "## Subscription renewal reminders on WhatsApp\nSeven days before a client's subscription or membership ends, remind them on WhatsApp and tell your team.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
"height": 260,
"width": 340
},
"id": "45821f1c-89e8-43ba-a4e7-feb0390d7b0e",
"name": "Setup notes",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-420,
-60
]
},
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 10
}
]
}
},
"id": "45821f1c-89e8-43ba-a4e7-feb0390d7b0e",
"name": "Every day 10:00",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
0,
0
]
},
{
"parameters": {
"operation": "read",
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Clients",
"mode": "name"
},
"options": {}
},
"id": "45821f1c-89e8-43ba-a4e7-feb0390d7b0e",
"name": "Read clients",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
300,
0
]
},
{
"parameters": {
"jsCode": "// Clients sheet columns: name | phone | plan | renews_on (YYYY-MM-DD) | reminded\n// Keeps clients whose renewal is exactly 7 days away and who haven't been reminded yet.\nconst DAYS_BEFORE = 7;\nconst target = new Date();\ntarget.setDate(target.getDate() + DAYS_BEFORE);\nconst day = target.toISOString().slice(0, 10);\n\nreturn $input.all()\n .map((item) => item.json)\n .filter((r) => r.phone && String(r.renews_on).slice(0, 10) === day && String(r.reminded).toLowerCase() !== \"yes\")\n .map((r) => ({ json: { ...r, phone: String(r.phone).replace(/[^0-9]/g, \"\") } }));"
},
"id": "45821f1c-89e8-43ba-a4e7-feb0390d7b0e",
"name": "Renewing in 7 days",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
600,
0
]
},
{
"parameters": {
"operation": "sendTemplate",
"phoneNumberId": "YOUR_PHONE_NUMBER_ID",
"recipientPhoneNumber": "={{ $json.phone }}",
"template": "YOUR_RENEWAL_TEMPLATE|ar",
"components": {
"component": [
{
"type": "body",
"bodyParameters": {
"parameter": [
{
"type": "text",
"text": "={{ $json.name }}"
},
{
"type": "text",
"text": "={{ $json.plan }}"
},
{
"type": "text",
"text": "={{ $json.renews_on }}"
}
]
}
}
]
}
},
"id": "45821f1c-89e8-43ba-a4e7-feb0390d7b0e",
"name": "Send reminder",
"type": "n8n-nodes-base.whatsApp",
"typeVersion": 1,
"position": [
900,
0
]
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Clients",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"phone": "={{ $('Renewing in 7 days').item.json.phone }}",
"reminded": "yes"
},
"matchingColumns": [
"phone"
]
},
"options": {}
},
"id": "45821f1c-89e8-43ba-a4e7-feb0390d7b0e",
"name": "Mark reminded",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1200,
0
]
},
{
"parameters": {
"chatId": "YOUR_CHAT_ID",
"text": "=Renewal reminder sent: {{ $('Renewing in 7 days').item.json.name }} ({{ $('Renewing in 7 days').item.json.plan }}), renews {{ $('Renewing in 7 days').item.json.renews_on }}",
"additionalFields": {
"appendAttribution": false
}
},
"id": "45821f1c-89e8-43ba-a4e7-feb0390d7b0e",
"name": "Tell the team",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1.2,
"position": [
1500,
0
]
}
],
"connections": {
"Every day 10:00": {
"main": [
[
{
"node": "Read clients",
"type": "main",
"index": 0
}
]
]
},
"Read clients": {
"main": [
[
{
"node": "Renewing in 7 days",
"type": "main",
"index": 0
}
]
]
},
"Renewing in 7 days": {
"main": [
[
{
"node": "Send reminder",
"type": "main",
"index": 0
}
]
]
},
"Send reminder": {
"main": [
[
{
"node": "Mark reminded",
"type": "main",
"index": 0
}
]
]
},
"Mark reminded": {
"main": [
[
{
"node": "Tell the team",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": []
}In Make, create a new scenario and add these modules in order:
- Schedule the scenario: Every day 10:00
- Google Sheets › Search Rows
- Tools › Set variable / Iterator + Array aggregator (same logic as the Code step)
- WhatsApp Business Cloud › Send a Template Message
- Google Sheets › Update a Row
- Telegram Bot › Send a Text Message or a Reply
- Every module run uses Make operations — the free plan includes a monthly quota.
- Make's built-in functions (map, sum, formatDate…) can replace most Code steps; for complex logic use a code module.
- Module and step names can differ slightly as Make and Zapier update their apps.
In Zapier, create a new Zap and add these steps in order:
- Schedule by Zapier — Every day 10:00
- Google Sheets — Lookup Spreadsheet Rows (or Code by Zapier)
- Code by Zapier — Run JavaScript (paste the code from the Code section)
- WhatsApp — Send Template Message
- Google Sheets — Update Spreadsheet Row
- Telegram — Send Message
- Zaps with more than two steps need a paid Zapier plan.
- Webhooks, Filters/Paths and Code by Zapier are premium features on some Zapier plans.
- Code by Zapier runs JavaScript: reuse the code shown above, reading inputs from inputData instead of $json.
- Module and step names can differ slightly as Make and Zapier update their apps.
Tips
- Clear the reminded column when a client renews, so next month's reminder goes out.
Related flows
Finance & AdminMedium
Log expenses by texting a Telegram bot
Send "12.50 lunch" to your bot and it's saved to a Google Sheet instantly.
Telegram → Google Sheets3h/mo
Finance & AdminEasy
Weekly cash flow summary on Telegram
Every Sunday, see money in, money out, net and your biggest expenses of the week on Telegram.
Google Sheets → Telegram2h/mo
Finance & AdminEasy
Instant alert when a Stripe payment fails
Know about failed payments right away and log them for follow-up.
Stripe → Slack → Google Sheets2h/mo