n8n Stripe Payment Tracking + Anomaly Alerts with Data Tables

Instant Stripe payment tracking in n8n—plus anomaly alerts and a daily performance digest

This n8n workflow captures key Stripe payment events into an n8n Data Table, automatically detects high-value completed payments, and sends email alerts and a 24-hour metrics digest via SMTP.

What this workflow does

• Listens for Stripe events using the Stripe Trigger webhook for checkout.session.completed, charge.failed, and charge.refunded.
• Normalizes every event into a consistent record (event ID, event type, amount, currency, customer email, status, and timestamp), making the data easy to query and report.
• Stores events in an n8n Data Table named stripe_events for later alerting and daily reporting.
• Detects anomalies: when a completed payment amount is greater than or equal to 10,000 (the smallest currency unit), it sends an email alert via SMTP. (For example: 10000 = 100.00.) You can adjust the threshold in the Check Anomaly node.
• Sends a daily 24-hour digest (configurable frequency in the Daily Digest Trigger node). It calculates and emails metrics such as revenue, transaction count, failed payments, refunds, total refund amount, and refund rate.
• Supports extension—you can add more Stripe events in the Stripe Trigger and expand the Normalize Event code accordingly.

Use cases

• Detect unusually large successful Stripe payments in near real-time and notify the team.
• Get a daily operational snapshot of revenue, failures, and refunds for SaaS billing visibility.
• Keep a lightweight audit trail of Stripe payment activity inside n8n using Data Tables.

Technical details

• Nodes/technologies: Stripe Trigger, Code (Normalize Event), Data Table (stripe_events), if, Email Send, and scheduling triggers (24-hour run).
• Email delivery: SMTP for both anomaly alerts and daily digest emails.
• Stripe authentication: Works with a Stripe account API key (including test mode).