Answer WhatsApp gold chain enquiries using Google Sheets and Twilio
Ready for 3.0What this workflow does
This workflow has 24 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets and Twilio.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- config (Code): runs custom JavaScript code
- stock sheet configured? (If): checks a condition and branches into true / false
- [cred] Sheets - read the stock (Google Sheets): uses Google Sheets
- use the demo stock (Code): runs custom JavaScript code
- collect the stock (Code): runs custom JavaScript code
- read the message (Code): runs custom JavaScript code
- AI configured? (If): checks a condition and branches into true / false
- build the AI request (Code): runs custom JavaScript code
- keyword reading only (Code): runs custom JavaScript code
- AI - read what they want (HTTP Request): calls an HTTP API (POST)
…plus 12 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 (7)
- Webhook
n8n-nodes-base.webhook - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Twilio
n8n-nodes-base.twilio
From the author
Quick overview This workflow receives incoming Twilio WhatsApp messages, looks up gold chain availability and last-approved prices from Google Sheets (or built-in demo stock), optionally uses an OpenAI-compatible model to parse what the customer wants, and…