AI-Powered Support & Sales Assistant for D2C Skincare
A complete WhatsApp-based AI agent system that handles product recommendations by skin type & budget, answers FAQs from a knowledge base, tracks orders in real-time, and seamlessly hands off complex queries to human agents — all powered by n8n workflows and Airtable data.
Six Core Capabilities
Each capability is backed by Airtable data, ensuring the AI never invents information — every answer is grounded in verified records.
Smart Product Recommendations
Recommends products based on skin type, concerns, and budget from verified catalogue data. Supports Hinglish conversation.
FAQ Auto-Response
Instantly answers shipping, returns, COD, and delivery questions from a structured FAQ knowledge base in Airtable.
Order Tracking
Retrieves order status, items, total amount, tracking ID, and estimated delivery from the Orders Demo table.
Human Handoff
Detects complex queries, complaints, or explicit requests for human support and seamlessly routes to a live agent.
Conversation Logging
Every interaction is logged in Airtable with timestamps, intents, and responses for debugging and analytics.
Safety Guardrails
Never invents prices, discounts, or medical claims. Responds with safety disclaimers for sensitive skincare queries.
See the Agent in Action
Real WhatsApp conversations showing the AI agent handling product queries, FAQs, and order tracking in Hinglish.
Product Recommendation
Customer asks for moisturizer for oily skin within ₹1000 budget (in Hindi). Agent recommends relevant products from catalogue with prices and links.
FAQ Auto-Response
Customer asks about shipping charges. Agent instantly retrieves the answer from FAQ knowledge base — ₹49 for orders below ₹799, free above.
Order Tracking
Customer asks "kya mera koi past order hai?" (in Hindi). Agent retrieves complete order details — ID, status, items, total, tracking, and delivery date.
How It Works Under the Hood
Built on n8n with color-coded workflow sections for clear separation of concerns.
Message Intake & Routing
WhatsApp Trigger → Normalize payload → Check if human handoff is needed → Route to AI or escalate.
AI Agent & Tools
Tools Agent with access to: Catalogue, FAQ, Build Context, Model config, Orders, Dinsaagi, and Structured Output Parser.
Human Handoff
When the bot detects complex/sensitive queries, routes to a human agent with full conversation context and sends notification.
Response & Logging
Sends WhatsApp response, creates/updates Airtable log records, and stores supported conversation history.
Structured Data — The Agent's Brain
Five interconnected Airtable tables serve as the single source of truth. The AI never invents data — every response is grounded in these records.
Catalogue
8 demo SKUs with name, category, price (₹), skin type, and key ingredients.
8 recordsFAQ
9 questions on shipping, returns, COD, delivery time, and safety with categorized answers.
9 recordsLog
Every conversation logged with timestamps, user message, bot response, and detected intent.
Live loggingHandoff
Tracks when and why conversations are escalated to human agents with full context.
Escalation recordsOrders Demo
Sample orders with order ID, status, items, total, tracking ID, and estimated delivery.
Demo ordersBuilt With
n8n
Workflow Orchestration
WhatsApp Business API
Customer Messaging
Airtable
Relational Data Model
OpenRouter / LLM
AI Response Generation
JavaScript Nodes
Custom Data Transform
Structured Output Parser
Response Formatting
View the Full Airtable Base
Access the complete data model with Catalogue, FAQ, Log, Handoff, and Orders Demo tables. See exactly how the AI agent's knowledge base is structured.
Interested in This Project?
Reach out for a live demo, technical walkthrough, or to discuss building something similar for your D2C brand.
+91 63878 82759
Message Now →@dhruvrajwada
Follow →Dhruv Rajwada
Connect →
Dhruv Rajwada
AI Automation Developer
Building AI-powered workflow systems for D2C brands. Focused on conversational AI, n8n orchestration, and structured data.