The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
An AI support agent for a coffee shop that answers menu and FAQ questions, takes orders, and raises support tickets in real time. Customers get an order number and then a live notification in the chat when their order is delivered. The menu, FAQs, tickets and chat logs all sync with Google Sheets, so staff can update the menu in a spreadsheet instead of touching code. An admin dashboard shows tickets, orders, past conversations and sales statistics. Built with FastAPI, LangChain and an LLM, and deployed in Docker.
CozyBrew: AI Support & Ordering Agent for Coffee Shops
The Google Sheets sync is the smartest call here — staff can update the menu in a spreadsheet instead of touching code, so the system survives the people who actually run the shop. How do you handle it when a customer orders something that was just taken off the menu mid-conversation?
Thanks Olanrewaju! Exactly—keeping non-technical staff out of the codebase was a huge priority for this build.
Regarding mid-conversation menu updates:
Right now, the agent checks the live Google Sheet every time an order or menu query comes in (via get_live_menu()).
Live Check on...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
🚨 A dental clinic was losing patients every single day.
Not because of bad service. Not because of high prices.
Because nobody was replying to messages.
Patients messaged on WhatsApp, Messenger, SMS… And waited. And waited. And left.
The clinic owner contacted me with one simple ask:
“I can’t hire someone to reply 24/7. Can you help?”
So, I built them an AI receptionist that never sleeps. 👇
Here’s exactly what it does:
✅ Omnichannel Support: Instantly replies to patients on WhatsApp, Facebook Messenger & SMS — all from one system.
✅ Human-like AI: Google Gemini AI understands the message, detects intent, and replies naturally.
✅ Smart FAQ Handler: Answers questions about services, pricing & clinic hours by pulling live data from Google Sheets.
✅ Automated Booking: Checks availability, blocks double-bookings, and confirms only after saving to the sheet.
✅ Instant Alerts: Notifies the clinic owner instantly via Gmail + Telegram on every new booking.
✅ Smart Reminders: Sends automated email reminders — 2 hours and 1 hour before the appointment.
✅ No-Show Recovery: Detects missed appointments and automatically sends a polite rescheduling email after 12 hours.
The Tech Stack 🛠️:
⚙️ Make.com — Automation backbone
🧠 Google Gemini 2.0 Flash — AI brain
📊 Google Sheets — Live clinic database
💬 Green API — WhatsApp integration
📱 Facebook Messenger API & Twilio — Chat & SMS
✉️ Brevo — Email reminders
📢 Telegram Bot — Owner notifications
💾 Make.com DataStore — Conversation memory per patient
The Result? 📈
Every patient gets an instant, intelligent reply — 24/7. No missed bookings. No forgotten appointments. No manual follow-ups.
The clinic owner now wakes up to confirmed appointments already in the sheet with zero manual effort.
This is what I build for businesses. If you’re still replying manually and losing leads while you sleep — DM me. Let’s fix that. 👇
#MakeAutomation #AIAutomation #NoCode #Makecom #GeminiAI #WhatsAppAutomation #BusinessAutomation #AIReceptionist #FreelanceAutomation #Upwork #Fiverr
Nice build, and very close to a WhatsApp assistant I just built for a dental-clinic use case on the WhatsApp Cloud API. Two things mattered a lot in testing: when a patient asks for a person, the bot has to go completely quiet for that chat until the owner hands it back, and the...
Imagining you book your flight while experiencing
Meet Contrail.
Complex data into beautiful visuals in 3d.
Demo: https://flights-gr8r.vercel.app
Booking a flight with a 3D plane in the search is a fun idea. The dark UI makes the model stand out well.
ChatGPT Pro: 0% left. Claude Max: 100% used.
Two $200 plans, and somehow I still need more AI. 😅
At this point, am I a developer or just an AI subscription collector? 💀
💯 Can't stop creating