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.

This workflow automates the process of collecting contacts, storing them in Brevo, and sending a welcome email, while also supporting bulk import from Google Sheets and unsubscribe tracking. Key Advantages ✅ Full automation of lead management The workflow eliminates manual work by handling the entire lifecycle: Data collection → Contact creation → Email sending This ensures faster response times and no missed leads. ✅ Real-time and batch processing It supports both: Instant processing** (via form/webhook) Bulk operations** (via Google Sheets) This makes it flexible for different use cases (landing pages, imports, CRM sync). ✅ Data consistency with “upsert” Using the upsert operation, contacts are: Created if new Updated if already existing This prevents duplicates and keeps your database clean. 4.✅ Seamless Brevo integration The workflow directly interacts with Brevo APIs to: Manage contacts Assign them to lists Send transactional emails This centralizes marketing automation in one platform. ✅ Automated onboarding experience New users instantly receive a welcome email, improving: User engagement First impression Conversion rates ✅ Scalable bulk processing The loop system allows processing large datasets efficiently, making it suitable for: Campaign migrations CRM imports Lead enrichment ✅ Data tracking and feedback loop By updating Google Sheets: Processed contacts are marked (“Done”) Unsubscribed users are tracked This creates a simple but effective CRM feedback loop. ✅ Event-driven unsubscribe handling The workflow reacts automatically to unsubscribe events, ensuring: Compliance with email regulations (GDPR, etc.) Clean and updated contact lists How it works This workflow automates contact management and email communication using Brevo (formerly Sendinblue) and Google Sheets*. It handles three main scenarios: Form submission or webhook trigger – When a user submits a form or hits a webhook, their contact info (first name, last name, email) is upserted into Brevo, added to a specific list, and a welcome email is sent. Batch import from Google Sheets – When manually executed, the workflow reads rows from a Google Sheet, loops through each row, upserts the contact into Brevo, adds them to a list, sends a welcome email, and marks the row as done in the sheet. Unsubscribe tracking – When Brevo detects an unsubscribe event, the workflow updates the corresponding row in Google Sheets to mark the contact as unsubscribed. The workflow ensures no duplicate contacts are created in Brevo (using upsert), and all actions are logged back into the Google Sheet. Set up steps Brevo credentials Register and Create an API key in Brevo for FREE. In n8n, add a SendInBlue API credential (sendInBlueApi) and an HTTP Header Auth credential (httpHeaderAuth) using the same API key. Google Sheets credentials Set up a Google Sheets OAuth2 API credential (googleSheetsOAuth2Api) in n8n. Ensure the Google account has access to the target spreadsheet. Google Sheets configuration Use the provided spreadsheet ID. Columns expected: First Name, Last Name, Email, Done, Unsubscribe, row_number. The workflow uses row_number to update the correct row. Brevo template setup Create a welcome email template in Brevo. Set the template ID to 1 (or update the workflow nodes with the correct ID). Form and webhook configuration The form trigger is pre-configured with fields: first_name, last_mail, email. The webhook node is ready to receive POST requests at its path. Activate the workflow to expose the webhook URL. List ID configuration The workflow adds contacts to Brevo list ID 3. Replace this with your actual list ID if different. Activate workflow Toggle the workflow to active to start listening for form submissions, webhook calls, and Brevo unsubscribe events. Manual execution for batch processing Use the "When clicking ‘Execute workflow’" trigger to run the batch import from Google Sheets. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

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