Get a weekly email on how people feel about your posts

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

PAGE_ID = "1234567890"

@on_trigger
def run(event):
    t = {"access_token": credentials.connection("facebook", "work")}
    since = int((datetime.now(timezone.utc) - timedelta(days=7)).timestamp())
    posts = http.get(f"https://graph.facebook.com/v21.0/{PAGE_ID}/posts", params={**t, "since": since}).json()["data"]
    comments = [c["message"][:300] for p in posts
                for c in http.get(f"https://graph.facebook.com/v21.0/{p['id']}/comments", params={**t, "limit": 100}).json()["data"]]
    if not comments:
        return {"comments": 0}
    summary = ai.generate("Summarise sentiment, main themes and comments needing a reply:\n" + "\n".join(comments[:300]),
                          max_output_tokens=600).text
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    raw = f"To: me\r\nSubject: Comment summary: {len(comments)} comments this week\r\n\r\n{summary}"
    gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(raw.encode()).decode()}).execute()
    return {"comments": len(comments)}