Automated Stripe Failed Payment Recovery & Follow-Up Emails

This n8n workflow automates the recovery of failed Stripe payments by listening for payment_intent.payment_failed events. It extracts key customer details like name, email, amount, and payment ID, removes duplicates, and logs everything into a Google Sheets 'failed payments queue' with fields for tracking email sent counts. A daily schedule trigger (10 AM cron) reads the sheet, uses a Switch node to check email_sent_count: sends the first gentle reminder if <1, a second urgent one if <2, then s