Development of a Smart AI Assistant for WhatsApp

Objective: The client (real estate brokers in Dubai) was losing warm
leads outside of business hours and spending hours on routine replies, sending price lists,
and checking apartment availability. The requirement was to create a reliable WhatsApp bot
that would advise clients 24/7, send brochures, and
close deals, while being as easy to manage as possible—via
a standard Google Sheet.

Solution: A smart AI broker based on GPT-4o-mini was developed and implemented with
integration into WhatsApp. I built complex logic where the AI doesn’t just
“chat,” but operates according to strict business rules:

- Dynamic database: The bot retrieves current prices and availability directly from
the client’s Google Sheets.
The client doesn’t need to mess with the code—they simply update
a cell in the spreadsheet.
- PDF brochure delivery: The bot generates direct download links for presentations upon
the client’s request.
- Hallucination protection (Guardrails): The AI is strictly prohibited from giving financial
advice or inventing apartments that aren’t in the database.
- Multilingual support: The assistant automatically detects the interlocutor’s language
and conducts the conversation in that language.
- Sales funnel: When a client is ready to purchase, the AI requests the necessary set of
documents (Passport, KYC, Proof of Payment).

Technology stack:

- n8n (Self-hosted on Ubuntu/Docker) — logic architecture and API orchestration.
- OpenAI API (GPT-4o-mini) — the assistant’s brain.
- Green-API — a gateway for stable integration with WhatsApp.
- Google Sheets API — database (Availability, FAQ, System Prompts).

Result: The client received a fully autonomous lead processing system. The bot
instantly responds to inquiries, neatly formats prices with emojis, and collects
documents for booking, saving managers dozens of hours of work every month.

#BotDevelopment #WhatsApp #ChatGPT #OpenAI #n8n #APIIntegration #Automation
#ChatBot #AI #Webhook #GoogleSheetsAPI