WhatsApp AI Q&A & Booking Assistant with Gemini, Pinecone & Sheets

This n8n workflow turns WhatsApp chats into a smart AI assistant that handles natural-language Q&A and real-time service bookings. Powered by Google's Gemini for intelligent responses and Pinecone for fast vector-based knowledge retrieval from your Google Drive documents, it delivers accurate, context-aware answers instantly. Reservations are automatically logged into Google Sheets with details like timestamp, user ID, service, date, time, and notes.

Key benefits include 24/7 customer support without human intervention, effortless scaling for businesses, and time-saving automation that eliminates manual data entry. The included auto-embedding sub-workflow indexes your docs into Pinecone effortlessly, while a 24-hour follow-up system sends templated reminders for unanswered queries.

Ideal use cases: Service-based businesses like salons, clinics, or consultants for booking appointments; e-commerce for product Q&A; market research firms for instant data queries. Setup is straightforward with WhatsApp Business API, requiring only credentials for Gemini, Pinecone, Sheets, and Drive—perfect for small teams or solo entrepreneurs seeking high-impact automation.