Automated Invoice Verification with Gmail, Drive, Sheets & OCR AI

This n8n workflow streamlines invoice processing by automatically fetching PDFs from specific vendor emails (e.g., abc@company.com) Monday to Saturday. It extracts invoice dates from subjects, creates organized month/day folders in Google Drive, and uploads files for secure storage.

Using OCR and AI agents, it extracts structured data like item names, quantities, rates, and HSN codes from PDFs, then stores it in a 'Store Invoice Data' Google Sheet. It cross-validates each line against a 'Store Master Data' sheet, checking for mismatches in item codes, names, and prices, while calculating differences and totals.

Finally, it generates a summary email with processing results and alerts for discrepancies. Ideal for SMEs, startups, procurement, and accounts teams, this plug-and-play template ensures 99% accuracy, reduces errors, and frees up hours daily for high-value tasks.