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

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

Ready for 3.0

by Lucas Hideki ✓ · 63 views · created 2026-03-04 · Ticket Management

Ready 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 18 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Postgres and Telegram.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).

  1. Validate tenant token (Code): runs custom JavaScript code
  2. Fetch events due for reminder (Postgres): run a query
  3. Organize form data (Code): runs custom JavaScript code
  4. Fetch tenant config (Postgres): run a query
  5. Render Template (Code): runs custom JavaScript code
  6. Insert tenant (Postgres): run a query
  7. Map webhook fields (Edit Fields (Set)): sets 9 fields: tenants_id, rule_id, channel…
  8. Route by channel type (If): checks a condition and branches into true / false
  9. Insert tenant rule (Postgres): run a query
  10. Send reminder via Telegram (Telegram): uses Telegram

…plus 4 more steps. See the full node list below.

Services it uses

PostgresTelegram

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 (10)

From the author

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…

Excerpt from Lucas Hideki's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.