Log daily WooCommerce sales in a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import datetime
from zoneinfo import ZoneInfo
from clickruntime import on_trigger, credentials, http, notify

SHEET_ID, TZ = "your-spreadsheet-id", ZoneInfo("Europe/London")

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

def wc(method, path, **kw):
    resp = http.request(method, STORE + path, auth=(credentials.secret("WC_CONSUMER_KEY"), credentials.secret("WC_CONSUMER_SECRET")), **kw)
    resp.raise_for_status()
    return resp.json()

def sheets():
    return build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()

@on_trigger
def run(event):
    today = datetime.now(TZ).date()
    start = datetime.combine(today, datetime.min.time(), TZ).isoformat()
    orders = wc("GET", "/orders", params={"after": start, "status": "processing,completed", "per_page": 100})
    revenue = sum(float(o["total"]) for o in orders)
    avg = revenue / len(orders) if orders else 0
    sheets().append(spreadsheetId=SHEET_ID, range="Daily!A:D", valueInputOption="RAW",
                    body={"values": [[today.isoformat(), len(orders), round(revenue, 2), round(avg, 2)]]}).execute()
    notify.slack(f"🛒 {today:%a %d %b}: {len(orders)} orders, £{revenue:,.2f} revenue (avg £{avg:,.2f})", channel="#sales")
    return {"orders": len(orders), "revenue": round(revenue, 2)}