Match vendor invoices with POs and GRNs in Google Sheets and notify Finance via Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs when someone submits an n8n form (“Vendor Invoice Submission”). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Vendor Invoice Submission”).
- Set Invoice Fields (Edit Fields (Set)): sets 15 fields: vendorName, vendorId, invoiceNumber…
- Set Workflow Configurations (Edit Fields (Set)): sets 1 field: financeEmail
- Read Invoice Register (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Email Duplicate Invoice Warning (Gmail): uses Gmail
- Append Invoice to Register (Google Sheets): append
- Read Purchase Orders (Google Sheets): uses Google Sheets
- Read Goods Receipts (Google Sheets): uses Google Sheets
- Execute 3-Way Match Logic (Code): runs custom JavaScript code
- Check 3-Way Match Outcome (If): checks a condition and branches into true / false
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow collects vendor invoices via an n8n form, checks Google Sheets for duplicates, performs a PO/GRN/invoice 3-way match against Google Sheets reference data, updates the invoice status, and sends payment-ready or exception…