Log workflow failures with Google Gemini, Google Sheets, 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 8 nodes and runs when another workflow fails (error workflow). Along the way it connects Google Sheets, Gmail and Google Gemini Chat Model.
How it runs
Trigger: When another workflow fails (error workflow).
- Classify the Failure (Code): runs custom JavaScript code
- Write Plain English Diagnosis (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Build Incident Record (Edit Fields (Set)): sets 10 fields: failed_at, workflow_name, workflow_id…
- Log Incident to Google Sheets (Google Sheets): append
- Critical Enough to Wake Someone? (If): checks a condition and branches into true / false
- Email the On-Call Owner (Gmail): uses Gmail
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 (8)
- Error Trigger
n8n-nodes-base.errorTrigger - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Quick overview This error workflow captures n8n workflow failures, classifies them, generates a short Google Gemini diagnosis, logs each incident to Google Sheets, and emails an on-call address via Gmail only for critical errors. How it works 1. Triggers when…