Skip to content
agentusehub

Validate invoices against inventory and create purchase orders

An n8n workflow built for a client matches invoice data to a Google Sheets inventory, creates ERP purchase orders and notifies purchasing; about 90% of invoices are handled automatically.

Time saved
Not reported
Setup time
Not reported
Running cost
Not reported
Cost range
Not reported

Use case overview

An n8n workflow built for a client matches invoice data to a Google Sheets inventory, creates ERP purchase orders and notifies purchasing; about 90% of invoices are handled automatically.

Reported experience

  1. What they did

    A 23-node n8n workflow watches the client's Gmail for invoice emails, pulls out the PDF attachments and sends them to OpenAI's vision model to extract vendor, amount, items and dates. It checks the data against a Google Sheets inventory. If items match and amounts look reasonable, it creates an ERP purchase order, posts to Slack and replies to the sender.

  2. How it went

    The client went from manually handling 40-50 invoices a week to about 90% processed automatically, saving roughly 8-10 hours weekly. The author built it in 3 days, mostly handling edge cases, then trained the operations manager in about 2 hours.

  3. Worth knowing

    n8n counts every node run as an execution, so each invoice uses about 23. At 200 invoices a month, the author says the Pro plan is the minimum.

Example prompts

Try with n8n
Build me an n8n workflow that triggers when a new invoice arrives at [email inbox or folder], extracts the vendor, line items and quantities, and checks them against my inventory in [Google Sheets link]. If items are low or match a reorder rule, create a purchase order in [ERP or tool] and notify [purchasing contact] on [Slack or email]. Send anything it can't match to a review list instead of acting on it, and pause to show me the purchase order it is about to create before you enable the live version.
Sales · Beginner
  1. Form submit
  2. Fetch company site
  3. Claude scores fit

Auto-qualify inbound leads before a rep sees them

Score every demo request against your ICP, update HubSpot and ping the right rep in Slack within a minute of the form submit.

n8n · Claude · HubSpot · Slack
Customer Support · Intermediate
  1. New ticket webhook
  2. Claude classifies
  3. Draft from help docs

Triage support tickets and draft first replies

Every new Zendesk ticket gets a category, priority and sentiment tag plus a draft reply in an internal note before an agent opens it.

Zendesk · n8n · Claude