Skip to Workflow Atlas
ETL PipelineAI systemIntermediate

Email to Vector Database Workflow

Email to Vector Database Workflow is a 16-node automation blueprint connecting Gmail, LangChain, PostgreSQL. Inspect its trigger, execution graph, branches, and implementation requirements.

Interactive system map

Follow the runtime. Inspect what supports it.

Solid horizontal paths show main-channel execution. Violet dependencies sit beneath the exact step they configure or empower.

16

Nodes

17

Links

1

Run groups

Connected tools

4 integrations

  • Gmail
  • LangChain
  • PostgreSQL
  • PGVector

Canvas controls

Fit wide systems, then zoom into any run group.

Email to Vector Database Workflow execution lanes1 run groups containing 16 workflow nodes and 17 visible links. Solid horizontal lines are main-channel runtime links. Violet dashed lines connect typed dependencies beneath the runtime step they support. Focus any node to inspect its immediate path.Manual Trigger. trigger node, manualTrigger. 0 incoming and 1 outgoing connections.STARTManual TriggerTRIGGERMANUALTRIGGER0 IN / 1 OUTGmail Trigger. Gmail node, gmailTrigger. 0 incoming and 1 outgoing connections.STARTGmail TriggerGMAILGMAILTRIGGER0 IN / 1 OUTCreate the table. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 02Create the tablePOSTGRESQLPOSTGRES1 IN / 1 OUTExplode interval into weeks. transform node, code. 1 incoming and 1 outgoing connections.STEP 03Explode interval into weeksTRANSFORMCODE1 IN / 1 OUTSplit Out. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 04Split OutTRANSFORMSPLITOUT1 IN / 1 OUTLoop Over Items. integration node, splitInBatches. 3 incoming and 1 outgoing connections.STEP 05Loop Over ItemsINTEGRATIONSPLITINBATCHES3 IN / 1 OUTSet before and after dates. transform node, set. 1 incoming and 1 outgoing connections.STEP 06Set before and after datesTRANSFORMSET1 IN / 1 OUTGet a batch of messages. Gmail node, gmail. 1 incoming and 1 outgoing connections.STEP 07Get a batch of messagesGMAILGMAIL1 IN / 1 OUTExtract email fields. transform node, set. 2 incoming and 1 outgoing connections.STEP 08Extract email fieldsTRANSFORMSET2 IN / 1 OUTStore structured. PostgreSQL node, postgres. 1 incoming and 2 outgoing connections.STEP 09Store structuredPOSTGRESQLPOSTGRES1 IN / 2 OUTStore vectorized. ai node, vectorStorePGVector. 3 incoming and 1 outgoing connections.STEP 10Store vectorizedAIVECTORSTOREPGVECTOR3 IN / 1 OUTWas manually triggered?. decision node, if. 1 incoming and 2 outgoing connections.STEP 11Was manually triggered?DECISIONIF1 IN / 2 OUTNo Operation, do nothing. integration node, noOp. 1 incoming and 0 outgoing connections.OUTCOMENo Operation, do nothingINTEGRATIONNOOP1 IN / 0 OUTEmbeddings Ollama. ai node, embeddingsOllama. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Embeddings OllamaAIEMBEDDINGSOLLAMA0 IN / 1 OUTDefault Data Loader. ai node, documentDefaultDataLoader. 1 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Default Data LoaderAIDOCUMENTDEFAULTDATALOAD1 IN / 1 OUTRecursive Character Text Splitter. ai node, textSplitterRecursiveCharacterTextSplitter. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 2Recursive Character Text …AITEXTSPLITTERRECURSIVECH0 IN / 1 OUT

Signal inspector

Focus, hover, or select a step to isolate its runtime and support links.

Main-channel runtimeTyped dependencytriggeraidecisiontransformintegration
Scroll horizontally to follow every connected flow.16 connected nodesEnter or click to lock · Escape to clear

Runtime breakdown

Read the execution spine before its dependencies.

Each run group separates main-channel steps from the models, tools, retrievers, and data services that support them. Start and outcome labels apply only to runtime nodes.

01

Run Group

Manual Trigger

14 Execution Links3 Support Dependencies
  1. Start

    Manual Trigger

    Trigger

    Gmail Trigger

    Trigger

  2. Step 2

    Create the table

    Integration

  3. Step 3

    Explode interval into weeks

    Transform

  4. Step 4

    Split Out

    Transform

  5. Step 5

    Loop Over Items

    Integration

  6. Step 6

    Set before and after dates

    Transform

  7. Step 7

    Get a batch of messages

    Integration

  8. Step 8

    Extract email fields

    Transform

  9. Step 9

    Store structured

    Integration

  10. Step 10

    Store vectorized

    AI reasoning

  11. Step 11

    Was manually triggered?

    Decision

  12. Outcome

    No Operation, do nothing

    Integration

Attached dependencies

These nodes support the runtime above; they are not additional starts or outcomes.

3 nodes
  • Embeddings Ollama

    AI reasoning dependency

  • Default Data Loader

    AI reasoning dependency

  • Recursive Character Text Splitter

    AI reasoning dependency

Turn the map into a plan

Adapt this blueprint to your company.

Bring the system shape into a workspace, then define the production controls, data boundaries, owners, and delivery sequence around your context.