n8n WhatsApp Cloud API AI Assistant w/ Data Tables

Automatically answer WhatsApp Cloud API messages with an AI assistant—backed by Data Tables, FAQ grounding, and Telegram failure alerts

This n8n workflow turns incoming WhatsApp Cloud API messages into a guided AI conversation. It logs messages in n8n Data Tables, extracts readable text from voice, images, and PDFs, generates WhatsApp-friendly replies using OpenAI with FAQ grounding, and notifies you via Telegram when something goes wrong.

What this workflow does

• Triggers on new WhatsApp Cloud API messages (and ignores delivery/read status updates).
• Normalizes and deduplicates webhook payloads into one item per customer message, skipping old or unsupported message types.
• Logs the raw message and uses Data Tables to prevent duplicate processing via message ID.
• Handles media content: when the message includes audio, an image, or a document, it fetches the WhatsApp media URL, downloads the file, and uses OpenAI plus PDF text extraction to convert content into readable text (or records an explanation when unsupported or too large).
• Buffers rapid messages from the same customer, then saves cleaned content to a messages Data Table.
• Builds context with conversation memory: loads the customer’s recent history, marks the latest messages as answered, and composes a prompt combining history + the new input.
• Generates a WhatsApp-style reply using an OpenAI chat model agent with a Data Tables Business FAQ tool to stay grounded in your FAQ and business info.
• Sends and stores the response, splitting formatted replies to fit WhatsApp limits.
• Error handling: when failures occur, it sends an alert via Telegram.

Use cases

• Customer support for WhatsApp inquiries with FAQ-based, consistent responses.
• Answering questions sent as voice notes, images, or PDFs—without manual transcription.
• SaaS operators who want conversation memory and reliable logging via n8n Data Tables.

Technical details

• Designed for n8n automation workflows using nodes: if, set, code, wait, switch, and telegram.
• Integrations: WhatsApp Cloud API, OpenAI, n8n Data Tables, Telegram.