Update your leads sheet and get a follow-up draft after each client meeting

from datetime import datetime, timezone
from clickruntime import on_trigger, credentials, http, state, ai, notify, report_fetched

SHEET = "your-spreadsheet-id"
S = f"https://sheets.googleapis.com/v4/spreadsheets/{SHEET}/values"

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    now = datetime.now(timezone.utc).isoformat()
    since = state.get("since") or now
    events = http.get("https://www.googleapis.com/calendar/v3/calendars/primary/events", headers=h,
                      params={"timeMin": since, "timeMax": now, "singleEvents": True}).json().get("items", [])
    ended = [e for e in events if since <= e.get("end", {}).get("dateTime", "") <= now]
    report_fetched(len(ended))
    if not ended:
        return {"ended": 0}
    rows = http.get(f"{S}/Leads!A2:D", headers=h).json().get("values", [])
    for e in ended:
        for i, r in enumerate(rows, start=2):
            if len(r) > 1 and any(a.get("email") == r[1] for a in e.get("attendees", [])):
                http.put(f"{S}/Leads!C{i}", headers=h, params={"valueInputOption": "RAW"}, json={"values": [["met " + now[:10]]]})
                draft = ai.generate(f"Write a short follow-up email to {r[0]} after our meeting '{e.get('summary')}'. Notes: {r[3] if len(r) > 3 else ''}",
                                    max_output_tokens=300).text
                notify.email_me(f"Follow up with {r[0]}", draft)
    state.set("since", now)
    return {"ended": len(ended)}