(5/5)

Colombian Invoices Processing

Automated workflow: Colombian Invoices Processing. This workflow integrates 19 different services: stickyNote, merge, switch, lmChatOpenAi, xml. It contains 29 nodes and follows best practices for error handling and security.

Integrations Used (4)

Gmail

Compression

Google Drive

Google Sheets

Workflow Structure (23 nodes)

100%

Gmail Trigger

On Email receipt

Code

Get Filename and mimeType

Filter

Filter ZIP files only

Compression

Unzip Invoice

Split In Batches

Loop Over Items

Stop And Error

Error Handler

No Op

Just for style

Code

Get filename and mimeType on extracted docs

Switch

Split XML and PDF

Extract From File

Extract PDF Data

Merge

Append both Docs

Aggregate

Aggregate all Data into 1 list

No Op

Extract Data from PDF and XML

Google Drive

Create initial PDF

Merge

Merge both flows

Google Drive

Update PDF with actual name

Code

Get Current Date

Extract From File

Extract XML Data

Xml

Convert to JSON

No Op

OpenAI Chat Model

No Op

Calculator

No Op

Structured Output Parser

Google Sheets

Create or update row

Node Types:

logic

default

trigger

code

transform

action

Requires credentials

Prerequisites

Required Credentials (4)

Gmail

Used by: On Email receipt

Docs

Google Drive

Used by: Create initial PDF, Update PDF with actual name

Docs

Google Sheets

Used by: Create or update row

Docs

OpenAI

Used by: OpenAI Chat Model

Docs

Multiple services required

This workflow needs 4 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

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

Setup time: ~55 min

Score: 95/100

Custom Code

Conditional Logic

Loops

10 Integrations

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

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.

workflow.json

{
  "id": "Xs7x61YMFsbpB4vg",
  "meta": {
    "instanceId": "workflow-abbf51d0",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:43.626346",
    "updatedAt": "2025-09-29T07:07:43.626359",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "Colombian Invoices Processing",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...