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.