Product matching through a short quiz in your messenger

The bot asks a person a few simple questions, remembers the answers between sessions, and finally matches options from your product sheet — with an explanation.

  • Instead of a hundred-item catalog, three options tailored to the person
  • Answers are saved: they can leave and come back, and the quiz resumes
  • Matching runs against your product sheet, not general knowledge
  • Each option comes with a reason it fits
Set this upScriptera

How it works

To move data from WhatsApp Business Cloud to Microsoft Excel 365 automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Trigger: Incoming Telegram Message
  2. Then: Extract Telegram Message Text
  3. Then: Lookup User State (Google Sheet)
  4. Check: Merge Updated State for Next Step
  5. Then: Carry Forward Previous Answers
  6. Then: Update Answer in Google Sheet
  7. Then: Determine Next Quiz Question
  8. Check: Check if More Questions Remaining
  9. If yes: Is Q7 Answered?
  10. If yes: Fetch Cards
  11. Check: Merge User Profile & Card Dataset
  12. Then: Build GPT Prompt with User Profile & Card Data
  13. Then: Send Prompt to GPT for Card Matching
  14. Then: Clean GPT Output & Split into Sections
  15. Then: Format GPT Card Recommendations for Telegram
  16. Then: Send Card Recommendations to Telegram
  17. If yes: Clean Q1–Q7 Inputs
  18. If no: Get Question Text
  19. Then: Send Question
  20. If no: Telegram
  21. Check: Merge Incoming Message with State
  22. Check: Check if User Exists in DB
  23. If yes: Map & Format Answer for Google Sheet
  24. Then: Extract Metadata from Answer
  25. Then: Append Full User State for Processing
  26. If no: Insert New User into Google Sheet

You can launch this WhatsApp Business Cloud + Microsoft Excel 365 integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios