Weekly GA4 top pages report in Google Sheets

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http

PROPERTY = "123456789"
SHEET_ID = "your-spreadsheet-id"

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

def pages(start, end, limit):
    rows = ga({"dateRanges": [{"startDate": str(start), "endDate": str(end)}], "dimensions": [{"name": "pagePath"}],
               "metrics": [{"name": "screenPageViews"}, {"name": "totalUsers"}, {"name": "userEngagementDuration"}],
               "orderBys": [{"metric": {"metricName": "screenPageViews"}, "desc": True}], "limit": limit})
    return {r["dimensionValues"][0]["value"]: [float(v["value"]) for v in r["metricValues"]] for r in rows}

@on_trigger
def run(event):
    monday = date.today() - timedelta(days=date.today().weekday() + 7)
    this, prev = pages(monday, monday + timedelta(days=6), 50), pages(monday - timedelta(days=7), monday - timedelta(days=1), 1000)
    table = [["Page", "Views", "Users", "Avg engagement (s)", "Change in views"]]
    for path, (views, users, secs) in this.items():
        before = prev.get(path, [0])[0]
        change = f"{(views - before) / before:+.0%}" if before else "new"
        table.append([path, int(views), int(users), round(secs / max(users, 1)), change])
    name = f"Week of {monday}"
    book = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    book.batchUpdate(spreadsheetId=SHEET_ID, body={"requests": [{"addSheet": {"properties": {"title": name, "index": 0}}}]}).execute()
    book.values().update(spreadsheetId=SHEET_ID, range=f"'{name}'!A1", valueInputOption="RAW", body={"values": table}).execute()
    return {"tab": name, "pages": len(table) - 1}