Send WhatsApp reminders on the dates in a sheet

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

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

def wa_template(to, name, params):
    body = {"messaging_product": "whatsapp", "to": to, "type": "template", "template": {"name": name, "language": {"code": "en"},
            "components": [{"type": "body", "parameters": [{"type": "text", "text": str(p)} for p in params]}]}}
    return http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"}, json=body).json()

@on_trigger
def run(event):
    vals = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    rows = vals.get(spreadsheetId=SHEET_ID, range="Reminders!A2:E").execute().get("values", [])
    today, sent = date.today().isoformat(), 0
    for i, r in enumerate(rows, start=2):
        r = (r + [""] * 5)[:5]
        name, phone, when, detail, done = r
        if when != today or done:
            continue
        wa_template(phone, "daily_reminder", [name, detail])
        vals.update(spreadsheetId=SHEET_ID, range=f"Reminders!E{i}", valueInputOption="RAW", body={"values": [[f"sent {today}"]]}).execute()
        sent += 1
    return {"sent": sent}