Find new invoice emails
Every hour the flow searches Gmail for unread emails with "Invoice" in the subject and an attachment. It then fetches the email details and downloads the file.
Read vendor invoices from Gmail with AI, check them against SAP Business One purchase orders and post a line-by-line match report to Microsoft Teams
Apps used in this template
About this template
AP teams spend hours keying vendor invoices and checking them against purchase orders by hand. Every hour, this template finds unread Gmail invoices with attachments, extracts the data with OpenAI, finds the PO in SAP Business One by PO number and posts a line-by-line match report to Microsoft Teams.
Key benefits
Inside the flow
Every hour the flow searches Gmail for unread emails with "Invoice" in the subject and an attachment. It extracts the invoice with OpenAI, looks up the PO in SAP Business One and posts the match result to Microsoft Teams.
Every hour the flow searches Gmail for unread emails with "Invoice" in the subject and an attachment. It then fetches the email details and downloads the file.
OpenAI reads the decoded document and returns the vendor name, PO number, totals and line items. Each line holds SKU, description, quantity and unit price.
If no valid invoice data comes back, the flow posts an alert to Microsoft Teams. Nothing else runs for that email.
The flow searches SAP Business One for a PO with the extracted PO number. If none exists, Microsoft Teams is told so the invoice can be handled by hand.
If the PO has no shipment received status, the flow alerts Microsoft Teams to hold the payment. Only received POs go on to matching.
An AI agent compares the invoice and PO line by line on SKU, quantity, unit price and subtotal tolerance. The result, with any mismatch reasons, is posted to Microsoft Teams.
What AP and finance teams gain when invoice checks run on their own
01
AP staff stop opening each PDF and comparing it to the PO by hand.
02
Each SKU, quantity and unit price is compared against the SAP Business One PO.
03
Missing POs, unreceived goods and unmatched SKUs are flagged before anyone pays.
04
Invoices for POs without a received shipment are flagged for hold in Microsoft Teams.
05
AP and operations see the same match report in Microsoft Teams.
01
AP staff stop opening each PDF and comparing it to the PO by hand.
02
Each SKU, quantity and unit price is compared against the SAP Business One PO.
03
Missing POs, unreceived goods and unmatched SKUs are flagged before anyone pays.
04
Invoices for POs without a received shipment are flagged for hold in Microsoft Teams.
05
AP and operations see the same match report in Microsoft Teams.
Keep exploring
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Every trigger and action this template uses is available in the appse ai builder, so the same flow can be rebuilt with your own routing, thresholds and destinations.
No triggers for Gmail.
Questions & answers
Everything you need to know about this template before you deploy it.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Start free — no credit card, no setup calls required. Use this template as-is or customize every step inside the appse ai no-code builder and go live today.