{"product_id":"n8n-workflow-health-monitoring-google-sheets-baselines-slack-alerts","title":"n8n Workflow Health Monitoring: Google Sheets Baselines + Slack Alerts","description":"\u003ch3\u003eKeep every n8n workflow healthy—log baselines in Google Sheets and alert in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors other n8n workflows by recording run health to a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e \u003cem\u003eRunLog\u003c\/em\u003e, comparing each new run to historical baselines, and sending \u003cstrong\u003eSlack\u003c\/strong\u003e alerts when volume or required data looks abnormal—or when workflows go silent.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a health-check call\u003c\/strong\u003e from another workflow with its name, item count, required fields, a sample item, and a run ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e in the sample item, ensuring declared fields exist and are not null or empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a rolling baseline\u003c\/strong\u003e from the Google Sheets \u003ccode\u003eRunLog\u003c\/code\u003e history, preferring \u003cstrong\u003esame-weekday medians\u003c\/strong\u003e to detect volume drops and slow decay patterns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results\u003c\/strong\u003e (verdict + metrics) back into the \u003ccode\u003eRunLog\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts in Slack\u003c\/strong\u003e: posts a detailed alert when the verdict is \u003cstrong\u003eWARN\u003c\/strong\u003e or \u003cstrong\u003eBREACH\u003c\/strong\u003e (optionally including WARN alerts).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupports failure escalation\u003c\/strong\u003e: can optionally fail the calling execution on \u003cstrong\u003eBREACH\u003c\/strong\u003e, so your existing error handling and retries can trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a daily digest\u003c\/strong\u003e every morning at \u003cstrong\u003e08:00\u003c\/strong\u003e, scanning the full \u003ccode\u003eRunLog\u003c\/code\u003e to detect workflows that stopped reporting based on learned cadence, and then notifying Slack if issues are found (or if configured to post even when all are healthy).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCatch pipelines that \u003cstrong\u003equietly lose throughput\u003c\/strong\u003e (e.g., item counts decaying over time).\u003c\/li\u003e\n  \u003cli\u003eDetect \u003cstrong\u003eschema\/data regressions\u003c\/strong\u003e when required fields go missing or become empty.\u003c\/li\u003e\n  \u003cli\u003eEnsure critical automations \u003cstrong\u003eresume reporting\u003c\/strong\u003e by flagging workflows that go silent.\u003c\/li\u003e\n  \u003cli\u003eGive SaaS operations teams a \u003cstrong\u003edaily Slack health digest\u003c\/strong\u003e for monitoring at a glance.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Sheets (requires a tab named \u003ccode\u003eRunLog\u003c\/code\u003e) and Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic \/ nodes\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, and \u003ccode\u003esticky note\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCreate your Google Sheet with a \u003ccode\u003eRunLog\u003c\/code\u003e tab and the required header columns, then paste the sheet ID into the workflow’s monitor and digest settings.\u003c\/li\u003e\n  \u003cli\u003eAdd Google Sheets credentials for the target spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eAdd Slack credentials to enable alerts and the daily digest.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830427279539,"sku":"N8N-18218","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WpSEBItlLjSdxphaqSXLl_7G67DHiF.png?v=1786698848","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-health-monitoring-google-sheets-baselines-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}