Extract invoices from email into Google Sheets with approval

Accounts-payable teams still re-type supplier invoices from email into a spreadsheet. This workflow watches an invoice mailbox, sends each PDF or image attachment to a vision model, and returns the vendor, invoice number, dates, currency, subtotal, tax and total as structured fields. The model is told to copy what is printed and never to calculate, so an unreadable amount stays empty instead of turning into a wrong number.

Plain code then checks the result: required fields, subtotal plus tax against total, line items against subtotal, impossible or old dates, low confidence, and whether the same invoice number from the same vendor is already in your ledger sheet. Mentions of changed bank details are flagged for a call-back, a common invoice-fraud pattern. Documents that are not invoices (statements, quotes, newsletters) are ignored.

Every invoice then waits for a person in the Cadrix approval inbox. The approver sees the extracted values next to the list of things to check, and can add a note. Only an approved invoice is appended to your Google Sheet. The workflow never pays anything and never emails the supplier. It works with any IMAP mailbox, including Gmail and Microsoft 365.