{"product_id":"ap-vendor-invoice-routing-workflow-n8n-w-jev-google-sheets","title":"AP Vendor Invoice Routing Workflow (n8n) w\/ Jev + Google Sheets","description":"\u003ch3\u003eAutomatically route vendor invoices to the right AP action—using n8n + Jev + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eAP Vendor Invoice Routing Workflow (n8n)\u003c\/strong\u003e receives invoice submissions via a webhook, evaluates completeness with \u003cstrong\u003eJev Classification\u003c\/strong\u003e, logs routing decisions to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, notifies Accounts Payable through \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e, and emails a \u003cstrong\u003edaily backlog brief\u003c\/strong\u003e generated with \u003cstrong\u003eOpenAI\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccepts invoices via POST webhook\u003c\/strong\u003e with \u003cem\u003einvoice_id\u003c\/em\u003e, \u003cem\u003evendor_name\u003c\/em\u003e, and \u003cem\u003einvoice_text\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRejects incomplete submissions\u003c\/strong\u003e: if \u003cem\u003einvoice_text\u003c\/em\u003e is missing\/empty, the workflow emails the AP team in \u003cstrong\u003eGmail\u003c\/strong\u003e with the reason.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies invoice completeness with Jev\u003c\/strong\u003e by assessing whether PO\/reference, amount, vendor identity, bank details, and currency are present—returning an overall completeness score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDerives a missing-details list\u003c\/strong\u003e and applies confidence gates to determine the appropriate route.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes invoices\u003c\/strong\u003e to one of: \u003cem\u003eready for payment run\u003c\/em\u003e, \u003cem\u003evendor follow-up\u003c\/em\u003e, or \u003cem\u003ehuman AP review\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs everything to Google Sheets\u003c\/strong\u003e by appending invoice + decision details to the \u003cstrong\u003e“Invoice Intake”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates for the ready route\u003c\/strong\u003e: checks Google Sheets for an existing \u003cem\u003einvoice_id\u003c\/em\u003e; if duplicate, alerts AP via \u003cstrong\u003eTelegram\u003c\/strong\u003e, otherwise emails AP via \u003cstrong\u003eGmail\u003c\/strong\u003e to queue the invoice for three-way match.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a daily 17:00 backlog brief\u003c\/strong\u003e: reads the Google Sheets log, summarizes route counts, generates a short brief using \u003cstrong\u003eOpenAI (LangChain agent)\u003c\/strong\u003e, and emails it to the AP team.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCentralize vendor invoice intake from internal tools or vendor portals into a single n8n webhook.\u003c\/li\u003e\n  \u003cli\u003eAutomatically triage invoices that are missing PO\/reference, amounts, bank details, or currency.\u003c\/li\u003e\n  \u003cli\u003eReduce AP processing time with duplicate detection before three-way match queueing.\u003c\/li\u003e\n  \u003cli\u003eKeep AP teams informed with automated Gmail + Telegram alerts and a daily OpenAI-generated backlog summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/integrations\u003c\/strong\u003e: \u003cem\u003ewebhook, if, set, switch, gmail, telegram\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI\/Classification\u003c\/strong\u003e: \u003cstrong\u003eJev Classification\u003c\/strong\u003e for completeness questions and scoring\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage\u003c\/strong\u003e: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (“Invoice Intake” tab)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily automation\u003c\/strong\u003e: 17:00 schedule + \u003cstrong\u003eOpenAI via LangChain agent\u003c\/strong\u003e to draft backlog email\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086655836339,"sku":"N8N-19907","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Pa2J2Gi2favOA97zIb4df_D3EJq3Gx.png?v=1790327357","url":"https:\/\/buyflowscripts.com\/products\/ap-vendor-invoice-routing-workflow-n8n-w-jev-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}