A WhatsApp bot that answers, quotes and books demos while the team sleeps

Chairman Saheb, a housing-society app, gets enquiries from society chairmen and committee members on WhatsApp at all hours. Each one needed a person to reply, collect the same details, work out a price, find a free demo slot and write it down somewhere — and follow-ups were missed whenever that person was busy.

The assistant runs in n8n: a WhatsApp trigger feeds an AI Agent node with three Google Sheets tools — Lookup Lead, Update Lead and Check Demo Slots — so every reply is grounded in the lead sheet rather than chat memory. It greets returning leads by name, asks only for what is still missing, answers app and pricing questions, resolves phrases like 'next Tuesday 4pm' to a real date from a live n8n $now expression, checks the sheet for 30-minute slot conflicts before confirming, and handles reschedules, cancellations and ghosted leads that come back.

• n8n WhatsApp trigger feeding an AI Agent node with Google Sheets tools
• Lookup-before-write rule: the sheet is the only source of truth
• Quotations by society size, with GST shown
• Demo booking with 30-minute slot-conflict checks across all leads
• Relative date resolution from a live n8n $now expression
• Reschedule, cancel, follow-up and ghost-lead resume flows

Prospects get an immediate, accurate reply on WhatsApp — quotations, role questions and demo bookings included — demos land on non-conflicting slots, and the team works from one live sheet instead of a chat history.