Send a daily topic digest to subscribers in an Excel list

import feedparser
from clickruntime import on_trigger, http, credentials, ai

def graph(method, path, **kw):
    r = http.request(method, "https://graph.microsoft.com/v1.0" + path, headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}, **kw)
    return r.raise_for_status() or (r.json() if r.content else None)

def send_mail(to, subject, text):
    graph("POST", "/me/sendMail", json={"message": {"subject": subject, "body": {"contentType": "Text", "content": text},
          "toRecipients": [{"emailAddress": {"address": a}} for a in to.split(",")]}})

BOOK = "/me/drive/items/your-workbook-id/workbook"
FEEDS = {"regulation": "https://www.example.gov/news.rss", "prices": "https://www.example.com/markets/feed"}

@on_trigger
def run(event):
    rows = [r["values"][0] for r in graph("GET", f"{BOOK}/tables/Subscribers/rows")["value"]]
    digests = {}
    for topic, url in FEEDS.items():
        entries = feedparser.parse(http.get(url).content).entries[:15]
        if entries:
            digests[topic] = ai.generate("\n".join(f"{e.title} {e.link}" for e in entries), system=f"Write a 5-bullet digest of today's {topic} news, "
                                         "each with its link.", max_output_tokens=400).text
    sent = 0
    for name, email, topics in rows:
        parts = [f"{t.strip().title()}\n{digests[t.strip()]}" for t in str(topics).split(",") if t.strip() in digests]
        if parts:
            send_mail(email, "Your daily briefing", f"Hi {str(name).split()[0]},\n\n" + "\n\n".join(parts))
            sent += 1
    return {"sent": sent}