Analyze failed trades in Google Sheets with Gemini and send Slack, email, and task alerts

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 Slack and email and creates a follow-up task to ensure the issue is reviewed.

Quick Implementation Steps

Connect Google Sheets (Failed Trade Log) Add Google Gemini API credentials Configure Slack, Gmail and Google Tasks Ensure sheet columns match workflow fields Test with one sample failed trade [Activate the workflow](https://n8n.partnerlinks.io/om1efg2qgvwi)

What It Does

This workflow automates the analysis of failed trades logged in a Google Sheet. Whenever a new trade is added, it validates whether the required failure details are present.

If valid, the workflow sends the trade details to Gemini AI, which returns a structured explanation including probable cause, confidence, next steps and a short ops summary. The workflow updates the same row with this analysis.

Once updated, alerts are sent to Slack and email and a follow-up Google Task is created for operational tracking. If required fields are missing, the workflow skips AI and marks the record as invalid.