Extract and Organize Colombian Invoices with Gmail, GPT-4o & Google Workspace

Say goodbye to manual invoice sorting!

This automation processes personal invoices received via Gmail in Colombia, extracting key financial data from DIAN-compliant ZIP attachments and organizing everything into Google Sheets and Drive — all hands-free.

Whether you're managing personal finances or preparing for tax season, this workflow simplifies invoice handling and ensures nothing slips through the cracks.

What it does:

📩 Polls Gmail for DIAN ZIP attachments every 30 minutes
📂 Extracts and filters PDFs + XML files from ZIPs
🧠 Uses AI to extract key fields (NIT, totals, CUFE, etc.)
🧮 Validates totals with built-in calculator logic
📤 Uploads original PDF to Drive with renamed format
📊 Updates Google Sheets with deduplication logic

✅ Setup guide & importable automation included

Need help setting it up? We offer full configuration and testing for a one-time fee.