Get yesterday's Stripe revenue in your inbox each morning

import base64
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import datetime, timedelta, timezone
from collections import defaultdict
import stripe
from clickruntime import on_trigger, credentials, ai

def send(to, subject, text):
    msg = EmailMessage(); msg["To"], msg["Subject"] = to, subject; msg.set_content(text)
    g = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    g.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()

@on_trigger
def run(event):
    stripe.api_key = credentials.secret("STRIPE_API_KEY")
    end = datetime.now(timezone.utc).replace(hour=0, minute=0, second=0, microsecond=0)
    span = {"gte": int((end - timedelta(days=1)).timestamp()), "lt": int(end.timestamp())}
    totals = defaultdict(int)
    for c in stripe.Charge.list(created=span, limit=100).auto_paging_iter():
        totals[f"Sales {c.currency.upper()}"] += c.amount if c.paid else 0
    for r in stripe.Refund.list(created=span, limit=100).auto_paging_iter():
        totals[f"Refunds {r.currency.upper()}"] += r.amount
    lines = [f"{k}: {v / 100:,.2f}" for k, v in totals.items()]
    lines.append(f"New subscriptions: {len(stripe.Subscription.list(created=span, status='all', limit=100).data)}")
    summary = ai.generate("Summarise yesterday's revenue in two sentences:\n" + "\n".join(lines), max_output_tokens=120).text
    send("me@example.com", f"Stripe revenue for {(end - timedelta(days=1)).date()}", summary + "\n\n" + "\n".join(lines))
    return {"lines": len(lines)}