Get a weekly email on what reviews say about each product

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

STORE = "https://shop.example.com/wp-json/wc/v3"
ME = "me@northwind.com"

@on_trigger
def run(event):
    auth = (credentials.secret("WOO_KEY"), credentials.secret("WOO_SECRET"))
    since = (datetime.now(timezone.utc) - timedelta(days=7)).strftime("%Y-%m-%dT%H:%M:%S")
    reviews = http.get(f"{STORE}/products/reviews", auth=auth, params={"after": since, "status": "approved", "per_page": 100}).json()
    if not reviews:
        return {"reviews": 0}
    lines = [f"{r['product_name']} | {r['rating']}/5 | {r['review'][:400]}" for r in reviews]
    summary = ai.generate("Group these product reviews by product. For each, give overall sentiment, recurring themes "
                          "and one improvement idea. Plain text.\n" + "\n".join(lines), max_output_tokens=900).text
    msg = EmailMessage()
    msg["To"], msg["Subject"] = ME, f"Review report: {len(reviews)} reviews last week"
    msg.set_content(summary)
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    return {"reviews": len(reviews)}