🚀 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: 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 emailsentcount < 1 → send first email. Else if emailsentcount < 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 emailsentcount 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.