Answer WhatsApp keyword FAQs with Twilio and Google Sheets
Ready for 3.0What this workflow does
This workflow has 7 nodes and runs on Twilio events (com.twilio.messaging.inbound message.received). Along the way it connects Twilio and Google Sheets.
How it runs
Trigger: On Twilio events (com.twilio.messaging.inbound message.received).
- Normalize Keyword And Sender (Edit Fields (Set)): sets 3 fields: keyword, sender, rawBody
- Route The Keyword (Switch): routes items into 3 branches
- Look Up The Answer Row (Google Sheets): uses Google Sheets
- Build The Help Reply (Edit Fields (Set)): sets 2 fields: replyText, replyTo
- Build The Answer Reply (Edit Fields (Set)): sets 2 fields: replyText, replyTo
- Send The WhatsApp Reply (Twilio): uses Twilio
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 (5)
- Twilio Trigger
n8n-nodes-base.twilioTrigger - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Twilio
n8n-nodes-base.twilio
From the author
Quick overview This workflow receives inbound WhatsApp messages via Twilio, extracts a one-word keyword, looks up the matching answer in a Google Sheets FAQ tab, and replies on WhatsApp with either the stored answer or a help message listing supported…