Automated customer reservations via Telegram and PostgreSQL (Module "Booking")
Ready for 3.0What this workflow does
This workflow has 39 nodes and runs on WhatsApp events. Along the way it connects Postgres and WhatsApp Business Cloud.
How it runs
Trigger: On WhatsApp events.
- Initialization (Edit Fields (Set)): sets or maps fields
- Get Bot Status (Postgres): uses Postgres
- Define Flow (Switch): routes items into branches
- Starts (WhatsApp Business Cloud): uses WhatsApp Business Cloud
- Commands (Switch): routes items into branches
- Get book (Postgres): uses Postgres
- Edit Fields (Edit Fields (Set)): sets or maps fields
- Payments (WhatsApp Business Cloud): uses WhatsApp Business Cloud
- Upsert Bot Status on START (Postgres): uses Postgres
- Main Menu (WhatsApp Business Cloud): uses WhatsApp Business Cloud
…plus 28 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 (8)
- Postgres
n8n-nodes-base.postgres - If
n8n-nodes-base.if - Switch
n8n-nodes-base.switch - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - Edit Fields (Set)
n8n-nodes-base.set - Summarize
n8n-nodes-base.summarize - Merge
n8n-nodes-base.merge
From the author
Who is this for? This workflow is for businesses or services that require managing customer reservations or appointments through a Telegram bot and storing reservation details in a PostgreSQL database. What problem is this workflow solving? This workflow…