Automated Customer Reservations via Telegram and PostgreSQL (Module "Booking")

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 automates the process of capturing reservation data via a Telegram bot and storing it in a PostgreSQL database. It eliminates the need for manual entry and reduces errors, improving efficiency in managing bookings.

What this workflow does

• The workflow allows customers to select a day and time for their reservation through a Telegram bot.
• Customers provide their phone number and name, which are then added to the reservation table in the PostgreSQL database.
• Successfully added reservations are confirmed via the bot, ensuring both the business and customer are updated.

Setup

1. Create tables in Postgres DB

   • Replace "n8n" in the provided SQL script with the name of your schema in the database.
   • Execute the SQL script to set up the required tables.

2. Add Credentials

   • Add your Telegram bot credentials.
   • Add your PostgreSQL database credentials to the workflow for seamless integration.

How to customize this workflow to your needs

• Modify the available days and times in the Telegram bot according to your business hours or schedule.
• Adjust the database schema or add additional fields for customer preferences, special requests, or payment information as needed.