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

Description

🚀 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.