{"product_id":"n8n-stripe-payment-tracking-anomaly-alerts-with-data-tables","title":"n8n Stripe Payment Tracking + Anomaly Alerts with Data Tables","description":"\u003ch3\u003eInstant Stripe payment tracking in n8n—plus anomaly alerts and a daily performance digest\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures key \u003cstrong\u003eStripe\u003c\/strong\u003e payment events into an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e, automatically detects high-value completed payments, and sends email alerts and a 24-hour metrics digest via \u003cstrong\u003eSMTP\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eListens for Stripe events\u003c\/strong\u003e using the \u003cstrong\u003eStripe Trigger\u003c\/strong\u003e webhook for \u003ccode\u003echeckout.session.completed\u003c\/code\u003e, \u003ccode\u003echarge.failed\u003c\/code\u003e, and \u003ccode\u003echarge.refunded\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes every event\u003c\/strong\u003e into a consistent record (event ID, event type, amount, currency, customer email, status, and timestamp), making the data easy to query and report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores events\u003c\/strong\u003e in an n8n Data Table named \u003cstrong\u003estripe_events\u003c\/strong\u003e for later alerting and daily reporting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects anomalies\u003c\/strong\u003e: when a completed payment amount is greater than or equal to \u003cstrong\u003e10,000\u003c\/strong\u003e (the smallest currency unit), it sends an email alert via \u003cstrong\u003eSMTP\u003c\/strong\u003e. (For example: 10000 = 100.00.) You can adjust the threshold in the \u003cstrong\u003eCheck Anomaly\u003c\/strong\u003e node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a daily 24-hour digest\u003c\/strong\u003e (configurable frequency in the \u003cstrong\u003eDaily Digest Trigger\u003c\/strong\u003e node). It calculates and emails metrics such as revenue, transaction count, failed payments, refunds, total refund amount, and refund rate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupports extension\u003c\/strong\u003e—you can add more Stripe events in the \u003cstrong\u003eStripe Trigger\u003c\/strong\u003e and expand the \u003cstrong\u003eNormalize Event\u003c\/strong\u003e code accordingly.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDetect unusually large successful Stripe payments in near real-time and notify the team.\u003c\/li\u003e\n  \u003cli\u003eGet a daily operational snapshot of revenue, failures, and refunds for SaaS billing visibility.\u003c\/li\u003e\n  \u003cli\u003eKeep a lightweight audit trail of Stripe payment activity inside n8n using Data Tables.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/technologies:\u003c\/strong\u003e Stripe Trigger, \u003cstrong\u003eCode\u003c\/strong\u003e (Normalize Event), \u003cstrong\u003eData Table\u003c\/strong\u003e (stripe_events), \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eEmail Send\u003c\/strong\u003e, and scheduling triggers (24-hour run).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery:\u003c\/strong\u003e \u003cstrong\u003eSMTP\u003c\/strong\u003e for both anomaly alerts and daily digest emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStripe authentication:\u003c\/strong\u003e Works with a Stripe account API key (including \u003cstrong\u003etest mode\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081373339827,"sku":"N8N-19891","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/cCFoSTgsSOPzgWg85ueFk_a5VmRLyV.png?v=1790240568","url":"https:\/\/buyflowscripts.com\/products\/n8n-stripe-payment-tracking-anomaly-alerts-with-data-tables","provider":"N8N Commerce","version":"1.0","type":"link"}