Text everyone in an Airtable view

import time
from clickruntime import on_trigger, credentials, http

BASE_ID, FROM = "appXXXXXXXXXXXXXX", "+447700900000"
MESSAGE = "Hi {name}, Saturday's match is cancelled because of the weather. Training as normal on Tuesday."

def sms(to, body):
    sid = credentials.secret("TWILIO_ACCOUNT_SID")
    return http.post(f"https://api.twilio.com/2010-04-01/Accounts/{sid}/Messages.json",
                     auth=(sid, credentials.secret("TWILIO_AUTH_TOKEN")), data={"From": FROM, "To": to, "Body": body})

@on_trigger
def run(event):
    api = f"https://api.airtable.com/v0/{BASE_ID}/Contacts"
    headers = {"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"}
    rows = http.get(api, headers=headers, params={"view": "To text",
                    "filterByFormula": "AND({Sent SID}=BLANK(), NOT({Opted out}))"}).json()["records"]
    sent = 0
    for rec in rows:
        f = rec["fields"]
        if not f.get("Phone"):
            continue
        resp = sms(f["Phone"], MESSAGE.format(name=f.get("First name", "there")))
        if resp.ok:
            http.patch(api, headers=headers, json={"records": [{"id": rec["id"], "fields": {"Sent SID": resp.json()["sid"]}}]})
            sent += 1
        time.sleep(1)
    return {"sent": sent, "listed": len(rows)}