I'm trying to set up an automated workflow using Zapier to handle failed payments on Stripe and send reminders via Mailjet. Here's what I want to achieve:
- When a payment fails on Stripe, I want to send an email notification every week for up to 12 weeks, reminding the customer of the failed payment.
- Before each reminder email is sent, I want to check if the payment has been successfully made.
- After 12 weeks, if the payment is still unpaid, I want to send a final notice email on the 90th day.
How can I set up this workflow using Zapier and Mailjet to ensure proper timing and checks for payment status?