{"product_id":"monitor-refund-chargeback-spikes-sheets-gemini-slack","title":"Monitor Refund \u0026 Chargeback Spikes | Sheets, Gemini, Slack","description":"\u003ch3\u003eSpot refund \u0026amp; chargeback spikes before they hurt your revenue—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e daily for \u003cstrong\u003erefund\u003c\/strong\u003e and \u003cstrong\u003echargeback\u003c\/strong\u003e spikes, compares a rolling \u003cstrong\u003e7-day ratio\u003c\/strong\u003e to a \u003cstrong\u003e90-day baseline\u003c\/strong\u003e, and immediately posts a \u003cstrong\u003eSlack\u003c\/strong\u003e alert with a \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e diagnostic summary when an anomaly is detected.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 09:00\u003c\/strong\u003e based on your n8n instance timezone.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration\u003c\/strong\u003e such as the anomaly threshold multiplier, optional monitoring date override, Google Sheets IDs\/tab names, and the Slack channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads sales data\u003c\/strong\u003e and \u003cstrong\u003erefund\/chargeback data\u003c\/strong\u003e from two Google Sheets tabs (e.g., “Sales” and “Refunds”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates ratios\u003c\/strong\u003e: computes the current \u003cstrong\u003e7-day refund\/chargeback ratio\u003c\/strong\u003e and compares it to a \u003cstrong\u003e90-day historical baseline\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlags anomalies\u003c\/strong\u003e when the current ratio exceeds the baseline by the configured multiplier; if there’s \u003cstrong\u003einsufficient data\u003c\/strong\u003e, it assigns an appropriate status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhen a spike is detected\u003c\/strong\u003e, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate a concise diagnostic summary, then:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eLogs metrics + summary\u003c\/strong\u003e to a Google Sheets log tab\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eSends a Slack alert\u003c\/strong\u003e with the key metrics and Gemini text\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhen no anomaly occurs\u003c\/strong\u003e, it still logs metrics and status to the Google Sheets log tab, but \u003cstrong\u003edoes not\u003c\/strong\u003e alert Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDetect sudden increases in refunds\/chargebacks after a promo, product update, or payment method change.\u003c\/li\u003e\n  \u003cli\u003eGive SaaS ops and automation engineers early warning signals with automatic, human-readable diagnostics.\u003c\/li\u003e\n  \u003cli\u003eMaintain a historical record of refund\/chargeback ratios in Google Sheets for reporting and review.\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, Slack, Google Gemini\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003egoogle sheets\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic\u003c\/strong\u003e: 7-day ratio vs 90-day baseline, anomaly threshold multiplier, and “insufficient data” status handling\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217907339443,"sku":"N8N-20853","price":60.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fyIvtmaut1J0SeePeRd_j_k67J4weV.png?v=1791882438","url":"https:\/\/buyflowscripts.com\/products\/monitor-refund-chargeback-spikes-sheets-gemini-slack","provider":"N8N Commerce","version":"1.0","type":"link"}