n8n Retry Flaky HTTP Requests with Gemini & Sheets Dead Letters

Stop brittle automations: Retry flaky HTTP requests intelligently with Gemini + Google Sheets dead letters

This n8n workflow makes unreliable HTTP calls safer by using Google Gemini to classify failures, retrying only transient errors with exponential backoff, and recording non-retriable or exhausted cases in a Google Sheets dead-letter register for nightly replay.

What this workflow does

• Receives job inputs from another workflow (job name, URL, method, body, and retry budget) or runs on a nightly schedule to sweep the dead-letter register in Google Sheets.
• Attempts the HTTP request while capturing error output for downstream analysis.
• Triages failures with Google Gemini: when the call fails, the workflow sends error details to Gemini to classify the issue as transient, permanent, or “needs_human,” and to recommend a backoff time.
• Retries responsibly: the workflow tracks attempt count, waits for the suggested backoff, and retries only while the failure is transient and the retry budget has not been exhausted.
• Dead-letters the rest: if the failure is not transient or retries are exhausted, the workflow appends a record to the Google Sheets “Dead Letters” tab with the payload, diagnosis, and any required human action.
• Nightly replay & closure: failures stored in Sheets are replayed nightly; when a replay succeeds, the corresponding entry is updated to close it.

Use cases

• Improve reliability of SaaS-to-SaaS HTTP integrations where occasional timeouts or transient gateway errors occur.
• Run scheduled background syncs without losing failed jobs—non-retriable failures are captured for review.
• Reduce noise in production workflows by preventing pointless retries of permanent errors.

Technical details

• Nodes/logic: if, code, wait, switch, and sticky note for orchestration and decisioning.
• HTTP execution: HTTP Request with captured error output.
• Failure triage: Google Gemini (PaLM) chat model using Gemini API credentials.
• Dead-letter register: Google Sheets via OAuth2 credentials, writing to the configured “Dead Letters” tab.

Ideal for n8n users, automation engineers, and SaaS operators who want robust HTTP retry behavior and auditable failure handling.