Audit procurement compliance with Google Sheets, Google Gemini, and 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 AI workflow has 15 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Google Gemini Chat Model and Gmail.
How it runs
Trigger: On a schedule (every day).
- Fetch Procurement Data (Google Sheets): uses Google Sheets
- Fetch Regulatory Rules (Google Sheets): uses Google Sheets
- Edit Fields - Enrich Audit Metadata (Edit Fields (Set)): sets 11 fields: audit_id, audit_timestamp, review_period…
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Validate Batch Summary Record (If): checks a condition and branches into true / false
- Generate AI Compliance Audit Report (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- If: checks a condition and branches into true / false
- Edit Fields - Compose Final Output (Edit Fields (Set)): sets 25 fields: audit_id, audit_timestamp, review_period…
- Google Sheets: append
…plus 3 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 (9)
- Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This scheduled workflow audits procurement transactions from Google Sheets against regulatory rules, generates a batch compliance report with Google Gemini, logs transaction-level alerts and reports back to Google Sheets, and emails the…