Handle WhatsApp orders, FAQs, and tracking with GPT-4o, Pinecone, and Sheets
Ready for 3.0What this workflow does
This AI workflow has 37 nodes and runs on Google Drive events (specific file) (plus 1 other trigger). Along the way it connects WhatsApp Business Cloud, OpenAI, OpenAI Chat Model and Vector Store Question Answer and 5 more.
How it runs
Trigger: On Google Drive events (specific file) (plus 1 other trigger).
- Download Knowledge Base File (Google Drive): download
- Extract WhatsApp Message Details (Edit Fields (Set)): sets 3 fields: phone, message, timestamp
- Store Knowledge Embeddings In Pinecone (Pinecone Vector Store): stores documents in the Pinecone vector store, with embeddings: Generate Knowledge Embeddings; document loader: Load Knowledge Base Document
- AI Intent Classification (OpenAI): uses OpenAI
- Parse Intent Classification Response (Code): runs custom JavaScript code
- Intent-Based Request Router (Switch): routes items into 3 branches
- WhatsApp FAQ AI Agent (AI Agent): runs an AI agent, with model: FAQ Response Language Model; 1 tool (Knowledge Base Retrieval Tool); memory: Conversation Memory Manager
- AI Order Information Extractor (OpenAI): uses OpenAI
- AI Order ID Extractor (OpenAI): uses OpenAI
- Notify Human Support Team (Slack): uses Slack
…plus 16 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (19)
- WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Vector Store Question Answer Tool
@n8n/n8n-nodes-langchain.toolVectorStore - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterCharacterTextSplitter - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader
From the author
Quick overview This workflow builds a WhatsApp business assistant that uses OpenAI to classify incoming messages and route them to FAQ answers via Pinecone RAG, order placement and inventory updates in Google Sheets, order-status lookups, or Slack escalation…