Turn new Airtable feedback into Trello cards

from clickruntime import on_trigger, credentials, http, ai, log, report_fetched

BASE, TABLE = "your-base-id", "Feedback"
LIST_ID = "your-trello-list-id"

@on_trigger
def run(event):
    at = {"Authorization": f"Bearer {credentials.secret('AIRTABLE_TOKEN')}"}
    url = f"https://api.airtable.com/v0/{BASE}/{TABLE}"
    records = http.get(url, headers=at, params={"filterByFormula": "{Sent} = ''", "maxRecords": 50}).json().get("records", [])
    report_fetched(len(records))
    if not records:
        return {"new": 0}
    trello = {"key": credentials.secret("TRELLO_KEY"), "token": credentials.secret("TRELLO_TOKEN")}
    for r in records:
        text = str(r["fields"].get("Feedback", ""))[:1500]
        try:
            tag = ai.generate(f"Feedback: {text}\nReply as 'category / priority (high, medium, low)'.", max_output_tokens=20).text.strip()
        except ai.AIError as e:
            log.warning("AI unavailable", {"code": e.code})
            tag = ""
        card = http.post("https://api.trello.com/1/cards", params={**trello, "idList": LIST_ID,
                         "name": (f"[{tag}] " if tag else "") + text[:80], "desc": text}).json()
        http.patch(f"{url}/{r['id']}", headers=at, json={"fields": {"Sent": True, "Card": card["shortUrl"]}})
    return {"new": len(records)}