Templates / Answer WhatsApp gold chain enquiries with Google Sheets, Twilio, and OpenAI

Answer WhatsApp gold chain enquiries with Google Sheets, Twilio, and OpenAI

Ready for 3.0

by Atharva Ashtekar ✓ · 1 views · created 2026-09-28 · Support Chatbot, AI Chatbot

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. config (Code): runs custom JavaScript code
  2. stock sheet configured? (If): checks a condition and branches into true / false
  3. [cred] Sheets - read the stock (Google Sheets): uses Google Sheets
  4. use the demo stock (Code): runs custom JavaScript code
  5. collect the stock (Code): runs custom JavaScript code
  6. read the message (Code): runs custom JavaScript code
  7. AI configured? (If): checks a condition and branches into true / false
  8. build the AI request (Code): runs custom JavaScript code
  9. keyword reading only (Code): runs custom JavaScript code
  10. 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

Google SheetsTwilio

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)

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…

Excerpt from Atharva Ashtekar's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.