Answer WhatsApp gold chain enquiries with Google Sheets, Twilio, and OpenAI
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 WhatsApp messages via Twilio, looks up matching gold chain items in a Google Sheets price list, and replies with the last approved prices and available quantities; it can optionally use an OpenAI-compatible model…