Smart search over your own email — in plain questions

The scenario builds a meaning-based search base from your email — ask in plain words and find things even without the exact wording.

  • Search email by meaning, not exact keywords
  • Takes mail in bulk for a period, or new as it arrives
  • Everything runs on your own server, mail stays private
  • Ask like a person — it finds the right email
Embeddings OllamaDefault Data LoaderPostgres PGVector Store
Connect Pinecone Vector Store and goScriptera

How it works

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

  1. Starts when: Gmail Trigger
  2. Then: Extract email fields
  3. Then: Store structured
  4. Then: Store vectorized
  5. Check: Was manually triggered?
  6. If no: Loop Over Items
  7. Then: Set before and after dates
  8. Then: Get a batch of messages
  9. Then: Embeddings Ollama
  10. Then: Default Data Loader
  11. Then: Recursive Character Text Splitter
  12. Then: Split Out
  13. Starts when: Manual Trigger
  14. Then: Create the table
  15. Then: Explode interval into weeks

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

Similar scenarios