Detect maverick spend and alert reviewers via Slack, Gmail, Sheets and Gemini

by WeblineIndia ✓ · 4 views · created 2026-06-24 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 17 nodes and runs on a schedule (every day at 11:00). Along the way it connects Google Sheets, Google Gemini, Slack and Gmail.

How it runs

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

1. Get Approved Supplier List (Google Sheets): uses Google Sheets
2. Get Pending Transactions (Google Sheets): uses Google Sheets
3. Clean & Normalize Transaction Data (Edit Fields (Set)): sets 5 fields: supplier_name, amount, department…
4. Merge: merges the data from its input branches
5. Detect Maverick Spend (Unapproved Supplier) (Code): runs custom JavaScript code
6. Check Maverick Spend Condition (If): checks a condition and branches into true / false
7. Generate AI Compliance Suggestions (Google Gemini): uses Google Gemini
8. Skip Approved Supplier (No Action) (Edit Fields (Set)): sets 4 fields: transaction_id, supplier_name, processed…
9. Format AI Output & Add Timestamp (Code): runs custom JavaScript code
10. Mark Approved Transaction as Processed (Google Sheets): update

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

Services it uses

Google SheetsGoogle GeminiSlackGmail

Before you upgrade to n8n 3.0

Nodes used (10)

• Google Sheetsn8n-nodes-base.googleSheets
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Slackn8n-nodes-base.slack
• Gmailn8n-nodes-base.gmail
• Waitn8n-nodes-base.wait

From the author

Quick Overview This workflow runs daily to compare procurement transactions in Google Sheets against an approved supplier list, flags unapproved (maverick) spend, uses Google Gemini to generate compliant alternatives, alerts reviewers via Slack and Gmail,…

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