Automated Colombian Invoice Processing Pipeline

This n8n workflow automates the process of extracting, organizing, and managing electronic invoices received via Gmail in Colombia. It triggers every 30 minutes to scan emails for ZIP attachments containing invoices, extracts relevant financial data from embedded PDF and XML files using OpenAI’s GPT-4 model with LangChain, and verifies data integrity such as total calculations. The workflow then uploads the original invoice PDFs to Google Drive, renames the files according to emission date and invoice number, and updates a Google Sheets database with detailed invoice information, ensuring no duplication through unique keys. Designed for personal or small business use, this automation streamlines compliance with Colombian digital invoicing requirements, reduces manual effort, and enables quick financial data retrieval and storage.