workflows.fit
Back to n8n workflows
n8n templateFreeBy Lucas Hideki

Send multi-tenant reminders via Telegram from webhooks and schedule with Postgres logging

How it works - Any external system triggers a reminder via webhook with a tenant token — the workflow validates the token, fetches the tenant's channel config and message template from PostgreSQL, renders the message ...

DevelopmentData & StorageCommunicationHITLCore NodesSticky NoteSchedule TriggerPostgres
Loading interactive preview...

Template notes

How it works

- Any external system triggers a reminder via webhook with a tenant token — the workflow validates the token, fetches the tenant's channel config and message template from PostgreSQL, renders the message with event variables, and sends it immediately - A schedule trigger runs every minute and queries events approaching their deadline window per tenant — idempotency via a reminderssent table ensures the same reminder is never sent twice - A built-in n8n form lets you register new tenants with their channel, message template and timing rules — no external backend needed - Every send attempt is logged to the database with status, message sent and error details

Set up steps

- Add your PostgreSQL credentials to all Postgres nodes (~2 min) - Add your Telegram credentials to the Send Message node (~2 min) - Create the required tables using the SQL schema provided in the workflow sticky note (~10 min) - Register your first tenant at /form/multi-tenant-register - Send events via POST /webhook/multi-tenant-webhook with x-tenant-token header