See llms.txt for all machine-readable content.

Back to Templates

Extract and organize Colombian invoices with Gmail, GPT-4o & Google Workspace

Created by

Created by: Juan Sanchez || juansave
Juan Sanchez

Last update

Last update 8 months ago

Categories

馃Ь Personal Invoice Processor

This N8N workflow automates the extraction and organization of personal 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).
    • Expects ZIP file following DIAN standards.

  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.