Messenger support with built-in lead management

The scenario answers customers in Microsoft Teams from your FAQ and services, creates a card for each and stores the whole conversation.

  • Answers from your FAQ and services
  • Every customer added to the base
  • The full conversation is stored
  • Support without your involvement
Data table Tool

How it works

To pass leads from Microsoft Teams to Snowflake automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: Telegram - Incoming Message
  2. Then: Log - User Message
  3. Then: DB - Get Lead by User ID
  4. Check: Check – Lead Record
  5. If yes: Build Assistant Context
  6. Then: AI - Smart Support Assistant
  7. Then: Log - Bot Message
  8. Then: Telegram - Send Response
  9. If no: DB - Create Lead
  10. Then: OpenRouter Chat Model
  11. Then: Simple Memory
  12. Then: DB - Update Lead
  13. Then: DB - Get FAQ
  14. Then: DB - Get Services
  15. Then: DB - Get Settings

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