Log Refunds for Canceled Subscriptions

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]'.

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.