Brevo and Stripe integration

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