n8n workflow automation

What It Does

Use it when you need an automation that is fully auditable and guaranteed not to silently drop data or duplicate records.

This skill designs and outputs n8n workflow JSON built for production reliability. Given a workflow intent, it produces node maps and importable `workflow.json` files that include robust trigger configuration, deduplication logic, per-node error branches with retry backoff, structured audit logging, and human-in-the-loop (HITL) review queues for failed items.

Key Features

• Idempotency & Deduplication — The skill defines one or more dedup keys and selects an appropriate storage backend (Sheet or DB) to track processed records. Workflows can safely rerun after failures without creating duplicate entries.
• Per-Node Error Handling with Retry Backoff — Every node in the generated workflow includes dedicated error branches. Transient failures trigger configurable retry-with-backoff logic; permanent failures route items to a review queue rather than silently dropping them.
• Structured Audit Logging — Each run receives a unique `run_id`. Start time, end time, record counts, and error details are written to a status log (Sheet, DB, or similar), giving you a full audit trail for every execution.
• Human-in-the-Loop (HITL) Review Queue — Failed or flagged items are written to a review queue (Sheet or DB). A human approval step is required before those items are reprocessed, preventing silent data loss and enabling controlled remediation.
• "No Silent Failure" Gates — Threshold checks are embedded in the workflow design. If record counts or success rates fall outside expected bounds, the workflow stops and fires an alert rather than completing with undetected errors.
• Importable workflow.json + Runbook — When explicitly requested, the skill outputs a valid n8n-importable `workflow.json` alongside a `runbook.md` that documents nodes, data contracts, failure modes, and operational procedures.

Use Cases

• Weekly compliance summary email — Describe a cron trigger (e.g., Monday 08:00 Europe/London), target recipients, and a Drive upload destination. The skill produces a Cron → Fetch → Aggregate → Email workflow with retry branches and a review queue for any send failures.
• Webhook pipeline with run logging — Provide a sample incoming JSON payload and a destination tracker. The skill generates a Webhook → Validate → Process → Append Status Row workflow that logs every run and routes errors to a notification + queue node.
• Idempotent record sync — Supply an existing n8n workflow JSON and define the dedup key (e.g., record ID). The skill redesigns the flow to check for existing records before writing, ensuring reruns after failures never produce duplicate rows.
• Human-approved reprocessing queue — For workflows that process sensitive or high-value records, the skill adds a HITL gate: failed items land in a Sheet/DB queue, and a human must approve each item before the workflow reprocesses it.