{"product_id":"daily-ops-digest-age-anomaly-alerts-gmail-openai-n8n","title":"Daily Ops Digest + Age Anomaly Alerts (Gmail, OpenAI, n8n)","description":"\u003ch3\u003eGet a morning snapshot of your ops—and instant age anomaly emails when queues get stale\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every morning at \u003cb\u003e08:30\u003c\/b\u003e to pull operational metrics from your HTTP endpoints, generates a fact-only daily digest using \u003cb\u003eOpenAI\u003c\/b\u003e, and emails it via \u003cb\u003eGmail\u003c\/b\u003e. If any “oldest item age” thresholds are breached, it also sends a separate, throttled \u003cb\u003eGmail\u003c\/b\u003e alert.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches data from four HTTP endpoints\u003c\/b\u003e (sales, support, calendar, finance) using configured URLs: \u003ccode\u003eOPS_SALES_URL\u003c\/code\u003e, \u003ccode\u003eOPS_SUPPORT_URL\u003c\/code\u003e, \u003ccode\u003eOPS_CALENDAR_URL\u003c\/code\u003e, and \u003ccode\u003eOPS_FINANCE_URL\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eContinues even if a source fails\u003c\/b\u003e: each response is normalized into consistent fields (including \u003cb\u003eopen count\u003c\/b\u003e, \u003cb\u003eoldest open item ID\u003c\/b\u003e, and \u003cb\u003eoldest age\u003c\/b\u003e), and the digest is marked \u003cb\u003edegraded\u003c\/b\u003e when data is unavailable or malformed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDetects age-threshold anomalies per source\u003c\/b\u003e and prepares a fact-only summary prompt for OpenAI based on the normalized results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates OpenAI output\u003c\/b\u003e: the workflow checks the generated text to ensure it is safe and contains \u003cb\u003eno numbers\u003c\/b\u003e; if validation fails, it falls back to a fixed summary message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends an HTML daily operations digest email\u003c\/b\u003e via Gmail containing the prose summary and a per-source status table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a separate HTML anomaly alert email\u003c\/b\u003e via Gmail when unthrottled age anomalies remain, using a once-per-day throttle key and recording throttle keys after a successful send.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operations teams who want a \u003cb\u003edaily ops digest\u003c\/b\u003e for sales\/support\/calendar\/finance health.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers monitoring queue aging (oldest tickets\/orders\/records) to catch SLA risk early.\u003c\/li\u003e\n  \u003cli\u003eTeams that need \u003cb\u003edegraded-status awareness\u003c\/b\u003e when upstream HTTP endpoints are missing or malformed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eSchedule trigger\u003c\/b\u003e (daily at 08:30)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHTTP Request\u003c\/b\u003e nodes with \u003cb\u003eHTTP Header Auth credential\u003c\/b\u003e support\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCode\u003c\/b\u003e and \u003cb\u003eif\u003c\/b\u003e nodes for normalization, aggregation, anomaly detection, throttling logic, and OpenAI output validation\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail\u003c\/b\u003e for the HTML digest email and the throttled age anomaly alert email\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSticky note\u003c\/b\u003e for workflow documentation\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824209977523,"sku":"N8N-18148","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/chqf6_IW0Py19sfdvgfU2_UHR9qnUN.png?v=1786612771","url":"https:\/\/buyflowscripts.com\/products\/daily-ops-digest-age-anomaly-alerts-gmail-openai-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}