Get a monthly summary of your Google reviews

from datetime import date
from clickruntime import on_trigger, credentials, http, notify, ai

LOCATIONS = {"Northwind Café Downtown": "accounts/123/locations/456", "Northwind Café Riverside": "accounts/123/locations/789"}
STARS = {"ONE": 1, "TWO": 2, "THREE": 3, "FOUR": 4, "FIVE": 5}

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    first = date.today().replace(day=1)
    last_month = (first.replace(year=first.year - 1, month=12) if first.month == 1
                  else first.replace(month=first.month - 1)).isoformat()
    sections = []
    for name, loc in LOCATIONS.items():
        reviews = [r for r in http.get(f"https://mybusiness.googleapis.com/v4/{loc}/reviews", headers=headers,
                                       params={"pageSize": 50}).json().get("reviews", [])
                   if last_month <= r["createTime"][:10] < first.isoformat()]
        avg = sum(STARS[r["starRating"]] for r in reviews) / len(reviews) if reviews else 0
        low = "\n".join(r.get("comment", "")[:400] for r in reviews if STARS[r["starRating"]] <= 3)
        complaints = ai.generate(f"Reviews:\n{low}", system="List the top 3 complaints in plain words, one line each.",
                                 max_output_tokens=150).text if low else "No complaints."
        sections.append(f"{name}: {len(reviews)} reviews, average {avg:.1f}★\n{complaints}")
    notify.email_me("Google reviews last month", "\n\n".join(sections))
    return {"locations": len(sections)}