Extract Colombian Invoice Data from Drive to Sheets with GPT-4o
Automates AI-powered extraction of structured data from Colombian invoices (PDFs/JPGs) in Google Drive, handling taxes like Retefuente, and exports to Google Sheets for finance tracking.
This workflow streamlines invoice processing for Colombian businesses by triggering on new or updated files in a Google Drive folder. It downloads the file, routes PDFs for direct text extraction and JPEGs for AI-based OCR using Azure OpenAI, then employs specialized Reasoning Agents to parse key data like vendor name, modification date, line items (description, subtotal, IVA, total, category), and Colombian-specific taxes (Retefuente, ReteICA).
A Structured Output Parser ensures consistent JSO
- Platform
- n8n
- Category
- Business Operations & ERPs
- Price
- $24.99
- Creator
- Jordi Faber
- Invoice Processing
- Google Drive
- Google Sheets
- AI Extraction
- OCR
- Colombian Tax
- PDF Parsing
- JPEG OCR
- Finance Automation
- Azure OpenAI
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Business Operations & ERPs workflows
- Automate Job Applications and Track Status with LinkedIn, Indeed, and Google Sheets$14.99
- Automated Stock Price Monitoring and Alerts for Indian & US Markets$9.99
- Build Custom Workflows Automatically with GPT-4o, RAG, and Web Search$24.99
- AI Chat Agent Receptionist for Clinics$150
- Automatically Archive Zoom Recordings to Google Drive and Log in Airtable$4.99
- Automate Call Scheduling with Voice AI Receptionist Using Twilio, Google Calendar & Airtable$24.99
More from Jordi Faber
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.