Copy yesterday's metrics from a sheet into a Notion daily report

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

SHEET_ID, DB_ID = "your-spreadsheet-id", "your-notion-database-id"

@on_trigger
def run(event):
    day = (date.today() - timedelta(days=1)).isoformat()
    rows = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values().get(
        spreadsheetId=SHEET_ID, range="Metrics!A2:D", valueRenderOption="UNFORMATTED_VALUE").execute().get("values", [])
    mine = [r for r in rows if str(r[0]).startswith(day) and len(r) >= 4]
    if not mine:
        return {"rows": 0}
    spend, clicks, conv = (sum(float(r[i] or 0) for r in mine) for i in (1, 2, 3))
    http.post("https://api.notion.com/v1/pages", headers={"Authorization": f"Bearer {credentials.connection('notion', 'work')}",
        "Notion-Version": "2022-06-28"}, json={"parent": {"database_id": DB_ID}, "properties": {
        "Name": {"title": [{"text": {"content": f"Report {day}"}}]}, "Date": {"date": {"start": day}},
        "Spend": {"number": round(spend, 2)}, "Clicks": {"number": clicks}, "Conversions": {"number": conv},
        "Cost per conversion": {"number": round(spend / conv, 2) if conv else None}}})
    return {"rows": len(mine), "spend": round(spend, 2)}