Build a support knowledge base from your email archive

The scenario reads your customer email history, reassembles threads and extracts ready question-answer pairs, storing them in a database with no duplicates.

  • The handbook is built from answers you've already written
  • Duplicates filtered at two levels
  • Internal email never lands in the base
  • New hires find answers on their own
Set it upScriptera

How it works

To connect AWS SES and Microsoft SQL, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Manual Trigger
  2. Then: Fetch Emails
  3. Then: Parse and Filter
  4. Check: Is Customer Email
  5. If yes: Check Duplicate in DB
  6. Then: Merge Duplicate Result
  7. Check: Not Already Processed
  8. If yes: Assemble Thread
  9. Then: AI Extract KB Entries
  10. Then: Parse KB Entries
  11. Check: Has KB Entries
  12. If yes: Check KB Duplicate
  13. Then: Merge KB Duplicate Result
  14. Check: KB Entry Is New
  15. If yes: Process and Insert All
  16. Then: OpenAI Chat Model

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

Similar scenarios