Monitor refund and chargeback ratio spikes with Google Sheets, Gemini, and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets, Google Gemini and Slack.
How it runs
Trigger: On a schedule (every day at 09:00).
- Configure Monitor Settings (Edit Fields (Set)): sets 7 fields: thresholdMultiplier, monitoringDateOverride, spreadsheetId…
- Read Sales Data (Google Sheets): uses Google Sheets
- Read Refund Chargeback Data (Google Sheets): uses Google Sheets
- Calculate Refund Chargeback Metrics (Code): runs custom JavaScript code
- Refund Ratio Spike? (If): checks a condition and branches into true / false
- Generate Diagnostic Summary (Google Gemini): uses Google Gemini
- Prepare Normal Snapshot (Code): runs custom JavaScript code
- Prepare Anomaly Snapshot (Code): runs custom JavaScript code
- Log Normal Snapshot (Google Sheets): append
- Log Ratio Snapshot (Google Sheets): append
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow runs daily to read sales and refund/chargeback data from Google Sheets, calculates a 7-day refund/chargeback ratio against a 90-day baseline, logs the results back to Google Sheets, and posts a Slack alert with a Google Gemini…