Flag Customers with Failed Payments

Find all subscriptions that were canceled in the last 24 hours. For each one, locate the last successful charge and create a refund for that charge in Stripe.

Search for Stripe invoices that became overdue in the last 7 days. For each overdue invoice, find the associated customer and update their metadata to add a tag with 'status': '[overdue]'.

Check for new customers created in the last hour who do not have an active subscription. For each new customer, subscribe them to the recurring plan with the price ID '[your-standard-plan-price-id]'.

Look for new customers created in Stripe in the last 24 hours. For each new customer, create a new draft invoice for your standard '[Set-up Fee]' product using the price ID '[your-price-id]'.

Search Stripe for successful charges from the last 24 hours. For each charge, add a new row to the '[Sales Tracker]' Google Sheet with the amount, customer email, and date.