Invoice New Customers Automatically

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.

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

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.