Email a weekly sprint report to stakeholders

import base64
from email.mime.text import MIMEText
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from collections import Counter
from datetime import date
from clickruntime import on_trigger, credentials, http, ai

JIRA, SITE = "https://api.atlassian.com/ex/jira/your-cloud-id", "https://acme.atlassian.net/browse/"
adf = lambda text: {"type": "doc", "version": 1, "content": [{"type": "paragraph", "content": [{"type": "text", "text": text}]}]}

def jira(method, path, **kw):
    resp = http.request(method, JIRA + path, headers={"Authorization": f"Bearer {credentials.connection('jira', 'work')}", "Accept": "application/json"}, **kw)
    return resp.raise_for_status() or (resp.json() if resp.content else None)
gmail = lambda: build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).users()

def send(to, subject, body, cc=None):
    msg = MIMEText(body)
    msg["To"], msg["Subject"] = to, subject
    if cc: msg["Cc"] = cc
    gmail().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()

TO = "stakeholders@acme.example"

@on_trigger
def run(event):
    issues = jira("POST", "/rest/api/3/search/jql", json={"jql": "project = ENG AND sprint in openSprints()",
                  "fields": ["summary", "status", "duedate", "flagged"], "maxResults": 200})["issues"]
    counts = Counter(i["fields"]["status"]["statusCategory"]["name"] for i in issues)
    risky = [f"{i['key']} {i['fields']['summary']}" for i in issues
             if i["fields"]["status"]["name"] == "Blocked" or (i["fields"].get("duedate") and i["fields"]["status"]["statusCategory"]["key"] != "done"
                                                               and i["fields"]["duedate"] < date.today().isoformat())]
    body = (f"Done: {counts.get('Done', 0)}\nIn progress: {counts.get('In Progress', 0)}\nTo do: {counts.get('To Do', 0)}\n\n"
            "At risk:\n" + ("\n".join(risky) or "none"))
    try:
        body = ai.generate(body, system="Write a 3-sentence plain-language sprint update for stakeholders.", max_output_tokens=200).text + "\n\n" + body
    except (ai.AINotIncluded, ai.AILimitReached):
        pass
    send(TO, "Sprint update", body)
    return dict(counts)