Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Finance, Invoices & Accounting

Finance, Invoices & Accounting

Process Colombian Electronic Invoices with OpenAI

When an email with zipped invoices arrives in Gmail, it unzips them, OpenAI extracts the data, files go to Google Drive and rows are added to Google Sheets.

Import it free Sign in to open it

What it does

# 🧾 Colombian electronic invoices processing This N8N workflow automates the extraction and organization of personal electronic invoices in Colombia received via Gmail. It includes the following key steps: ## 🔁 Flow Summary 1. Email Trigger - Polls Gmail every 30 minutes for emails with .zip attachments (assumed to contain invoices). - Following DIAN requirements in Colombia 2. ZIP File Handling - Extracts all files. - Filters only PDF and XML files for processing. 3. Data Extraction & Processing - Uses LangChain Agent + OpenAI (GPT-4o-mini) to extract: - Tipo de documento (Factura / Nota Crédito) - Número de factura - Fecha de emisión (YYYY-MM-DD) - NIT emisor y receptor (sin dígito de verificación) - Razón social del emisor - Subtotal, IVA, Total - CUFE - Resumen de compra (max 20 words, formatted sentence) 4. Validation - Ensures Total = Subtotal + IVA using a calculator node. 5. Storage - Uploads the original PDF to Google Drive. - Renames the file to: YYYY-MM-DD-NUMERO_FACTURA.pdf. - Inserts or updates invoice details in Google Sheets using a unique Key (NIT_Emisor + Numero_Factura) to prevent duplication. --- > ⚙️ Designed for personal use with minimal latency tolerance and high automation reliability.

The steps

  1. Loop Over Items
  2. OpenAI Chat Model
  3. Calculator
  4. Structured Output Parser
  5. On Email receipt
  6. Get Filename and mimeType
  7. Filter ZIP files only
  8. Unzip Invoice
  9. Just for style
  10. Get filename and mimeType on extracted docs
  11. Split XML and PDF
  12. Extract PDF Data
  13. Extract XML Data
  14. Convert to JSON

22 steps in total.

Similar automations

Documents, PDF & OCRProcess Colombian Invoices from Gmail with OpenAI29 stepsDocuments, PDF & OCRColombian Invoices Processing23 stepsFinance, Invoices & AccountingGet the Colombian Peso TRM Exchange Rate via Telegram29 stepsFinance, Invoices & AccountingExtract and Validate Invoices with OpenRouter, Sheets and Gmail34 steps