Analyze failed trades in Google Sheets with Gemini and send Slack, email, and task 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 15 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, Google Gemini Chat Model, Slack and Google Tasks and 1 more.
How it runs
Trigger: On Google Sheets events (row added).
- Prepare Failed Trade Record (Edit Fields (Set)): sets 18 fields: id, logged_at, trade_id…
- Check Required Trade Fields (If): checks a condition and branches into true / false
- Analyze Failed Trade with AI (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- Prepare Invalid Trade Update (Edit Fields (Set)): sets 23 fields: ID, Logged At, Trade ID…
- Parse AI Analysis (Code): runs custom JavaScript code
- Update Invalid Trade Status (Google Sheets): update
- Prepare Trade Log Update (Edit Fields (Set)): sets 23 fields: ID, Logged At, Trade ID…
- Update Failed Trade Sheet (Google Sheets): update
- Send Ops Alert (Slack): uses Slack
- Create Follow-up Task (Google Tasks): uses Google Tasks
…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 (10)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Google Tasks
n8n-nodes-base.googleTasks - Gmail
n8n-nodes-base.gmail
From the author
Failed Trade Root Cause Explainer This workflow automatically monitors a Google Sheet for failed trades, analyzes each failure using AI and updates the sheet with a probable root cause, confidence level and actionable next steps. It also sends alerts via…