Chatbot for searching and booking apartments in Tenerife

Platform: Facebook Messenger
Language of interaction: English
Integrations: Google Sheets, iCal (LitePMS), Telegram, Facebook

1. Client's task

The client needed an automated tool that:

• helps tourists quickly find apartments in Tenerife;
• checks real availability dates automatically;
• shows suitable options with living conditions and costs;
• sends a complete request to managers for further communication and booking.

The main goal is to reduce the workload on managers and speed up the process of receiving requests.

2. Implemented solution

I developed a smart chatbot for Facebook Messenger that fully guides the user from searching to booking confirmation.

3. How the bot works

1) Launch

The user types the keyword “Search Apartments” or clicks the corresponding button.

2) Gathering accommodation parameters
The bot sequentially asks for:

• check-in date
• check-out date
• number of adults
• number of children

3) Checking apartment availability

• The bot analyzes the database from Google Sheets
• Checks occupancy through the iCal file (integration with LitePMS)
• Filters only available options for the specified dates

4) Providing suitable apartments
For each option, the bot shows:

• photo
• name
• description
• link to the property card on Facebook
• final cost for the selected period

The user receives all suitable options in a row (up to 10 options)

5) Preparing the request
After the last option, the bot offers to make a booking.

6) Sending the request to managers
When clicking “Book now,” the bot automatically sends a detailed notification to a closed Telegram group:

• user data
• search parameters
• request number and date
• two convenient buttons for managers: “Go to chat with the client” and “Open Google Sheet with the full request”

7) Contacting the manager at any moment
At each stage, the user can press the “Ask a manager” button — the request immediately arrives in Telegram.

3. Results for the client

• 100% automation of initial communication with tourists.
• Instant receipt of requests by managers.
• Time savings: manual availability checks are no longer necessary.
• Working in English — expanding the audience.