Taking food orders in your messenger — into a table and calendar

A chat bot takes the order, replies to the customer, adds items to Microsoft SQL and creates an event in pruffme.

  • The order is taken right in chat
  • Items into the orders table
  • Timing into the calendar
  • The customer gets an instant confirmation
WebhookFbMenu
Set it upScriptera

How it works

To move data from pruffme to Microsoft SQL automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Webhook - FB Messenger
  2. Check: Validate Webhook Subscription
  3. If yes: Respond Challenge
  4. If no: Respond 202 (Error fallback)
  5. Then: AI Agent (Order Assistant)
  6. Starts when: Respond 200 OK
  7. Then: Memory Buffer (Customer Session)
  8. Then: OpenRouter Model
  9. Then: Send Message to FB (Text)
  10. Check: Check for Menu Trigger
  11. If yes: Send Message to FB (Image)
  12. If no: Send Generic Text (HTTP)
  13. Check: Validate Parsed Order
  14. If yes: Parse Order Text
  15. Then: Append or Update Orders Sheet
  16. Then: Create Calendar Event
  17. If no: Respond Raw Items (Debug)

You can launch this pruffme + Microsoft SQL integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios