{"product_id":"n8n-till-cash-leak-monitor-google-sheets-gmail-telegram","title":"n8n Till Cash Leak Monitor: Google Sheets, Gmail \u0026 Telegram","description":"\u003ch3\u003eDetect cash leaks in your till closeouts—automatically reconcile, validate, and alert overnight\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003en8n Till Cash Leak Monitor\u003c\/strong\u003e nightly reconciles your till closeout submissions, finds cash variances outside a tolerance band, flags missing or malformed rows, quarantines duplicates, and escalates repeat offenders via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e. It also produces a \u003cstrong\u003edaily digest\u003c\/strong\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (optionally narrated with \u003cstrong\u003eOpenAI\u003c\/strong\u003e) so you always know what happened.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns nightly\u003c\/strong\u003e (or via manual \u003cem\u003eTest workflow\u003c\/em\u003e) to collect today’s till submissions and fetch the \u003cstrong\u003eprior 30 days\u003c\/strong\u003e of till history.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates each row\u003c\/strong\u003e, separating complete entries from \u003cem\u003emalformed\u003c\/em\u003e ones, and determines “today” based on the latest date in the batch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores 30-day history\u003c\/strong\u003e to calculate cumulative leak totals and count prior over-band shifts per staff member.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects operational issues\u003c\/strong\u003e by flagging missing required fields, identifying \u003cstrong\u003edate+shift duplicates\u003c\/strong\u003e, and inferring submission gaps between the last historical date and today.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares cash vs expected sales\u003c\/strong\u003e per unique shift against a tolerance band (the max of a flat amount or a percent of sales), labeling results as clean, alert-worthy, or escalation-worthy.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes outcomes\u003c\/strong\u003e: writes clean results back to the till log, quarantines duplicates\/malformed rows in a quarantine sheet, sends first-offense and gap alerts by \u003cstrong\u003eGmail\u003c\/strong\u003e, escalations by \u003cstrong\u003eTelegram\u003c\/strong\u003e, and one per-run digest by \u003cstrong\u003eTelegram\u003c\/strong\u003e (optionally narrated with \u003cstrong\u003eOpenAI\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep till audits consistent by automatically catching \u003cstrong\u003emissing submissions\u003c\/strong\u003e and \u003cstrong\u003emalformed rows\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eReduce fraud risk by detecting \u003cstrong\u003ecash variances\u003c\/strong\u003e and escalating repeat offenders.\u003c\/li\u003e\n  \u003cli\u003ePrevent duplicate closeout reporting with \u003cstrong\u003edate+shift duplicate detection\u003c\/strong\u003e and quarantine.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for till logs, quarantines, and daily digests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e for first-offense and gap alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e for repeat-offender escalations and per-run digests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/workflow components\u003c\/strong\u003e include: if, code, gmail, merge, open ai, switch.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153965895859,"sku":"N8N-20309","price":71.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/pUsJ8jFWf4-Wz08UvgVw0_MXBNzeNf.png?v=1790932144","url":"https:\/\/buyflowscripts.com\/products\/n8n-till-cash-leak-monitor-google-sheets-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}