Every month, 9% of subscription MRR is lost to failed payments — most businesses never recover it because they rely on manual follow-up. This template fires the moment a Stripe payment fails and runs a complete recovery sequence without you lifting a finger.
When a Stripe payment fails, the workflow runs a 7-day sequence designed to maximise recovery before marking a customer as churned.
Stripe fires the invoice.payment_failed webhook. The workflow logs the failure to Google Sheets and immediately sends the customer a polite email with their Stripe-hosted invoice link. No delay — fires within seconds.
The workflow wakes up and queries Stripe to check if the invoice is now paid. If yes: marks recovered in the dashboard and stops. If no: sends a second email with stronger urgency language — "your account may be paused in 4 days."
Checks Stripe one more time. If still unpaid: calls the Stripe POST /v1/invoices/{id}/pay endpoint to automatically retry the charge. No manual action needed.
Dashboard updated to "Recovered — Auto-Retry Day 7." Customer receives a payment confirmation email. You receive nothing — the workflow handled it while you slept.
If the retry also fails, the customer is marked as "Churned" in the dashboard, sent a final account-paused notice, and you receive an owner alert email with full customer details so you can take personal action.
| Workflow files | n8n JSON (16 nodes) + Make.com blueprint — both included |
| Setup guide | Step-by-step PDF — connecting Stripe webhook, Google Sheets, Gmail, and configuring the retry logic |
| Email templates | 3 pre-written dunning emails: Day 0 (polite), Day 3 (urgency), Final (account pause). Edit to match your brand voice. |
| Google Sheets template | Recovery dashboard tracking Invoice ID, Customer, Amount, Status, Recovery Stage, Recovered Date |
| Platforms | n8n (self-hosted or cloud free tier) · Make.com (free tier) |
| APIs used | Stripe Webhooks · Stripe REST API · Gmail · Google Sheets |
| Setup time | 8–15 minutes |
| Ideal for | SaaS businesses, subscription services, agencies, membership sites — any business using Stripe for recurring billing |
| Delivery | Instant digital download via Gumroad |
| Licence | Commercial use — deploy for your own business |
We recovered $4,200 in failed payments in the first 6 weeks. Before this I was manually emailing customers — now it all happens automatically and I just get the alert when someone churns.
Setup took about 12 minutes. The Stripe webhook was the trickiest part but the guide made it simple. It's been running for 2 months and has already paid for itself 30 times over.