Get a weekly website report from Google Analytics by email

import base64
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, http, credentials, ai

def api(name, version):
    return build(name, version, credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)

def send_gmail(to, subject, text):
    raw = base64.urlsafe_b64encode(f"To: {to}\r\nSubject: {subject}\r\nContent-Type: text/plain; charset=utf-8\r\n\r\n{text}".encode()).decode()
    api("gmail", "v1").users().messages().send(userId="me", body={"raw": raw}).execute()

PROPERTY = "123456789"

def ga(body):
    url = f"https://analyticsdata.googleapis.com/v1beta/properties/{PROPERTY}:runReport"
    return http.post(url, headers={"Authorization": f"Bearer {credentials.connection('google', 'work')}"}, json=body).json().get("rows", [])

WEEKS = [{"startDate": "7daysAgo", "endDate": "yesterday"}, {"startDate": "14daysAgo", "endDate": "8daysAgo"}]

@on_trigger
def run(event):
    totals = ga({"dateRanges": WEEKS, "metrics": [{"name": m} for m in ("totalUsers", "sessions", "engagementRate")]})
    pages = ga({"dateRanges": WEEKS[:1], "dimensions": [{"name": "pagePath"}], "metrics": [{"name": "screenPageViews"}],
                "orderBys": [{"metric": {"metricName": "screenPageViews"}, "desc": True}], "limit": 10})
    now, before = ([float(v["value"]) for v in r["metricValues"]] for r in totals)
    names = ["Users", "Sessions", "Engagement rate"]
    lines = [f"{n}: {a:,.2f} ({(a - b) / b * 100:+.0f}%)" if b else f"{n}: {a:,.2f}" for n, a, b in zip(names, now, before)]
    lines += ["", "Top pages:"] + [f"{p['dimensionValues'][0]['value']}: {p['metricValues'][0]['value']} views" for p in pages]
    report = "\n".join(lines)
    note = ai.generate(report, system="In 3-4 plain sentences, explain what changed on this website last week.", max_output_tokens=200).text
    send_gmail("you@example.com, team@example.com", "Website last week", f"{note}\n\n{report}")
    return {"sent": True}