Daily Ops Digest + Age Anomaly Alerts (Gmail, OpenAI, n8n)

Get a morning snapshot of your ops—and instant age anomaly emails when queues get stale

This n8n workflow runs every morning at 08:30 to pull operational metrics from your HTTP endpoints, generates a fact-only daily digest using OpenAI, and emails it via Gmail. If any “oldest item age” thresholds are breached, it also sends a separate, throttled Gmail alert.

What this workflow does

• Fetches data from four HTTP endpoints (sales, support, calendar, finance) using configured URLs: OPS_SALES_URL, OPS_SUPPORT_URL, OPS_CALENDAR_URL, and OPS_FINANCE_URL.
• Continues even if a source fails: each response is normalized into consistent fields (including open count, oldest open item ID, and oldest age), and the digest is marked degraded when data is unavailable or malformed.
• Detects age-threshold anomalies per source and prepares a fact-only summary prompt for OpenAI based on the normalized results.
• Validates OpenAI output: the workflow checks the generated text to ensure it is safe and contains no numbers; if validation fails, it falls back to a fixed summary message.
• Sends an HTML daily operations digest email via Gmail containing the prose summary and a per-source status table.
• Sends a separate HTML anomaly alert email via Gmail when unthrottled age anomalies remain, using a once-per-day throttle key and recording throttle keys after a successful send.

Use cases

• SaaS operations teams who want a daily ops digest for sales/support/calendar/finance health.
• Automation engineers monitoring queue aging (oldest tickets/orders/records) to catch SLA risk early.
• Teams that need degraded-status awareness when upstream HTTP endpoints are missing or malformed.

Technical details

• Schedule trigger (daily at 08:30)
• HTTP Request nodes with HTTP Header Auth credential support
• Code and if nodes for normalization, aggregation, anomaly detection, throttling logic, and OpenAI output validation
• Gmail for the HTML digest email and the throttled age anomaly alert email
• Sticky note for workflow documentation