I need a WhatsApp chatbot that focuses on one clear job: capture every customer inquiry that reaches our business number, drop it instantly into Google Sheets, and send the customer a tailored acknowledgement that fits the category of their question. Here’s the exact flow I have in mind. When a message comes in, the bot should recognise the inquiry type (for example “Pricing”, “Technical Support”, “Order Status”, etc.), log the full chat transcript plus a timestamp into the matching sheet column or tab, and then reply with a short, pre-written message relevant to that category. This way my team can open the sheet, filter by inquiry type, and start working without digging through WhatsApp chats. Key points – Platform: WhatsApp Business API (Twilio or Meta Cloud API are both fine; suggest what you’re comfortable with). – Storage: Google Sheets, organised by inquiry type exactly as described. – Response logic: send a customised reply tied to the recognised category; I’ll supply the text once the framework is ready. – Tech stack: I’m comfortable with Python, Node.js or Apps Script solutions, as long as setup and credentials are clearly documented. Deliverables 1. Working chatbot connected to our verified WhatsApp number. 2. Google Sheet that auto-populates rows in real time, grouped by inquiry type. 3. Configuration file or UI for editing the canned responses. 4. Deployment guide so I can replicate the setup if we change numbers or accounts. 5. Short hand-off call or video walkthrough to confirm everything works. Acceptance criteria – Test messages in at least three different inquiry categories populate the correct sections of the Sheet within five seconds. – Customers receive the correct customised reply without manual intervention. – No duplicate entries or missing data after a 24-hour test window. If any API keys or cloud functions are required, point me to the exact steps so I don’t get stuck in approvals. Looking forward to getting this live quickly.