{"product_id":"n8n-daily-slack-digest-gmail-triage-metrics-from-google-sheets","title":"n8n Daily Slack Digest: Gmail Triage Metrics from Google Sheets","description":"\u003ch3\u003en8n Daily Slack Digest: turns your Gmail triage logs in Google Sheets into daily Slack alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs once per day to summarize AI-triaged Gmail enquiry logs stored in Google Sheets, compares yesterday against the previous day, flags warning conditions, saves the results to a “Summary History” sheet, and posts a formatted digest to a Slack channel.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eScheduled daily run:\u003c\/b\u003e Uses an n8n schedule trigger to execute automatically once per day.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReads triage metrics from Google Sheets:\u003c\/b\u003e Loads configurable warning thresholds, then reads all rows from the \u003cb\u003eTriage Log\u003c\/b\u003e worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFilters to “yesterday” in your workflow timezone:\u003c\/b\u003e Keeps only rows where \u003cb\u003eReceived At\u003c\/b\u003e falls within yesterday’s calendar day.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eComputes key counts and rates:\u003c\/b\u003e Totals enquiries, breaks out priority counts (\u003cb\u003ehigh\u003c\/b\u003e, \u003cb\u003emedium\u003c\/b\u003e, \u003cb\u003elow\u003c\/b\u003e), and counts \u003cb\u003emanual_review\u003c\/b\u003e categories along with its rate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAdds day-over-day context:\u003c\/b\u003e Fetches the latest prior entry from the \u003cb\u003eSummary History\u003c\/b\u003e worksheet (excluding the current date) and compares totals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFlags warnings based on thresholds:\u003c\/b\u003e Detects issues such as \u003cb\u003ezero enquiries\u003c\/b\u003e, a \u003cb\u003ehigh manual-review rate\u003c\/b\u003e, or a \u003cb\u003ehigh-priority spike\u003c\/b\u003e, according to your configured limits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUpserts summary + posts to Slack:\u003c\/b\u003e Writes\/updates yesterday’s results in \u003cb\u003eSummary History\u003c\/b\u003e by date and posts the digest (including warnings) to \u003cb\u003eSlack\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSupport and ops teams monitoring AI triage performance and escalation needs.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking priority spikes and manual-review volume trends.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers validating workflow health with consistent daily metrics.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations\/nodes:\u003c\/b\u003e schedule trigger, Google Sheets, Code, Set, Slack, and Sticky Note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExpected sheet structure:\u003c\/b\u003e \u003cb\u003eTriage Log\u003c\/b\u003e must include case-sensitive headers: \u003cb\u003eReceived At\u003c\/b\u003e, \u003cb\u003ePriority\u003c\/b\u003e (high\/medium\/low), and \u003cb\u003eCategory\u003c\/b\u003e (including \u003cb\u003emanual_review\u003c\/b\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSummary output:\u003c\/b\u003e \u003cb\u003eSummary History\u003c\/b\u003e is created with headers appropriate for upserting results by date, then used for comparisons.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862249627827,"sku":"N8N-18317","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/g1yPOe3SEhFW_z1EpSNg_G9ATIYW8.png?v=1786957797","url":"https:\/\/buyflowscripts.com\/products\/n8n-daily-slack-digest-gmail-triage-metrics-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}