Get a daily Telegram news digest on your own topics

from datetime import date
from urllib.parse import quote
import feedparser
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai, log

SHEET_ID, CHAT_ID = "your-spreadsheet-id", "your-chat-id"

@on_trigger
def run(event):
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")),
                   cache_discovery=False).spreadsheets().values()
    topics = [r[0] for r in values.get(spreadsheetId=SHEET_ID, range="Topics!A2:A").execute().get("values", []) if r]
    lines = []
    for t in topics:
        feed = feedparser.parse(http.get(f"https://news.google.com/rss/search?q={quote(t)}").content)
        lines += [f"[{t}] {e.title} {e.link}" for e in feed.entries[:4]]
    try:
        digest = ai.generate("Write a short news digest grouped by topic, one line per story, keep links:\n" + "\n".join(lines),
                             max_output_tokens=900).text
    except ai.AIError as e:
        log.warning("AI unavailable, sending headlines", {"code": e.code})
        digest = "\n".join(lines)
    http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage",
              json={"chat_id": CHAT_ID, "text": digest[:4000]})
    values.append(spreadsheetId=SHEET_ID, range="Log!A:C", valueInputOption="RAW",
                  body={"values": [[date.today().isoformat(), ", ".join(topics), len(lines)]]}).execute()
    return {"topics": len(topics), "stories": len(lines)}