AI-Powered Invoice Parser from Outlook Emails

This n8n workflow automates invoice processing by monitoring an Outlook mailbox for incoming messages from suppliers. It intelligently identifies emails containing invoices, downloads attachments, filters out non-invoice documents using AI vision classification, and extracts key details like amounts, dates, and vendor info via Google Gemini AI. The structured data is then appended to an Excel workbook for easy reconciliation.

The workflow starts with a scheduled trigger fetching recent emails, followed by AI analysis to confirm invoice relevance. Attachments are processed sequentially: first classified, then parsed for data extraction. Duplicate prevention and customizable filters ensure reliability. It handles PDFs primarily but notes extensions for other formats.

Ideal for accounts receivable teams, it eliminates manual data entry, reduces errors, and accelerates processing. Use cases include AP/AR automation, audit trails, and integration with accounting software. Benefits include massive time savings, scalability for high-volume inboxes, and AI-driven accuracy improving over time with feedback.

Setup requires Microsoft 365 credentials for the target mailbox (supports shared folders), Google Gemini API for AI tasks, and Excel/OneDrive access. Customize by adding duplicate checks, human review loops, or outputs to ERPs/CRMs for full automation.