Get matching job posts on Telegram and log them in a sheet

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

SHEET_ID = "your-spreadsheet-id"
CHAT_ID = "your-telegram-chat-id"
FEEDS = ["https://jobs.example.com/remote-design.rss"]
PROFILE = "Senior product designer, remote in European time zones, B2B SaaS, no agencies."
SCHEMA = {"type": "object", "properties": {"score": {"type": "integer"}, "reason": {"type": "string"}}}

@on_trigger
def run(event):
    seen = set(state.get("seen") or [])
    posts = [e for f in FEEDS for e in feedparser.parse(http.get(f).content).entries if e.link not in seen]
    report_fetched(len(posts))
    if not posts:
        return {"new": 0}
    rows = []
    for p in posts[:40]:
        try:
            r = ai.generate(f"Profile: {PROFILE}\nJob: {p.title}\n{p.get('summary', '')[:1500]}\nScore 1-10 with a one-line reason.",
                            max_output_tokens=80, json_schema=SCHEMA).json
        except ai.AIError:
            break
        if r["score"] >= 6:
            rows.append([p.title, p.link, r["score"], r["reason"]])
        seen.add(p.link)
    if rows:
        build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values().append(
            spreadsheetId=SHEET_ID, range="Jobs!A:D", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    top = sorted((r for r in rows if r[2] >= 8), key=lambda r: -r[2])[:5]
    if top:
        http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage",
                  json={"chat_id": CHAT_ID, "text": "\n\n".join(f"{r[2]}/10 {r[0]}\n{r[3]}\n{r[1]}" for r in top)})
    state.set("seen", list(seen)[-2000:])
    return {"new": len(posts), "matches": len(rows)}