Post upcoming deadlines from a sheet to Teams

from datetime import date, timedelta
from dateutil import parser
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http

SHEET_ID, TEAM_ID, CHANNEL_ID = "your-spreadsheet-id", "your-team-id", "your-channel-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    head, *rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Reviews!A1:Z").execute()["values"]
    today, due = date.today(), []
    for row in rows:
        r = dict(zip(head, row))
        try:
            d = parser.parse(r.get("Due date", ""), dayfirst=True).date()
        except (ValueError, OverflowError):
            continue
        if today <= d <= today + timedelta(days=2) and r.get("Status", "").lower() not in ("done", "complete"):
            due.append(f"<li><b>{r.get('Item', '')}</b>: due {d:%a %d %b}, {r.get('Assignee', 'unassigned')}</li>")
    if due:
        http.post(f"https://graph.microsoft.com/v1.0/teams/{TEAM_ID}/channels/{CHANNEL_ID}/messages",
                  headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"},
                  json={"body": {"contentType": "html", "content": "Due in the next 2 days:<ul>" + "".join(due) + "</ul>"}}).raise_for_status()
    return {"due": len(due)}