What this template does
Accounts payable is repetitive, error-prone, and slow when done by hand. This workflow automates it end to end. Supplier invoices arriving by email are read with OCR, validated against your vendor list and purchase orders, routed for approval based on amount, then posted as bills in QuickBooks. The PDF is archived to Google Drive and a confirmation goes back to the supplier.
This is an advanced template: OCR accuracy, validation rules, and approval routing all need real-world tuning. Done right, it turns a multi-day approval cycle into minutes for routine invoices.
How it works
The trigger is a new email with an invoice attachment. The flow:
- Extracts the PDF attachment from the email.
- Uses OCR to read the invoice details.
- Parses invoice number, date, amount, and vendor.
- Looks up the vendor in QuickBooks.
- Extracts line items and amounts.
- Matches against a PO if one is provided.
- Routes to an approver based on amount.
- Waits for approval.
- Creates the bill in QuickBooks.
- Saves the PDF to Google Drive and sends a confirmation email.
Setup steps
- Create a Gmail label “Invoices”, filter supplier emails into it, and grant n8n access to Gmail.
- Create QuickBooks credentials, set up your vendor list, and configure expense accounts.
- Add the invoice email trigger, extract PDF or image attachments, and run OCR to pull the data.
- Validate: check the invoice number format, verify the vendor exists, cross-reference the PO, and confirm currency and amounts.
- Build the approval workflow: route by amount, create a Slack approval task, require manual approval above 5,000 dollars, and auto-approve verified invoices under 500 dollars.
- Post to QuickBooks (bill with line items, linked to the PO, marked received), then archive the PDF to Google Drive, update the tracking sheet, and email the supplier.
When to use it
Use this for vendor invoice processing, expense report handling, three-way matching (PO, receipt, invoice), and general AP automation. The clearest wins come where invoice volume is high and approval delays cost you early-payment discounts or strain supplier relationships.
Need this customized? Let’s talk.
