Handle WhatsApp customer chats with OpenAI and Data Tables
Ready for 3.0What this workflow does
This AI workflow has 34 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects WhatsApp Business Cloud, OpenAI, OpenAI Chat Model and Data table and 1 more.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Setup Conversation Table (Data table): create (table)
- Set Configuration Parameters (Edit Fields (Set)): sets 10 fields: businessName, assistantName, businessInfo…
- Setup FAQ Table (Data table): create (table)
- Parse WhatsApp Messages (Code): runs custom JavaScript code
- Filter Unread Messages (Data table): row not exists
- Log New Messages (Data table): insert (row)
- Route by Message Type (Switch): routes items into 3 branches
- Extract Media Link (WhatsApp Business Cloud): media url get
- Store Message Text (Data table): update (row)
- Verify File Accessibility (If): checks a condition and branches into true / false
…plus 20 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 (16)
- Manual Trigger
n8n-nodes-base.manualTrigger - Data table
n8n-nodes-base.dataTable - WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - Extract from File
n8n-nodes-base.extractFromFile - Wait
n8n-nodes-base.wait - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Data Table Tool
n8n-nodes-base.dataTableTool - Telegram
n8n-nodes-base.telegram
From the author
Quick overview This workflow creates Data Tables for message logging and FAQ, then runs a WhatsApp Cloud API assistant that can read text, voice notes, images, and PDFs, uses OpenAI to respond with conversation memory, and alerts via Telegram when failures…