n8n AI Productivity Data Management
Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.
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
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!
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.
Install this template and modify the Call the SQL composer Workflow step to point at your copy of the SQL workflow.
Adjust the rest of the necessary steps: Telegram Trigger, AI Chat model, AI Embeddings...
Activate the workflow and chat around!
Tools used: Ollama, Telegram
Download the workflow template (JSON)
Want this running in your business? KOBA42 builds and operates automations like this one.