Colombian Invoices Processing

Manual

High

Nodes

Manual

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

merge

Merge both flows, Append both Docs

2 nodes

split In Batches

Loop Over Items

1 node

lm Chat Open Ai

OpenAI Chat Model

1 node

tool Calculator

Calculator

1 node

output Parser Structured

Structured Output Parser

1 node

gmail Trigger

On Email receipt

1 node

code

Get Filename and mimeType, Get filename and mimeType on extracted docs, Get Current Date

3 nodes

filter

Filter ZIP files only

1 node

compression

Unzip Invoice

1 node

no Op

Just for style

1 node

switch

Split XML and PDF

1 node

extract From File

Extract PDF Data, Extract XML Data

2 nodes

xml

Convert to JSON

1 node

aggregate

Aggregate all Data into 1 list

1 node

agent

Extract Data from PDF and XML

1 node

google Drive

Create initial PDF, Update PDF with actual name

2 nodes

google Sheets

Create or update row

1 node

sticky Note

Sticky Note

1 node

Workflow JSON

24.86 KB

{
  "id": "Xs7x61YMFsbpB4vg",
  "meta": {
    "instanceId": "51270372ea87f40bc06437a6d111ae29e684e524a2e6c52d7a6f84dde18d4a17",
    "templateCredsSetupCompleted": true
  },
  "name": "Colombian Invoices Processing",
  "tags": [],
  "nodes": [
    {
      "id": "3bcb9b75-a697-4948-974a-f4ea29947bfa",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        880,
        445
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "03076b82-d824-4fe1-b659-7fbfa2f3fd87",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        2420,
        790
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "BfhecJBx32L0a2gT",
          "name": "OpenAi accou...

Showing first 1000 characters. Click "Expand" to view the full JSON.