Get a weekly sales summary on WhatsApp

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

SHEET_ID = "your-spreadsheet-id"
MY_PHONE = "447700900123"
WA = "https://graph.facebook.com/v20.0/your-phone-number-id/messages"

def wa(to, text):
    http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"},
              json={"messaging_product": "whatsapp", "to": to, "type": "text", "text": {"body": text}}).raise_for_status()

@on_trigger
def run(event):
    rows = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
        .spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Sales!A2:B").execute().get("values", [])
    monday = date.today() - timedelta(days=date.today().weekday())
    weeks = [0.0] * 4
    for d, amount in (r for r in rows if len(r) > 1):
        ago = (monday - date.fromisoformat(d)).days
        if 0 < ago <= 28:
            weeks[(ago - 1) // 7] += float(amount)
    last, prev = weeks[0], weeks[1]
    text = f"Sales last week: {last:,.0f} ({last - prev:+,.0f} vs week before). 4-week average: {sum(weeks) / 4:,.0f}."
    try:
        text += "\n" + ai.generate(text, system="Add one short, plain sentence of comment for a small business owner.", max_output_tokens=60).text.strip()
    except ai.AIError:
        pass
    wa(MY_PHONE, text)
    return {"last_week": last}