OpenRuna
Sign in
← Workflows

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

IntegrationsEmbeddingsOllamaDocumentDefaultDataLoaderTextSplitterRecursiveCharacterTextSplitterGmailSplitInBatchesSplit OutManualPostgreSQLVectorStorePGVector@n8n/n8n-nodes-langchain.embeddingsOllama@n8n/n8n-nodes-langchain.documentDefaultDataLoader@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter+5 more
100%

Embeddings Ollama

@n8n/n8n-nodes-langchain.embeddingsOllama

Default Data Loader

@n8n/n8n-nodes-langchain.documentDefaultDataLoader

Recursive Character Text Splitter

@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter

TRIGGER

Gmail Trigger

Gmail

TRIGGER

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

Browse all integrations →

Import into n8n

  1. Download the n8n JSON file (full or sanitized).
  2. In n8n: Workflows → Import from file.
  3. Open each node and reconnect credentials to your accounts.
  4. 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.

View source corpus ↗

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