Get a daily email of Reddit brand mentions

import base64
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, state, ai

QUERY, ME = '"Acme Analytics"', "me@example.com"
SCHEMA = {"type": "object", "properties": {"labels": {"type": "array", "items": {"enum": ["positive", "neutral", "negative"]}}}}

def reddit(path, **params):
    headers = {"Authorization": "Bearer " + credentials.connection("reddit", "main"), "User-Agent": "clickruntime/1.0"}
    return [c["data"] for c in http.get(f"https://oauth.reddit.com{path}", headers=headers, params=params).json()["data"]["children"]]

def send_email(subject, text):
    msg = EmailMessage()
    msg["To"], msg["Subject"] = ME, subject
    msg.set_content(text)
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()

@on_trigger
def run(event):
    seen = set(state.get("seen") or [])
    posts = [p for p in reddit("/search", q=QUERY, sort="new", t="day", limit=50) if p["id"] not in seen]
    if not posts:
        send_email("Reddit mentions: none yesterday", "No new Reddit posts mentioned Acme Analytics.")
        return {"mentions": 0}
    listing = "\n".join(f"{i}. {p['title']} | {p['selftext'][:300]}" for i, p in enumerate(posts))
    labels = ai.generate(listing, json_schema=SCHEMA, max_output_tokens=200,
                         system="Give the sentiment toward Acme Analytics for each numbered post, in order.").json["labels"]
    lines = [f"[{l}] {p['title']} (r/{p['subreddit']})\nhttps://reddit.com{p['permalink']}" for p, l in zip(posts, labels)]
    send_email(f"Reddit mentions: {len(lines)} yesterday", "\n\n".join(lines))
    state.set("seen", (list(seen) + [p["id"] for p in posts])[-2000:])
    return {"mentions": len(lines)}