All projects
PROJECTLive

Sadabahar Restaurant AI Chatbot

A production-ready AI restaurant chatbot that answers menu questions from verified restaurant data, recognizes returning customers, takes orders conversationally and automates order logging and confirmation.

The application combines Pinecone RAG with HuggingFace embeddings to retrieve relevant restaurant data before Gemini generates a response. FastAPI orchestrates the conversation, MongoDB stores customers, sessions and orders, and a hybrid summarization system preserves conversation context without continuously sending full chat history. When an order is confirmed, the application automatically saves it, logs it to Google Sheets and sends an HTML confirmation email.

Source code
PROJECT MEDIA

Demo & screenshots

Sadabahar AI Chatbot Demo
Sadabahar restaurant automatic order confirmation email
Automatic Order Confirmation Email
Sadabahar confirmed orders automatically stored in Google Sheets
Orders Logged Automatically in Google Sheets
THE SYSTEM, STEP BY STEP

System flow

01Customer
→
02Black & Red Chat UI
→
03POST /chat
→
04FastAPI Backend
→
05Memory Manager
→
06Pinecone RAG
→
07Google Gemini
→
08Order Service
→
09MongoDB Atlas
→
10Google Sheets
→
11Gmail SMTP

Click Play a Run to follow the system from start to finish.

What it is

Sadabahar Restaurant Chatbot is a full-stack conversational AI system built with FastAPI, LangChain and Google Gemini. It can greet returning customers by name, answer menu questions using exact information retrieved from a restaurant PDF, collect orders step by step, save orders to MongoDB and Google Sheets, and send branded HTML confirmation emails.

The problem it solves

Restaurant support involves repetitive menu questions and manual order handling. A generic LLM can also hallucinate menu items, prices or policies. The system therefore needed grounded restaurant knowledge, persistent customer recognition, controlled conversation memory and a reliable way to turn a completed chat into real operational actions.

How it works

  1. Hybrid 3-phase conversation summarization memory

  2. Pinecone RAG using HuggingFace all-MiniLM-L6-v2 embeddings

  3. Grounded menu answers using restaurant PDF data

  4. Anti-hallucination safeguards with verified restaurant information

  5. Phone-based permanent customer recognition

  6. Returning-customer last-order reorder support

  7. Step-by-step conversational order collection

  8. Automatic order processing after confirmation

  9. MongoDB storage for customers, sessions and orders

  10. Automatic Google Sheets order logging

  11. Branded HTML confirmation emails through Gmail SMTP

  12. Gemini API rotation across up to four API keys

  13. Smart RAG skip logic for simple order fields and confirmations

  14. Two-hour inactive-session expiry with persistent customer identity

  15. Session isolation between customers

The engineering focus

The application combines Pinecone RAG with HuggingFace embeddings to retrieve relevant restaurant data before Gemini generates a response. FastAPI orchestrates the conversation, MongoDB stores customers, sessions and orders, and a hybrid summarization system preserves conversation context without continuously sending full chat history. When an order is confirmed, the application automatically saves it, logs it to Google Sheets and sends an HTML confirmation email.

Built with

See the other projects