Match and approve invoices with Google Sheets, Groq Llama 3.3, Notion and Gmail

by WeblineIndia ✓ · 25 views · created 2026-08-20 · Invoice Processing, AI RAG

What this workflow does

This AI workflow has 28 nodes and runs on a schedule (every day at 07:00). Along the way it connects Google Sheets, Notion, Gmail and Groq Chat Model.

How it runs

Trigger: On a schedule (every day at 07:00).

1. fetch good receipt (Google Sheets): uses Google Sheets
2. Fetch Purchase Order (Google Sheets): uses Google Sheets
3. fetch invoice data (Google Sheets): uses Google Sheets
4. Filter: Valid Pending Invoices Only (If): checks a condition and branches into true / false
5. Merge & Similarity Scoring (Code): runs custom JavaScript code
6. Resolve Best Match per Invoice (Code): runs custom JavaScript code
7. Route: Decision Path via Match Score (Switch): routes items into 3 branches
8. Prepare: Approval Metadata (Edit Fields (Set)): sets 3 fields: decision, reason, timestamp
9. Prepare: Rejection Metadata (Edit Fields (Set)): sets or maps fields
10. Retain Original Transaction Data (Edit Fields (Set)): sets 1 field: timestamp

…plus 15 more steps. See the full node list below.

Services it uses

Google SheetsNotionGmailGroq Chat Model

Before you upgrade to n8n 3.0

Nodes used (11)

• Google Sheetsn8n-nodes-base.googleSheets
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• Switchn8n-nodes-base.switch
• Edit Fields (Set)n8n-nodes-base.set
• Notionn8n-nodes-base.notion
• Gmailn8n-nodes-base.gmail
• Groq Chat Model@n8n/n8n-nodes-langchain.lmChatGroq
• AI Agent@n8n/n8n-nodes-langchain.agent
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

Quick overview This workflow runs daily to three-way match invoices against purchase orders and goods receipts in Google Sheets, using fuzzy similarity scoring plus Groq Llama 3.3 semantic checks to approve, reject with Gmail alerts, or escalate for a…

View the original on n8n.io → Check your own copy