Reconcile trade mismatches in Google Sheets with Groq/OpenAI and Gmail alerts
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 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Groq Chat Model, Google Sheets and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Internal Trades (Google Sheets): uses Google Sheets
- Fetch External Trades (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Detect Trade Breaks (Code): runs custom JavaScript code
- Classify Severity (Code): runs custom JavaScript code
- Prepare Trade Data (Edit Fields (Set)): sets 1 field: trade_id
- Generate AI Reconciliation Insight (AI Agent): runs an AI agent, with model: Groq Chat Model
- Extract AI Output (Edit Fields (Set)): sets 2 fields: Reason, Action
- Check Valid Row (If): checks a condition and branches into true / false
- Update Internal Trades Sheet (Google Sheets): update
…plus 6 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)
- Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail
From the author
Trade Break Reconciliation Assistant This workflow automates trade reconciliation between internal and external systems using Google Sheets. It detects mismatches (price, quantity, amount, etc.), uses AI to generate insights, updates records and sends email…