Kütüphane / Sohbet Botları ve Mesajlaşma Botları
Sohbet Botları ve Mesajlaşma Botları
Google Sheets'teki verilerle Twilio üzerinden WhatsApp altın zincir fiyat sorularını yanıtla
WhatsApp mesajlarını bir Twilio webhook'u üzerinden alır, stil, ayar, uzunluk ve adedi Google Sheets fiyat listesiyle eşleştirir ve yalnızca onaylı fiyatlarla yanıt verir.
Ne yapar
## Answer WhatsApp gold chain enquiries from a Google Sheets price list Who's it for Jewellery wholesalers who get "22k rope 20 inch, how much?" on WhatsApp all day and want every answer to quote the same approved price list. How it works Twilio posts each incoming WhatsApp message to the webhook. The workflow reads the Stock tab, then works out what the customer wants: style, karat, length and quantity. Keyword rules always run, and an optional AI model can fill gaps, but only into those fields; it never sees a price and never writes the reply. The reply is decided in order: an opt-out is confirmed and recorded, an order, bulk quantity, custom piece or complaint goes to the owner, a stock question is answered from the sheet at the last approved price, and a vague message is asked for style and karat. How to set up 1. Run Run the demo messages first: five invented messages, nothing sent. 2. In config, set SHEET_ID, TWILIO_WHATSAPP_FROM and OWNER_WHATSAPP. 3. Connect Google Sheets and Twilio on the [cred] nodes and point the sender's incoming webhook here. 4. Set TEST_WHATSAPP, then TEST_RUN = false. Requirements A Google Sheet with Stock and Customers tabs and a Twilio WhatsApp sender. An AI key is optional. How to customize HANDOFF_QTY sets when a quantity goes to a person, the keyword lists in read the message decide what is recognised, and STYLES limits which styles are ever offered. Pair it with the companion repricing workflow, which writes the prices this one quotes.
Adımlar
- A WhatsApp message arrives
- Run the demo messages
- config
- stock sheet configured?
- [cred] Sheets - read the stock
- collect the stock
- use the demo stock
- read the message
- AI configured?
- build the AI request
- AI - read what they want
- apply the AI reading
- keyword reading only
- decide the reply
Toplam 24 adım.
Benzer otomasyonlar
Uyarılar ve BildirimlerOnfleet Olaylarında Twilio ile WhatsApp Mesajları Gönderme2 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeTypeform potansiyel müşterilerini Twilio ile WhatsApp'a gönderme4 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeTwilio ile Typeform Potansiyel Müşterilerini WhatsApp'a Gönderme3 adımSohbet Botları ve Mesajlaşma BotlarıOpenAI hafızası ve Google Sheets ile WhatsApp chatbot'u7 adım