Log job postings that match your CV in a sheet

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

CV_DOC, SHEET_ID = "your-cv-doc-id", "your-spreadsheet-id"
FEEDS = ["https://jobs.example.com/rss?q=data+analyst"]
SCHEMA = {"type": "object", "properties": {"score": {"type": "integer"}, "reason": {"type": "string"}}}

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    cv = http.get(f"https://www.googleapis.com/drive/v3/files/{CV_DOC}/export", params={"mimeType": "text/plain"},
                  headers={"Authorization": f"Bearer {creds.token}"}).text[:5000]
    seen = state.get("seen") or []
    posts = [e for f in FEEDS for e in feedparser.parse(http.get(f).text).entries if e.link not in seen][:30]
    rows = []
    for p in posts:
        r = ai.generate(f"CV:\n{cv}\n\nJob: {p.title}\n{p.get('summary', '')[:2000]}\nScore fit 1-10 with a one-line reason.",
                        json_schema=SCHEMA, max_output_tokens=80).json
        if r["score"] >= 7:
            rows.append([p.title, p.get("author", ""), p.link, r["score"], r["reason"]])
        seen.append(p.link)
    if rows:
        build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(spreadsheetId=SHEET_ID,
            range="Jobs!A:E", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    state.set("seen", seen[-2000:])
    return {"scored": len(posts), "matches": len(rows)}