Automation library · Scheduling

Automated customer reservations with Postgres and WhatsApp

Started by an incoming WhatsApp message, and works across Postgres and WhatsApp. 39 steps, 6 branches: large, and worth reading before you trust it with anything live.

Large

Download free
39 stepsLarge: read it before trusting it with anything live
6Branches: places the flow splits
0Loops or waits
2Services it connects to

The flow

Starts it 1Logic 12Service 26

The steps in the order they run, from what starts it.

  1. 1WhatsApp TriggerWhats App triggerStarts it
  2. 2InitializationSetLogic
  3. 3Get Bot StatusPostgresService
  4. 4Define FlowSwitchLogic
  5. 5StartsWhats AppService
  6. 6CommandsSwitchLogic
  7. 7Get bookPostgresService
  8. 8Edit FieldsSetLogic
  9. 9PaymentsWhats AppService
  10. 10Upsert Bot Status on STARTPostgresService
  11. 11Main MenuWhats AppService
  12. 12Get Work DaysPostgresService
  13. 13MergeMergeLogic
  14. 14Update bot status on STARTPostgresService
  15. 15Is Date correct?IfLogic
  16. 16First Question?IfLogic
  17. 17Union Number with QuestionSetLogic
  18. 18Add BookPostgresService
  19. 19Get Work Days PostgresService
  20. 20Merge1MergeLogic
  21. 21SwitchSwitchLogic
  22. 22Union listSummarizeService
  23. 23Update Date AND StatusPostgresService
  24. 24Update HourPostgresService
  25. 25Phone validation1IfLogic
  26. 26Update NamePostgresService
  27. 27Request DateWhats AppService
  28. 28Get Work HoursPostgresService
  29. 29Request PhoneWhats AppService
  30. 30Update PhonePostgresService
  31. 31Phone ErrorWhats AppService
  32. 32page booking successWhats AppService
  33. 33Update bot status on BOOKINGPostgresService
  34. 34Union Number with Question1SetLogic
  35. 35Request NameWhats AppService
  36. 36Update status on BOOKEDPostgresService
  37. 37Union list1SummarizeService
  38. 38Update bot status on PAYMENTSPostgresService
  39. 39Request TimeWhats AppService

How it's built

Starts on
An incoming WhatsApp message
Steps
39, with 6 branches
Size
Large: read it before trusting it with anything live
Connects to
Postgres, WhatsApp
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Postgres and WhatsApp accounts. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an incoming WhatsApp message.

Does it use AI?

No. Every step is fixed logic or a call to a service, so it does the same thing every time.

How long does it take to set up?

Take your time. At 39 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 39 steps before you point it at anything that matters.