Text a daily tip or question from a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from twilio.rest import Client
import random
from datetime import date
from clickruntime import on_trigger, credentials, http, notify

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):
    tips = sheets().get(spreadsheetId=SHEET_ID, range="Tips!A2:B").execute().get("values", [])
    unused = [(i, r[0]) for i, r in enumerate(tips, start=2) if r and len(r) < 2]
    if not unused:
        notify.email_me("Daily tips: none left", "Add more rows to the Tips sheet.")
        return {"sent": 0}
    row, tip = random.choice(unused)
    numbers = [r[0] for r in sheets().get(spreadsheetId=SHEET_ID, range="Subscribers!A2:A").execute().get("values", []) if r]
    for n in numbers:
        sms(n, tip)
    sheets().update(spreadsheetId=SHEET_ID, range=f"Tips!B{row}", valueInputOption="RAW", body={"values": [[date.today().isoformat()]]}).execute()
    return {"sent": len(numbers)}