Templates / WhatsApp AI assistant for Q&A & bookings with Gemini, Pinecone & Google Sheets

WhatsApp AI assistant for Q&A & bookings with Gemini, Pinecone & Google Sheets

Needs changes

by Tharwat Mohamed ✓ · 1,764 views · created 2025-07-08

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 22 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects WhatsApp Business Cloud, Google Gemini Chat Model, Pinecone Vector Store and Embeddings Google Gemini and 3 more.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

  1. Google Drive: uses Google Drive
  2. AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 2 tools (reservations, Pinecone Vector Search); memory: Simple Memory
  3. Pinecone Vector Store: uses the Pinecone vector store, with embeddings: Embeddings Google Gemini; document loader: Default Data Loader
  4. Date & Time: formats or calculates dates
  5. conversations log (Google Sheets): uses Google Sheets
  6. 24-hour window check (Code): runs custom JavaScript code
  7. Check 24-Hour Follow-Up (If): checks a condition and branches into true / false
  8. cleanAnswer (Code): runs custom JavaScript code
  9. Send Pre-approved Template Message to Reopen the Conversation (WhatsApp Business Cloud): uses WhatsApp Business Cloud
  10. Send AI Agent's Answer (WhatsApp Business Cloud): uses WhatsApp Business Cloud

Services it uses

WhatsApp Business CloudGoogle Gemini Chat ModelPinecone Vector StoreEmbeddings Google GeminiGoogle SheetsGoogle DriveVector Store Question Answer

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in AI Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Removed in 3.0Replace with
AI Agent v1 (old agent modes)
AI Agent (v1.7)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (17)

From the author

Overview Turn WhatsApp chats into instant answers and real-time bookings—all in one n8n workflow. Your AI Agent leverages Gemini embeddings + Pinecone for on-the-fly knowledge retrieval, then logs reservations directly into Google Sheets. Features AI-powered…

Excerpt from Tharwat Mohamed's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.