Gemini AI Error Diagnosis for n8n Workflows: Sheets + Slack

Stop guessing why your n8n workflows fail—Gemini explains the error, logs it to Sheets, and alerts Slack

This n8n error-handling workflow automatically captures failed executions from your other workflows, uses Google Gemini to produce a structured, plain-language diagnosis, then tracks each incident in Google Sheets and alerts your team in Slack with a direct link to the failed execution.

What this workflow does

• Triggers on workflow failure: It starts whenever a connected n8n workflow execution fails via the workflow error trigger.
• Extracts failure context: Captures the workflow name/ID, last executed node, execution URL, and the error message/description.
• Diagnoses with Gemini: Sends the error context to Google Gemini (PaLM) and requests structured output—category, severity, plain-language explanation, likely cause, and an n8n-specific suggested fix.
• Handles missing AI output: Normalizes the Gemini response and falls back to the raw error details if the AI response is missing or incomplete.
• Logs to Google Sheets: Appends the failure + diagnosis to the “Errors” tab for ongoing tracking.
• Alerts in Slack: Posts a formatted message to your chosen channel, including the diagnosis and a link to the failed execution.

Use cases

• Detecting recurring failures across multiple n8n automations and documenting root causes for faster remediation.
• Providing operators and SaaS teams instant Slack notifications with enough context to troubleshoot immediately.
• Turning raw n8n error messages into actionable, plain-language guidance during incident response.

Technical details

• Integrations: Google Gemini (PaLM), Google Sheets, and Slack.
• n8n workflow mechanics: workflow error trigger, code, Google Sheets appending, Slack messaging, and LLM-related nodes (n8n + n8nnodes-langchain components referenced in the workflow build).
• Setup: Add Gemini, Google Sheets OAuth2, and Slack OAuth2 credentials; select your target spreadsheet with an “Errors” tab; choose a Slack channel; set Settings → Error Workflow in each monitored workflow.