AutomationMart
Home/Browse/Gmail to vector embeddings with PGVector and Ollama
n8n

Gmail to vector embeddings with PGVector and Ollama

n8nn8n16 modulesv1.0
GmailTelegram

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 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 mod

At a glance

Gmail to vector embeddings with PGVector and Ollama is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Telegram. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Telegram
Modules
16
Price
Free
Version
v1.0
Gmail to vector embeddings with PGVector and Ollama workflow diagram

About this workflow

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 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! Now it's the task for other workflows to query the vector database. Activate the workflow so that new e-mail is continuously added by the Gmail Trigger upon receiving it. Structured AND Vectorized This workflow stores your e-mail activity in two ways: - In a structured table - In a vector embeddings table And the information in both of them can be correlated by Gmail's messages id, which is stored in the vectors table as metadata property emailsmetadata.id. That way consumers can benefit from both worlds! ✨ Vector similarity searches enable semantic searches, while structured queries can retrieve more factual data like the message id, its date or who it came from. Other useful templates My template Chat with Your Email History using Telegram, Mistral and Pgvector for RAG is a ready-made solution to consume this workflow. You may also pair this workflow with my other template to Email Assistant: Convert Natural Language to SQL Queries with Phi4-mini and PostgreSQL and you'll enable RAG workflows that use both structured and vectorized databases. Customizations I suppose the e-mail provider could be changed, but then you'd have to identify an alternative id field. Message-ID would be a more standard option. There are a few opinionated choices as to what metadata to store, but those shouldn't need adjustments.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Send a Gmail message from a new Resource Guru booking

Every time a Resource Guru booking is created, Make will automatically send a Gmail message.

Free

Conversational Razorpay Analytics with Google Gemini & Telegram Bot

Description Access your Razorpay insights instantly from Telegram—no dashboard, filters, or manual queries needed. Simply send messages like “show my payments”, “list recent orders”, or “check refunds”, and the bot retrieves the latest information from your Razorpay merchant account in seconds. Powered by AI, the workflow understands your message, fetches the relevant Razorpay data, and transforms it into a clear, easy-to-read summary. Everything is delivered back to you within the same T

Free

Send Telegram messages for new tickets in tawk.to

Every time a ticket is created in your tawk.to, Make will send a message with information on it to your Telegram.

Free

Invoice data extraction with LlamaParse and OpenAI

This n8n workflow automates the process of parsing and extracting data from PDF invoices. With this workflow, accounts and finance people can realise huge time and cost savings in their busy schedules. Read the Blog: How it works This workflow will watch an email inbox for incoming invoices from suppliers It will download the attached PDFs and processing them through a third party service called LlamaParse. LlamaParse is specifically designed to handle and convert complex PDF data structures

Free

Create new notes in Productboard from new Gmail emails

This template periodically retrieves Gmail emails matching a specific filter and uses the email information (sender, subject, body) to create new notes in Productboard. The template is scheduled to run every 15 minutes. You can change this after you set up the template.

Free

Post images and text from Google Drive and Sheets to LinkedIn

How This LinkedIn Automation Workflow Helps You: - Save time - Eliminate manual LinkedIn posting and content scheduling tasks - Stay consistent - Automated daily posting keeps your LinkedIn profile active and engaging - Keep control - Preview every post before it goes live via Telegram approval system - Track everything - Complete posting history and status tracking in Google Sheets dashboard - Never double-post - Smart status tracking prevents duplicate content and posting errors - Scale conten

Free

Turns Reddit Pain Points into Comic Ads using Dumpling AI and GPT-4o

Description 🤖 What this workflow does This workflow turns Reddit pain points into emotionally-driven comic-style ads using AI. It takes in a product description, scrapes Reddit for real user pain points, filters relevant posts using AI, generates ad angles, rewrites them into 4-panel comic prompts, and finally uses Dumpling AI to generate comic-style images. All final creatives are uploaded to Google Drive. --- 🧠 What problem is this solving? Crafting ad content that truly speaks to custom

Free

Bulk delete all YouTube playlists from your channel

Who is this for? This workflow is for any YouTube user who wants to bulk delete all playlists from their own channel — whether to start fresh, clean up old content, or prepare the account for a new purpose. It’s useful for: Creators reorganizing their channel People transferring content to another account Anyone who wants to avoid deleting playlists manually one by one 🧠 What problem is this workflow solving? YouTube does not offer a built-in way to delete multiple playlists at once. If you h

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free