Send personalised texts to a list in a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from twilio.rest import Client
from clickruntime import on_trigger, credentials, http, report_fetched

SHEET_ID = "your-spreadsheet-id"
FROM = "+15005550006"

def sms(to, body):
    return Client(credentials.secret("TWILIO_ACCOUNT_SID"), credentials.secret("TWILIO_AUTH_TOKEN")).messages.create(to=to, from_=FROM, body=body)
sheets = lambda: build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()

@on_trigger
def run(event):
    rows = sheets().get(spreadsheetId=SHEET_ID, range="Outbox!A2:E").execute().get("values", [])
    pending = [(i, (r + [""] * 5)[:5]) for i, r in enumerate(rows, start=2) if len(r) > 3 and r[3] == "pending"]
    report_fetched(len(pending))
    if not pending:
        return {"summary": "Nothing pending"}
    for i, (name, phone, message, _, _) in pending:
        try:
            result = ["sent", sms(phone, message.replace("{name}", name)).sid]
        except Exception as e:
            result = ["failed", str(e)[:200]]
        sheets().update(spreadsheetId=SHEET_ID, range=f"Outbox!D{i}:E{i}", valueInputOption="RAW", body={"values": [result]}).execute()
    return {"processed": len(pending)}