Nkululeko-VillI-Nhlapo/Car-Wash-Assistant-AI-Powered-
Domain:
digital infrastructureRecord type:
software
Creator:
Nku
Host:
MR Banks Car Detailing Assistant is an AI-powered WhatsApp solution for car detailing businesses in South Africa. It integrates Claude AI, Twilio, and Google Sheets to log services, track revenue and expenses, analyze customers, and generate real-time business and financial reports directly from WhatsApp
# Car-Wash-Assistant-AI-Powered-
# 🚘💦 MR Banks Car Detailing Assistant (AI-Powered)
Your **AI-driven WhatsApp Business Assistant** for managing a car detailing business in South Africa 🇿🇦.
This project integrates **Claude AI 🤖, Twilio WhatsApp API 📱, and Google Drive Sheets 📊** to automatically:
- 📥 Log services and expenses from natural WhatsApp messages
- 💰 Track revenue, expenses, and profit margins
- 📊 Generate instant reports & financial insights
- 👨👩👧 Analyze customer journeys (new vs repeat customers)
- 🕒 Provide South African date/time & weekly breakdowns (1–4 per month)
---
## ✨ Features
- **AI-Powered WhatsApp Assistant** (via Anthropic Claude + Twilio)
- **Smart Service Logging** (Customer, Service Type, Amount, Payment Method, Status)
- **Expense Tracking** (Amount, Supplier, Category)
- **Business Intelligence Reports** (profitability, payment rate, best service, customer insights)
- **South African Context** (Rand 💵, UTC+2 timezone, week-of-month tracking)
- **Google Drive Integration** (syncs Excel workbook for Operations, Revenue & Expenses)
- **Cash Flow & Income Statements** (on-demand via chat)
- **Conversational Data Collection** ("Moloi, who was the customer?", "How much did you spend?")
---
## 🛠️ Tech Stack
- **Backend Framework**: Flask
- **AI/LLM**: Anthropic Claude
- **Messaging**: Twilio WhatsApp API
- **Data Storage**: Google Drive Sheets (Excel)
- **Data Processing**: openpyxl
- **Logging & Monitoring**: Python `logging`
---
## The **Excel Workbook** in Google Drive contains three main sheets:
- `Operations` ➝ Tracks services completed
- `Revenue` ➝ Tracks payments and status
- `Expenses` ➝ Tracks business expenses
---
## 💬 WhatsApp Interaction
Examples of what you can send to the bot:
📌 Log a service:
Customer John did a full wash today and paid R180 by card
➡️ AI logs service into Operations + Revenue sheets automatically
📌 Log an expense:
Paid R350 for new soap from CleanSupplies
➡️ AI logs expense into Expenses …