Gmail to Vector Embeddings with PGVector and Ollama
20 nodes · embeddingsOllama, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, gmail, splitInBatches, splitOut
- Engine
- n8n
- Nodes
- 20
- Trigger
- scheduled/triggered
- Source file
- 1783_Splitout_Postgres_Automation_Triggered.json
Workflow flow
Embeddings Ollama
@n8n/n8n-nodes-langchain.embeddingsOllama
Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader
Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter
Gmail Trigger
Gmail
Manual Trigger
Manual
Create the table
PostgreSQL
Explode interval into weeks
Code
Split Out
Split Out
Was manually triggered?
IF
Set before and after dates
Set
Store structured
PostgreSQL
Loop Over Items
SplitInBatches
No Operation, do nothing
NoOp
Extract email fields
Set
Store vectorized
@n8n/n8n-nodes-langchain.vectorStorePGVector
Get a batch of messages
Gmail
16 steps · flows top to bottom, branches left to right
Browse by integration
Import into n8n
- Download the n8n JSON file (full or sanitized).
- In n8n: Workflows → Import from file.
- Open each node and reconnect credentials to your accounts.
- Test with manual execution before enabling triggers.
Sanitized JSON removes credential IDs — safer for sharing. Flow graph JSON is OpenRuna's lightweight format for diagrams and other tools, not n8n import.
Overview
Free n8n workflow: Gmail to Vector Embeddings with PGVector and Ollama. 20 nodes across embeddingsOllama, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, gmail, splitInBatches, splitOut, manual, postgres, with a downloadable JSON and a visual flow diagram on OpenRuna.
What this workflow does
Built in n8n, "Gmail to Vector Embeddings with PGVector and Ollama" chains 20 nodes to move data between embeddingsOllama, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, gmail, splitInBatches, splitOut, manual, postgres. 20 nodes · embeddingsOllama, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, gmail, splitInBatches, splitOut It starts from a scheduled/triggered trigger and routes data through every node in order. OpenRuna shows the full flow diagram, an integration breakdown, and a one-click JSON export for n8n's "Import from file". Use it to learn integration patterns, fork it for your own use case, or deploy it quickly after reconnecting credentials.
Use cases
- Fork it to add error handling, retries, or a notification step without designing the 20-node flow from scratch.
- Benchmark it against your current embeddingsOllama integration to spot missing steps or redundant nodes.
- Study how data moves from embeddingsOllama to documentDefaultDataLoader before building your own variant.
- Share it with your team as a documented reference for scheduled/triggered automations in the embeddingsOllama stack.
Example output
Imported into n8n, "Gmail to Vector Embeddings with PGVector and Ollama" exposes 20 configured nodes. Trigger type: scheduled/triggered. Integrations: embeddingsOllama, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, gmail, splitInBatches, splitOut, manual, postgres. Set your credentials on the embeddingsOllama node, then verify each downstream node picks them up. Run it once in test mode to verify any branch logic (Switch/IF nodes) before enabling production triggers.
Tips by platform
Claude
Ask Claude to turn the "Gmail to Vector Embeddings with PGVector and Ollama" JSON into a plain-English runbook, node by node. It can flag where embeddingsOllama rate limits or missing retries might bite before you go live.
ChatGPT
Drop the workflow JSON or this OpenRuna page URL into ChatGPT and ask for a step-by-step runbook: triggers, branches, and which fields to customise for embeddingsOllama, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, gmail, splitInBatches, splitOut, manual, postgres. Handy for onboarding teammates new to n8n.
Cursor
In Cursor, ask Agent mode to parameterise "Gmail to Vector Embeddings with PGVector and Ollama" — extract embeddingsOllama IDs and secrets into environment variables without changing the 20-node structure.
Frequently asked questions
- How do I import "Gmail to Vector Embeddings with PGVector and Ollama" into n8n?
- Click Download n8n JSON on this page, then in n8n choose Workflows → Import from file and select the downloaded file. Reconnect credentials on each node — the export carries credential IDs from the original author's instance, not working secrets.
- Which integrations does "Gmail to Vector Embeddings with PGVector and Ollama" use?
- It uses: embeddingsOllama, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, gmail, splitInBatches, splitOut, manual, postgres. The flow diagram above shows how each service connects across the 20 nodes. Filter OpenRuna by integration to find related workflows and tools.
- Can I import a sanitized export without credentials?
- Yes. Use "Download sanitized JSON" to strip credential references before sharing internally. You will still add your own embeddingsOllama and documentDefaultDataLoader credentials in n8n after import.
- What trigger type does "Gmail to Vector Embeddings with PGVector and Ollama" use?
- Trigger type: scheduled/triggered. After import, confirm the trigger node (webhook, schedule, or app event) matches your environment, then activate the workflow when you are ready to run it.
- Is "Gmail to Vector Embeddings with PGVector and Ollama" free to use?
- OpenRuna catalogs community n8n workflows under open licenses. Check the source corpus link for the original license; commercial use may require verifying the third-party API terms for embeddingsOllama, documentDefaultDataLoader, textSplitterRecursiveCharacterTextSplitter, gmail, splitInBatches, splitOut, manual, postgres.
Related resources
- Agent
PraisonAI
24/7 AI employee team for automating complex challenges. Low-code multi-agent framework with handoffs, guardrails, memory, RAG, and 100+ LLM providers
- Agent
Prompt Optimizer
AI prompt optimization tool with multi-round iterative improvements, dual-mode optimization for system and user prompts, and multi-model support. Available as web app, desktop app, Chrome extension, and Docker deployment. AGPL-3.0 licensed
- Agent
Archon
Workflow engine for deterministic AI coding agents. Define development processes as YAML workflows (planning → implementation → validation → review → PR) with isolated Git worktrees for parallel execution. MIT licensed
- Agent
A2A Protocol
Agent2Agent (A2A) open protocol enabling communication and interoperability between opaque agentic applications. Donated to Linux Foundation by Google with 50+ technology partners. Apache 2.0 licensed
- Agent
CAMEL
First and best multi-agent framework for building scalable agent systems. Apache 2.0 licensed with extensive tooling for agent communication and task automation
- Agent
Neuron AI
PHP Agentic Framework for building production-ready AI driven applications. Connect components (LLMs, vector DBs, memory) to agents that can interact with your data. MIT licensed
- Agent
smolagents
Lightweight agent framework centered on tool use and code-executing workflows
- Agent
Supermemory
Memory API and app for AI agents that provides fast, scalable, context-aware storage and retrieval across projects. MIT licensed
