Log Stripe sales in a sheet and send buyers their product

import base64
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
import stripe
from clickruntime import on_event, credentials, verify, state

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"}
    s = event.json["data"]["object"]
    if state.get(f"done:{s['id']}"):
        return {"duplicate": True}
    stripe.api_key = credentials.secret("STRIPE_API_KEY")
    item = stripe.checkout.Session.list_line_items(s["id"], limit=1).data[0]
    email, google = s["customer_details"]["email"], Credentials(credentials.connection("google", "work"))
    sheets = build("sheets", "v4", credentials=google, cache_discovery=False).spreadsheets()
    sheets.values().append(spreadsheetId=SHEET_ID, range="Sales!A:F", valueInputOption="USER_ENTERED", body={"values": [[
        event.received_at[:10], email, item.description, s["amount_total"] / 100, s["currency"].upper(), s["id"]]]}).execute()
    products = sheets.values().get(spreadsheetId=SHEET_ID, range="Products!A:B").execute().get("values", [])
    link = next((r[1] for r in products if len(r) > 1 and r[0] == item.price.product), None)
    msg = EmailMessage(); msg["To"], msg["Subject"] = email, f"Your {item.description}"
    msg.set_content(f"Thanks for your purchase. Download it here: {link or 'we will send it to you shortly'}")
    build("gmail", "v1", credentials=google, cache_discovery=False).users().messages().send(
        userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    state.set(f"done:{s['id']}", True)
    return {"logged": s["id"]}