agent-image-lead-qualification-assistant
Create Secure Human-in-the-Loop Approval Flows with Postgres and Telegram
πŸ” Human-in-the-Loop Approval Flow (n8n + Postgres + Telegram) πŸ‘₯ Who’s it for Teams that need a manager approval step before a ticket or request can change...
screenshot-daily-task-reminder-bot
Created by:
Mohammad
Last Updated:
2025-12-18 07:00:47
Agent Details:
n8n
OpenAI
general
If
Postgres
Webhook
Description
πŸ” Human-in-the-Loop Approval Flow (n8n + Postgres + Telegram) πŸ‘₯ Who’s it for Teams that need a manager approval step before a ticket or request can change status. Great for internal ops, IT requests, or any workflow where β€œa human must sign off.” ⚑ What it does πŸ“¨ Manager receives approval/reject link πŸ”‘ Link is signed with HMAC + expiry (secure & tamper-proof) πŸ—„οΈ Postgres updates the ticket status πŸ“ Audit trail records every decision πŸ“² Telegram notifies both manager and requester ⏰ Expired or invalid links trigger alerts and logs πŸ›  Requirements n8n instance (self-hosted) Postgres database (with tickets , ticket_audit , workflow_errors ) Telegram bot token One environment variable set: SECRET_KEY βš™οΈ How to set up Set SECRET_KEY in .env Create Postgres tables (SQL provided) Add Telegram + Postgres credentials in n8n Import the workflow JSON Test by opening an approval/reject link in your browser 🎨 How to customize Change who the β€œmanager” is (currently hardcoded in the Code node). Swap Telegram for Slack or email notifications. Extend the audit schema to include more metadata (IP, username).

Build Dynamic AI Agents

Join a community of growing Agentic AI Developers.