Brevo and Google Sheets 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.

🔧 How it works Scheduled Trigger The workflow is triggered automatically every day at 12:00 PM using a Cron node. RSS Feed Collection It fetches the latest content from multiple RSS feeds related to Technology, Manga, and Movies. Content Processing & Formatting The collected data is filtered and organized based on your interests. A dynamic HTML email template is generated to present the content in a clean and readable layout. Email Delivery The final newsletter is sent directly to your inbox using the Send Email node. ⚙️ Set up steps Configure RSS Sources Update the RSS feed URLs inside the Set nodes to match your preferred sources. Set Email Recipient Replace the email address in the Send Email node with your own. Adjust Schedule Modify the execution time in the Cron Trigger node if you want the newsletter to be sent at a different time. Activate the Workflow Enable the workflow to start receiving your personalized daily newsletter automatically.