Get a weekly list of users who went quiet

from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, credentials, http, notify, state, ai

SUPABASE_URL = "https://your-project.supabase.co"

def sb_headers(**extra):
    key = credentials.secret("SUPABASE_SECRET_KEY")
    return {"apikey": key, "Authorization": f"Bearer {key}", **extra}

@on_trigger
def run(event):
    cutoff = (datetime.now(timezone.utc) - timedelta(days=30)).isoformat()
    users = http.get(f"{SUPABASE_URL}/rest/v1/profiles", params={"select": "id,email,last_seen", "last_seen": f"lt.{cutoff}",
                     "order": "last_seen.asc"}, headers=sb_headers()).json()
    listed = set(state.get("listed") or [])
    new = [u for u in users if u["id"] not in listed]
    if not new:
        return {"new": 0}
    try:
        draft = ai.generate("Write a short, friendly re-engagement email for users who haven't logged in for a month.",
                            max_output_tokens=250).text
    except (ai.AINotIncluded, ai.AILimitReached):
        draft = "(AI draft unavailable this week)"
    lines = [f"{u['email']} (last seen {u['last_seen'][:10]})" for u in new]
    notify.email_me(f"{len(new)} inactive users", "\n".join(lines) + "\n\nDraft email:\n" + draft)
    state.set("listed", list(listed | {u["id"] for u in new}))
    return {"new": len(new)}