Every Monday, emails the subscription payments Stripe couldn't collect, with a drafted follow-up for each.
Uses
Claude
Gmail
Stripe
Weekly failed subscription payments with follow-up notes
Run every Monday at 09:00.Run every Monday at 09:00.
Your email addressSet my_email to blank.Subscription payments that failed in the last 7 daysList failed payments. Save it as failed.Stripe
If failed.count is greater than 0If failed.count is greater than 0Yes
Table of failed paymentsMake a table of failed.payments Save it as failed_table.
One line per failed payment for the AIWrite each item in failed.payments as - @item.customer_name (@item.customer_email) | @item.amount_owed_display | @item.reason | pay link: @item.invoice_url, one per line and save it as failed_lines.Follow-up notes drafted by AIAsk Claude: 'Write a short, polite follow-up note (2 to 3 sentences) for each customer below whose subscription payment failed. Mention the amount and gently say what went wrong, and point them to their pay link. Use a Markdown heading with the customer's name (or email if there is no name) for each note, and write nothing else.
failed_lines'. Save it as follow_up_notes.You write short, polite, friendly payment follow-up notes for a subscription business. Never state a deadline, late fee, discount or policy that was not given to you.ClaudeEmail body as HTMLTurn Failed subscription payments from the last 7 days: **failed.count**. Total owed: **failed.total_owed_display**.
failed_table.html
## Follow-up notes to copy (drafted by AI, please check before sending)
follow_up_notes.response_text into HTML Save it as email_body.Email the weekly failed paymentsSend an email to my_email. Save it as weekly_email.
Subject: Failed subscription payments last week: failed.total_owed_displayemail_body.htmlGmailNo
No steps