Score job listings against your CV into Airtable

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai, state

BASE_ID = "appXXXXXXXXXXXXXX"
SHEET_ID = "1AbCdEfGhIjKlMnOpQrStUvWxYz"
CV = "Product designer, 7 years, B2B SaaS, design systems, Figma, user research, remote."
SCHEMA = {"type": "object", "properties": {"score": {"type": "integer"}, "summary": {"type": "string"}},
          "required": ["score", "summary"]}

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Jobs!A2:D").execute().get("values", [])
    done = int(state.get("rows_scored") or 0)
    headers = {"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"}
    matches = 0
    for title, company, link, desc in [(r + ["", "", "", ""])[:4] for r in rows[done:]]:
        result = ai.generate(f"CV:\n{CV}\n\nJob: {title} at {company}\n{desc[:4000]}", json_schema=SCHEMA, max_output_tokens=200,
                             system="Score the fit 1-10 and write 2-3 lines on which experience matches the role.").json
        if result["score"] > 7:
            matches += 1
            http.post(f"https://api.airtable.com/v0/{BASE_ID}/Applications", headers=headers, json={"typecast": True,
                      "records": [{"fields": {"Role": title, "Company": company, "Link": link, "Score": result["score"],
                                   "Summary": result["summary"], "Status": "To apply"}}]}).raise_for_status()
    state.set("rows_scored", len(rows))
    return {"scored": len(rows) - done, "matches": matches}