Match refund requests to orders and confirm by email

import re, base64
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http, notify

STORE = "https://shop.example.com/wp-json/wc/v3"

@on_event
def handle(event):
    t = event.json or {}
    email, text = t.get("requester_email", ""), f"{t.get('subject', '')} {t.get('description', '')}"
    num = re.search(r"#(\d{3,})", text)
    auth = (credentials.secret("WOO_KEY"), credentials.secret("WOO_SECRET"))
    orders = http.get(f"{STORE}/orders", auth=auth, params={"include": num.group(1)} if num else {"search": email, "per_page": 1}).json()
    if not orders:
        notify.slack(f"Refund request from {email}: no order found, please check", channel="#support")
        return {"found": False}
    o = orders[0]
    http.post(f"{STORE}/orders/{o['id']}/notes", auth=auth, json={"note": f"Refund requested via ticket {t.get('id')}"})
    items = "\n".join(f"- {li['quantity']} x {li['name']}" for li in o["line_items"])
    msg = EmailMessage()
    msg["To"], msg["Subject"] = o["billing"]["email"], f"We've received your refund request for order #{o['number']}"
    msg.set_content(f"Hi {o['billing']['first_name']},\n\nWe've received your request for order #{o['number']} "
                    f"placed {o['date_created'][:10]}:\n{items}\n\nWe'll get back to you within 2 working days.")
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    notify.slack(f"Refund request for order #{o['number']} (${o['total']}) confirmed to customer", channel="#support")
    return {"found": True, "order": o["number"]}