Screen job applications with AI and log them in a sheet

import base64
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, ai

SHEET_ID, HR_EMAIL = "your-applicants-sheet-id", "hr@example.com"
JOB = "Shift manager: 2+ years supervising staff, cash handling, food safety certificate."

def send(gmail, to, subject, text):
    msg = EmailMessage()
    msg["To"], msg["Subject"] = to, subject
    msg.set_content(text)
    gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()

@on_event
def handle(event):
    a = event.event
    schema = {"type": "object", "properties": {"score": {"type": "integer"}, "reason": {"type": "string"}}, "required": ["score", "reason"]}
    res = ai.generate(f"Rate this CV 1-10 against the job.\nJob: {JOB}\nCV: {a.get('cv', '')}", json_schema=schema).json
    creds = Credentials(credentials.connection("google", "work"))
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Applicants!A:D", valueInputOption="USER_ENTERED",
        body={"values": [[a.get("name"), a.get("email"), res["score"], res["reason"]]]}).execute()
    gmail = build("gmail", "v1", credentials=creds, cache_discovery=False)
    send(gmail, HR_EMAIL, f"New applicant: {a.get('name')} ({res['score']}/10)", res["reason"])
    send(gmail, a.get("email"), "We received your application", "Thanks for applying. We will be in touch within a week.")
    return {"score": res["score"]}