Log your weekly website numbers to a sheet

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

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

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", [])

SHEET_ID = "your-spreadsheet-id"
METRICS = ["totalUsers", "sessions", "engagementRate", "conversions"]

@on_trigger
def run(event):
    r = ga({"dateRanges": [{"startDate": "7daysAgo", "endDate": "yesterday"}], "metrics": [{"name": m} for m in METRICS]})
    values = [round(float(v["value"]), 3) for v in r[0]["metricValues"]] if r else [0] * len(METRICS)
    week = (date.today() - timedelta(days=7)).isoformat()
    sheet = api("sheets", "v4").spreadsheets().values()
    sheet.append(spreadsheetId=SHEET_ID, range="Website Metrics!A:E", valueInputOption="RAW", body={"values": [[week] + values]}).execute()
    history = sheet.get(spreadsheetId=SHEET_ID, range="Website Metrics!A1:E").execute().get("values", [])[-9:]
    summary = ai.generate("\n".join(", ".join(map(str, row)) for row in history),
                          system="These are weekly website metrics (week, users, sessions, engagement rate, conversions). "
                          "In 4 sentences, explain how the latest week compares with recent weeks.", max_output_tokens=200).text
    notify.email_me(f"Website metrics logged for week of {week}", summary)
    return {"logged": week}