Skip to content

Every 30 minutes

Score CVs in a Drive folder and keep a ranked report Doc

Every CV you drop into your Applicants folder is scored against the job description and added to a ranked summary in a Google Doc.

Runs
Every 30 minutes
Apps
Google Docs, Google Drive
AI
Yes, uses the built-in AI allowance
Access
Drive read (folder); Docs write

Send this to your assistant

Create a ClickRuntime automation: score every CV in my Drive 'Applicants' folder against this job description and keep a ranked summary in a Google Doc.

Paste it into your assistant. It tells you what it will send or change before it runs live.

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

The founder of a ten-person company posts a role and gets ninety applications. The CVs land in a Drive folder and she opens them one by one in the evenings, forgetting by number forty what made number six stand out.

Scoring each CV against the same job description and keeping a running ranked list lets you start with the strongest candidates and compare people fairly.

What you get out of it

  • Start with the strongest applicants

    A ranked list means your limited time goes to the CVs most likely to fit.

  • The same yardstick for everyone

    Every CV is compared with the same job description, which keeps the first pass consistent.

  • Reasons, not just numbers

    Each entry has a short note on strengths and gaps, so you know why a CV scored as it did.

  • Easy to share with the hiring panel

    The report is a normal Google Doc that colleagues can read and comment on.

How it works

What happens, step by step

  1. Every 30 minutes ClickRuntime checks your Applicants folder in Google Drive for new CVs.

  2. It skips CVs it has already scored.

  3. AI compares each new CV with your job description and gives a score out of 10 with a short note on strengths and gaps.

  4. Each scored candidate is added to your report Google Doc.

Before it runs live

  • Connect Google Docs
  • Connect Google Drive

What you get

RunsEvery 30 minutes
Score CVs in a Drive folder and keep a ranked report Doctoday, 9:00Succeeded
Google Docs · CV rankingTaylor_Kim_CV.pdf: 8/10. Six years of Python and Postgres at Northwind Labs, led a team of three. Gap: little AWS experience.

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.
  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

  • Act only on the items that match your own rules, and skip the rest
  • Change what the AI looks for, or how it writes the result
  • Add another app, for example also send it to Slack
  • Combine it with other Google Docs and Google Drive steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.
rank_cvs_from_a_drive_folder_into_a_doc_report.pyexample
from clickruntime import on_trigger, credentials, http, state, ai, report_fetched

FOLDER, DOC = "your-applicants-folder-id", "your-report-doc-id"
JOB = "Senior backend engineer: Python, Postgres, AWS, 5+ years, has led a small team."
D = "https://www.googleapis.com/drive/v3/files"

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    since = state.get("since") or "2026-01-01T00:00:00Z"
    files = http.get(D, headers=h, params={"q": f"'{FOLDER}' in parents and createdTime > '{since}' and trashed = false",
                                           "orderBy": "createdTime", "fields": "files(id,name,mimeType,createdTime)"}).json()["files"]
    report_fetched(len(files))
    if not files:
        return {"new": 0}
    lines = []
    for f in files:
        if f["mimeType"] == "application/vnd.google-apps.document":
            text = http.get(f"{D}/{f['id']}/export", headers=h, params={"mimeType": "text/plain"}).text
        else:
            text = http.get(f"{D}/{f['id']}", headers=h, params={"alt": "media"}).content.decode("utf-8", "ignore")
        note = ai.generate(f"Job: {JOB}\nCV:\n{text[:12000]}\nReply: score/10, one-line summary, strengths, gaps.", max_output_tokens=200).text
        lines.append(f"{f['name']}\n{note.strip()}\n\n")
    http.post(f"https://docs.googleapis.com/v1/documents/{DOC}:batchUpdate", headers=h, json={"requests": [
        {"insertText": {"endOfSegmentLocation": {}, "text": "".join(lines)}}]})
    state.set("since", files[-1]["createdTime"])
    return {"scored": len(files)}

FAQ

Common questions

Does the AI make the hiring decision?
No. It gives a first-pass score and notes to help you decide which CVs to read first. Every decision stays with you.
Which file types does it read?
PDFs, Word documents and Google Docs dropped into the folder.
What does the report look like?
A Google Doc listing each candidate with their score out of 10, a one-line summary and their main strengths and gaps, newest scores added as they come in.
What permissions does it need?
Drive read (folder); Docs write. Nothing else in your accounts is used.
Does it need AI?
Yes. It uses ClickRuntime's built-in AI, so you don't need an OpenAI or Anthropic key. Every plan includes a monthly AI allowance.
How many runs does it use?
One run each time it checks. Checks that find nothing new and stop right away aren't counted.
Can I change how it works?
Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Set up “Score CVs in a Drive folder and keep a ranked report Doc” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.