Subscribe New Customers to a Plan

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

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.