Get researched social post drafts by email every weekday

import base64
from email.mime.text import MIMEText
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, state, ai

TOPIC = "ransomware small business"
ME = "you@example.com"

@on_trigger
def run(event):
    used = set(state.get("used") or [])
    news = http.get("https://serpapi.com/search", params={"engine": "google_news", "q": TOPIC, "api_key": credentials.secret("SERPAPI_API_KEY")}).json()
    fresh = [n for n in news.get("news_results", []) if n.get("link") and n["link"] not in used][:6]
    if not fresh:
        return {"sent": False}
    sources = "\n".join(f"- {n['title']} ({n['link']})" for n in fresh)
    drafts = ai.generate(f"News on {TOPIC}:\n{sources}\n\nWrite: 1) LinkedIn post 2) post for X under 260 chars 3) Instagram caption. Then list sources.",
                         system="Write in a clear, expert, first-person voice. Use only facts from the news.", max_output_tokens=900).text
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    mime = MIMEText(drafts)
    mime["to"], mime["subject"] = ME, f"Post drafts: {fresh[0]['title'][:80]}"
    gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(mime.as_bytes()).decode()}).execute()
    state.set("used", list(used | {n["link"] for n in fresh})[-300:])
    return {"sent": True, "articles": len(fresh)}