Hi everyone,
I built this scenario to reconcile supplier invoices against purchase orders automatically, sharing it on my YouTube channel this week (link above).
How to Automate Invoice & PO Reconciliation with an AI Ag
The flow:
Gmail → Make → Google Cloud Vision → Make AI Agent → Google Sheets
STEP 1:Trigger and capture
Gmail: Watch Emails detects the incoming invoice. Gmail: List Email Attachments and Media retrieves the attachment, which is uploaded to Google Drive for storage.
STEP 2:OCR and identifiers
Google Cloud Vision: Run Text Detection reads the full text of the invoice. Two Text Parser: Match Pattern modules extract the invoice number and the PO number from that text.
STEP 3:Retrieve the matching PO
Google Drive: Search for Files/Folders uses the extracted PO number to locate the correct purchase order automatically in a reference folder.
STEP 4:AI reconciliation
Both documents are passed to a Make AI Agent. It compares every line item and classifies each one as a match, a semantic match, a discrepancy, or unmatched, then returns an overall status: APPROVED, DISCREPANCY_FOUND, or ESCALATED.
STEP 5 — Log the result
JSON: Parse JSON extracts the agent’s structured output. Google Sheets: Add a Row logs the date, PO number, invoice number, status, and the agent’s reasoning.
When an invoice arrives by email, OCR extracts its text, the matching PO is retrieved automatically, and an AI agent compares every line: matching items even when the wording differs, flagging real discrepancies, and escalating anything it can’t confidently verify instead of guessing.
Tested on three cases: one matched despite different wording, one flagged for a quantity mismatch, one escalated for an unmatched line item. Every result is logged with the agent’s reasoning.
Happy to discuss.





