Announce new articles and videos on X

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

FEEDS = ["https://blog.example.com/feed", "https://www.youtube.com/feeds/videos.xml?channel_id=UCxxxxxxxx"]
SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    logged = {r[1] for r in sheets.values().get(spreadsheetId=SHEET_ID, range="Log!A2:B").execute().get("values", []) if len(r) > 1}
    new = [e for url in FEEDS for e in feedparser.parse(url).entries[:10] if e.link not in logged]
    report_fetched(len(new))
    if not new:
        return {"posted": 0}
    x = {"Authorization": "Bearer " + credentials.connection("x", "main")}
    rows = []
    for e in new:
        text = ai.generate(f"Write an X post under 240 characters announcing: {e.title}", max_output_tokens=100).text.strip()
        http.post("https://api.x.com/2/tweets", headers=x, json={"text": f"{text}\n{e.link}"}).raise_for_status()
        rows.append([datetime.now(timezone.utc).date().isoformat(), e.link, e.title, text])
    sheets.values().append(spreadsheetId=SHEET_ID, range="Log!A:D", valueInputOption="RAW", body={"values": rows}).execute()
    return {"posted": len(rows)}