Automated invoice processing pipeline that extracts data from PDFs, creates contacts and invoices in Xero, and logs transactions, reducing manual processing time by 85% with 99% accuracy.
n8n · workflow canvasproduction build
Context
Finance teams spent hours manually extracting data from invoice PDFs, creating contacts in Xero, entering invoice details, and logging transactions for bookkeeping records.
Approach
Built automated n8n workflow triggered by Google Drive uploads that uses OpenAI with structured output parsing to extract invoice data, automatically creates or updates Xero contacts and invoices, and logs all transactions to Google Sheets for audit trails.