Description
Summary Developed an automated invoice extraction system that reads incoming invoices and logs their key details into a spreadsheet without any manual data entry. The system replaces the tedious task of opening each invoice and typing out vendor names, amounts, and dates with a smart AI-driven workflow that captures and organizes invoice data automatically. Built using n8n workflow orchestration and OpenAI GPT-4o, the system monitors a dedicated email inbox for incoming invoices, triggers instantly on each new attachment, and uses an AI extraction layer to pull the key fields. Vendor, invoice number, total amount, tax, and date into a clean, structured format. The extracted data is synced in real time to Google Sheets, giving the business an always-up-to-date record of every invoice received. The owner gets an instant Slack or email notification each time a new invoice is logged, so nothing slips through. Key Highlights - AI-Powered Invoice Field Extraction using OpenAI GPT-4o - Automatic Email-Inbox Monitoring & Trigger - Structured Data Capture (Vendor, Amount, Tax, Date, Invoice #) - Real-Time Google Sheets Logging - Instant Slack / Email Notifications - Clean, Modular n8n Workflow Tech Requirements n8n • OpenAI GPT-4o • Gmail API • Google Sheets API • Slack API