Who is this for?

Everyone! Did you dream of asking an AI "what hotel did I stay in for holidays last summer?" or "what were my marks last semester like?".

Dream no more, as vector similarity searches and this workflow are the foundations to make it possible (as long as the information appears in your e-mails 😅).

100% Local and Open Source!

This workflow is designed to use locally-hosted open source. Ollama as LLM provider, nomic-embed-text as the embeddings model, and pgvector as the vector database engine, on top of Postgres.

Structured AND Vectorized

This workflow combines structured and semantic search on your e-mail.

No need for enterprise setups!
Leverage the convenience of n8n and open source to get a bleeding edge solution.

Setup

1. You will need a PGVector database with embeddings for all your email. Use my other template Gmail to Vector Embeddings with PGVector and Ollama to set it up in a breeze!
2. Make a copy of my Email Assistant: Convert Natural Language to SQL Queries with Phi4-mini and PostgreSQL, you will need it for structured searches.
3. Install this template and modify the Call the SQL composer Workflow step, to point at your copy of the SQL workflow.
4. Adjust the rest of necessary steps: Telegram Trigger, AI Chat model, AI Embeddings...

Activate the workflow and chat around!