Supplier invoices captured automatically, straight from the inbox
Problem
The ops team hand-keyed supplier invoices from a dozen vendors, each with a different PDF layout, into spreadsheets. It was a standing weekly job and unit prices were always days out of date.
Build
An Apps Script watcher pulls each invoice PDF from Gmail and passes it to a Document AI parser that reads any layout and returns structured line items. Per-supplier tabs auto-populate with SKU, pack price, and unit cost, with dedup and a daily summary email.
Result
Invoice entry stopped being a manual job and the master price list refreshes on its own. What used to be a recurring weekly chore now runs unattended, with the team looking only at what the parser flags.
Invoice entry
Hand-keyed to parsed
Layout handling
Any supplier format
Price list refresh
Daily, automatic