workflows.fit
Back to n8n workflows
n8n templateFreeBy Alfonso Corretti

Gmail to vector embeddings with PGVector and Ollama

Gmail to Vector Embeddings with PGVector and Ollama 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 m...

DevelopmentData & StorageCommunicationHITLCore NodesAILangchainEmbeddings Ollama
Loading interactive preview...

Template notes

Gmail to Vector Embeddings with PGVector and Ollama

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](https://www.pinecone.io/learn/vector-embeddings/) and this workflow are the foundations to make it possible (as long as the information appears in your e-mails 😅).

100% local

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.

But.. how?!

Firstly, specify the date you created your Gmail account on, then manually run the workflow in order to bulk read all your e-mail in monthly batches. Your database is now populated!