Log every Stripe cancellation and its reason in a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
import stripe
from clickruntime import on_event, credentials, verify

SHEET_ID = "your-sheet-id"

@on_event
def handle(event):
    if not verify.stripe(event.body, event.header("Stripe-Signature"), credentials.secret("STRIPE_WEBHOOK_SECRET")):
        return {"ignored": "bad signature"}
    sub = event.json["data"]["object"]
    stripe.api_key = credentials.secret("STRIPE_API_KEY")
    customer = stripe.Customer.retrieve(sub["customer"])
    item = sub["items"]["data"][0]
    price = item["price"]
    monthly = price["unit_amount"] * item.get("quantity", 1) / 100 / (12 if price["recurring"]["interval"] == "year" else 1)
    details = sub.get("cancellation_details") or {}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    sheets.values().append(spreadsheetId=SHEET_ID, range="Churn!A:G", valueInputOption="USER_ENTERED", body={"values": [[
        event.received_at[:10], customer.name or "", customer.email, price.get("nickname") or price["id"], round(monthly, 2),
        details.get("feedback") or "no reason given", details.get("comment") or ""]]}).execute()
    return {"logged": sub["id"]}