🚀 Automated Stripe Payment Recovery: Track Failures & Follow-Up Emails

🚀 Automated Stripe Payment Recovery Workflow (n8n)

Detect failed payments, log them, and send polite follow-up emails to recover revenue — all automated with n8n.

✅ Part A – Detect & log failed payments

What it does:

Listens for failed Stripe payments
Extracts customer & payment info
Logs them neatly in Google Sheets for follow-up

🧩 Nodes:

1️⃣ Stripe Trigger
Listens to:
payment_intent.payment_failed

2️⃣ Set node
Extracts & maps fields:
Name, Email, Amount (in cents), Currency
payment_intent_id
added_at → {{ $now }}
email_sent_count → 0

3️⃣ Remove Duplicates
Keeps the sheet clean (avoids duplicate rows)

4️⃣ Google Sheets node
Append or update row:
Name, Email, Amount/100, Currency, payment_intent_id, added_at, email_sent_count

This builds your “failed payments queue” to drive the follow-up emails later.

🔁 Part B – Daily follow-up emails

What it does:

Runs daily
Checks which users haven’t received 2 emails yet
Sends reminder emails and tracks how many were sent

🧩 Nodes:

1️⃣ Schedule Trigger
Runs every day at 10 AM (0 10 * * *)

2️⃣ Get Payment Failure Leads
Reads rows from Google Sheet

3️⃣ Switch node (Check for no. of emails sent)
If email_sent_count < 1 → send first email
Else if email_sent_count < 2 → send second email
Else → mark as "quit sending emails"

4️⃣ Send First Email
Sends a gentle reminder with billing page button

5️⃣ Update Email Count
Increments email_sent_count by +1 in Google Sheets

6️⃣ Send Second Email
Sends final, urgent reminder

7️⃣ Quit Sending Emails to these Leads
Marks that no more emails should be sent

📝 Headline

🚀 Automated Stripe Payment Recovery: Track Failures & Send Follow-Up Emails via n8n

✅ Why this matters:

Catch failed payments automatically
Log every attempt & follow-up count
Recover lost revenue while staying polite and respectful
Avoid spamming by capping follow-ups to 2 emails