Tell Slack and log a sheet row when a subscription ends

Knowing who cancels, and why, is how a subscription business learns. When a Stripe subscription ends, this posts the customer, the plan's price and the reason in Slack, and adds a row to your Cancellations sheet.

A customer who chose to leave is told apart from one whose payments kept failing, so the team follows up on the right ones.

StripeWhen a subscription ends. Save it as subscription.When a subscription ends. Save it as subscription.

Cancellations sheetSet cancellationsSheet to blank.

TodayGet today's date and save it as today.

Log the cancellationAdd a row to 'Cancellations' in cancellationsSheet. Save it as logged.Google Sheets

Tell the team in SlackSend message to channel. Save it as posted.subscription.payer cancelled (subscription.amount_display). subscription.reason_display.Slack