Compare the top products before you buy

from clickruntime import on_event, credentials, http, ai, notify

@on_event
def handle(event):
    product = (event.json or {}).get("product", "").strip()
    key = credentials.secret("SERPAPI_KEY")
    shop = http.get("https://serpapi.com/search.json",
                    params={"engine": "google_shopping", "q": product, "api_key": key}).json()
    items = [f"{r['title']} | {r.get('price')} | rating {r.get('rating', '-')} ({r.get('reviews', 0)} reviews)"
             for r in shop.get("shopping_results", [])[:10]]
    web = http.get("https://serpapi.com/search.json",
                   params={"engine": "google", "q": f"best {product} review", "api_key": key}).json()
    reviews = [f"{r['title']}: {r.get('snippet', '')}" for r in web.get("organic_results", [])[:6]]
    table = ai.generate(
        f"Product type: {product}\n\nShopping results:\n" + "\n".join(items)
        + "\n\nReview snippets:\n" + "\n".join(reviews),
        system="Pick the top 5 and write a plain-text table: name, price, rating, pros, cons.",
        max_output_tokens=900,
    ).text
    notify.email_me(f"Top 5 {product} compared", table)
    return {"candidates": len(items)}