Log each sale to a sheet and send a thank-you from Outlook

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, http, credentials, state, notify

api = lambda name, version: build(name, version, credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)

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(",")]}})

SHEET_ID = "your-spreadsheet-id"

@on_event
def handle(event):
    sale = event.json or {}
    if state.get(f"sale:{event.event_id}"):
        return {"duplicate": True}
    row = [event.received_at[:10], sale.get("name", ""), sale["email"], sale.get("product", ""), sale.get("amount", "")]
    api("sheets", "v4").spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Sales!A:E", valueInputOption="USER_ENTERED", body={"values": [row]}).execute()
    first = (sale.get("name") or "there").split()[0]
    try:
        send_mail(sale["email"], f"Thank you for your order, {first}",
                  f"Hi {first},\n\nThank you for buying {sale.get('product', 'from us')}. If anything isn't right, just reply to this email.\n\nBest wishes,\nSam at Northwind Ceramics")
    except Exception as e:
        notify.email_me("Thank-you email failed", f"{sale['email']}: {e}")
    state.set(f"sale:{event.event_id}", True)
    return {"logged": True}