Log news from your feeds to a sheet with a daily Notion report

from datetime import date
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, PARENT_PAGE = "your-spreadsheet-id", "your-notion-parent-page-id"
FEEDS = ["https://news.example.com/energy.rss", "https://regulator.example.org/updates.xml"]
SCHEMA = {"type": "array", "items": {"type": "object", "properties": {"category": {"type": "string"}, "summary": {"type": "string"}}}}

@on_trigger
def run(event):
    seen = set(state.get("seen") or [])
    items = [e for f in FEEDS for e in feedparser.parse(http.get(f).content).entries if e.link not in seen][:40]
    report_fetched(len(items))
    if not items:
        return {"new": 0}
    lines = "\n".join(f"{i + 1}. {e.title}: {e.get('summary', '')[:400]}" for i, e in enumerate(items))
    try:
        out = ai.generate(lines, system="For each item give a category (Regulation, Funding, Product, Market, Other) and a two-line summary.", json_schema=SCHEMA, max_output_tokens=2000).json
    except ai.AIError:
        out = [{"category": "Unsorted", "summary": ""} for _ in items]
    rows = [[str(date.today()), e.title, o["category"], o["summary"], e.link] for e, o in zip(items, out)]
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="News!A:E", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    blocks = [{"object": "block", "type": "bulleted_list_item", "bulleted_list_item": {"rich_text": [{"text": {"content": f"[{r[2]}] {r[1]}: {r[3]}"[:1900], "link": {"url": r[4]}}}]}} for r in rows]
    http.post("https://api.notion.com/v1/pages", headers={"Authorization": f"Bearer {credentials.connection('notion', 'work')}", "Notion-Version": "2022-06-28"},
              json={"parent": {"page_id": PARENT_PAGE}, "properties": {"title": {"title": [{"text": {"content": f"News {date.today()}"}}]}}, "children": blocks})
    state.set("seen", (list(seen) + [e.link for e in items])[-3000:])
    return {"new": len(items)}