AP Vendor Invoice Routing Workflow (n8n) w/ Jev + Google Sheets

Automatically route vendor invoices to the right AP action—using n8n + Jev + Google Sheets

This AP Vendor Invoice Routing Workflow (n8n) receives invoice submissions via a webhook, evaluates completeness with Jev Classification, logs routing decisions to Google Sheets, notifies Accounts Payable through Gmail and Telegram, and emails a daily backlog brief generated with OpenAI.

What this workflow does

• Accepts invoices via POST webhook with invoice_id, vendor_name, and invoice_text.
• Rejects incomplete submissions: if invoice_text is missing/empty, the workflow emails the AP team in Gmail with the reason.
• Classifies invoice completeness with Jev by assessing whether PO/reference, amount, vendor identity, bank details, and currency are present—returning an overall completeness score.
• Derives a missing-details list and applies confidence gates to determine the appropriate route.
• Routes invoices to one of: ready for payment run, vendor follow-up, or human AP review.
• Logs everything to Google Sheets by appending invoice + decision details to the “Invoice Intake” tab.
• Prevents duplicates for the ready route: checks Google Sheets for an existing invoice_id; if duplicate, alerts AP via Telegram, otherwise emails AP via Gmail to queue the invoice for three-way match.
• Sends a daily 17:00 backlog brief: reads the Google Sheets log, summarizes route counts, generates a short brief using OpenAI (LangChain agent), and emails it to the AP team.

Use cases

• Centralize vendor invoice intake from internal tools or vendor portals into a single n8n webhook.
• Automatically triage invoices that are missing PO/reference, amounts, bank details, or currency.
• Reduce AP processing time with duplicate detection before three-way match queueing.
• Keep AP teams informed with automated Gmail + Telegram alerts and a daily OpenAI-generated backlog summary.

Technical details

• n8n nodes/integrations: webhook, if, set, switch, gmail, telegram
• AI/Classification: Jev Classification for completeness questions and scoring
• Data storage: Google Sheets (“Invoice Intake” tab)
• Daily automation: 17:00 schedule + OpenAI via LangChain agent to draft backlog email