Send subscription renewal reminders via Telegram with Supabase

Subscription Renewal Reminder – Telegram & Supabase

This workflow tracks upcoming subscription expiry dates stored in Supabase and automatically sends personalized renewal-reminder messages to each customer via Telegram. It is designed to be triggered by an HTTP Webhook (manually or on a schedule) and ensures that customers are notified a configurable number of days before their subscription lapses.

> Community Template Disclaimer > This is a community-contributed n8n workflow template. It is provided “as-is” without official support from n8n GmbH. Always test thoroughly before using in production.

Pre-conditions/Requirements

Prerequisites - n8n instance (self-hosted or n8n.cloud) - Supabase project with a subscriptions table (id, customername, expirationdate, telegramchatid, notified) - A Telegram Bot created via @BotFather - Outbound HTTPS access from n8n to api.telegram.org and your Supabase project REST endpoint

Required Credentials - Supabase Service Role Key – Full access for reading/writing the subscriptions table - Telegram Bot Token – To send messages from your bot - n8n Webhook URL – Auto-generated when you activate the workflow

(ScrapeGraphAI API Key is not required for this non-scraping workflow.)

Specific Setup Requirements | Environment Variable | Example Value | Purpose | |----------------------|--------------|---------| | SUPABASEURL | https://xyzcompany.supabase.co | Base URL for Supabase REST API | | SUPABASEKEY | eyJhbGciOiJI... | Service Role Key | | TELEGRAMTOKEN | 609012345:AA... | Bot token obtained from BotFather | | REMINDERDAYS | 3 | Days before expiry to notify |