Tag Customers with Overdue Payments

Search for all charges that have a status of 'failed' in the last 24 hours. For each failed charge, find the associated customer and update their description to include 'Failed payment on [Current Date]'.

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.

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.