(5/5)

Gmail to Vector Embeddings with PGVector and Ollama

Automated workflow: Gmail to Vector Embeddings with PGVector and Ollama. This workflow integrates 15 different services: stickyNote, textSplitterRecursiveCharacterTextSplitter, code, gmailTrigger, splitOut. It contains 20 nodes and follows best practices for error handling and security.

Integrations Used (2)

Gmail

Postgres

Workflow Structure (17 nodes)

100%

Set

Set before and after dates

Gmail

Get a batch of messages

Set

Extract email fields

Postgres

Store structured

No Op

Embeddings Ollama

No Op

Store vectorized

No Op

Default Data Loader

Was manually triggered?

No Op

No Operation, do nothing

Manual Trigger

Postgres

Create the table

Code

Explode interval into weeks

Split Out

Split In Batches

Loop Over Items

Stop And Error

Error Handler

Gmail Trigger

No Op

Recursive Character Text Splitter

Node Types:

default

trigger

logic

transform

action

code

Requires credentials

Prerequisites

No credentials required!

This workflow can be imported and used immediately.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~35 min

Score: 75/100

Custom Code

Conditional Logic

Loops

6 Integrations

When to Use This Workflow

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "id": "ZiIoKEClTk83g1Jt",
  "meta": {
    "instanceId": "workflow-8bfd2626",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:54.451560",
    "updatedAt": "2025-09-29T07:07:54.451597",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "Gmail to Vector Embeddings with PGVector and Ollama",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...