Lightweight support desk with Telegram and Postgres database tracking
Ready for 3.0What this workflow does
This workflow has 43 nodes and runs on Telegram events (message). Along the way it connects Telegram and Postgres.
How it runs
Trigger: On Telegram events (message).
- 02 Switch: Route by Command (Switch): routes items into 5 branches
- Welcome Message (Telegram): uses Telegram
- 03b FN: Parse Status Command (Code): runs custom Python code
- 03a FN: Normalize + Hash (Code): runs custom Python code
- 03c FN: Parse Update Command (Code): runs custom Python code
- Check Admin (If): checks a condition and branches into true / false
- Telegram: uses Telegram
- 03b IF: Has Valid Correlation ID Format (If): checks a condition and branches into true / false
- 04a DB: Upsert Ticket (Postgres): run a query
- 03c0 IF: Is Operator (If): checks a condition and branches into true / false
…plus 32 more steps. See the full node list below.
Services it uses
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 (6)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Switch
n8n-nodes-base.switch - Code
n8n-nodes-base.code - Postgres
n8n-nodes-base.postgres - Telegram
n8n-nodes-base.telegram - If
n8n-nodes-base.if
From the author
Telegram ticket intake and status tracking with Postgres Who’s it for Anyone running support requests through Telegram, Email, Webhooks, and so on who needs a lightweight ticketing system without paying Zendesk prices. Ideal for small teams, freelancers, or…