Every 15 minutes
Score CVs from email against your Notion job profiles
Each job application that arrives by email is scored against the matching role in Notion, with the result saved and emailed to you.
- Runs
- Every 15 minutes
- Apps
- Gmail, Notion
- AI
- Yes, uses the built-in AI allowance
- Access
- Gmail gmail.readonly; Notion read+insert
Send this to your assistant
Create a ClickRuntime automation: every 15 minutes, check Gmail for new job applications, compare each CV to the job description in my Notion Jobs database, save the score in Notion and email me a summary.
First time? Adding ClickRuntime to your assistant takes about two minutes.
Why use it
Why teams use this automation
A small company hiring for two or three roles gets dozens of applications by email each week. The founder or hiring manager reads them in the evening, and good candidates wait days for a reply while weaker ones take up the same reading time.
Scoring each CV against the job profile you already keep in Notion gives you a first sort the moment it arrives. You still make every decision, but you start with the strongest applications and reply to them sooner.
What you get out of it
Strong candidates get a fast reply
Good candidates are often talking to other companies. Seeing a high score within minutes lets you reply the same day.
Every CV is judged on the same criteria
Each application is compared to the same written job profile. That is more consistent than reading forty CVs at the end of a tiring day.
Reasons, not just a number
Each score comes with a short explanation of strengths and gaps. You can check the reasoning quickly instead of trusting a bare figure.
Your candidate list builds itself
Every application is recorded in Notion with its score and summary. You have a sortable list of candidates without entering anything by hand.
How it works
What happens, step by step
Every 15 minutes, ClickRuntime checks Gmail for new application emails with a CV attached.
Emails it has already scored are skipped, and if there are none it stops there.
It finds the matching role in your Notion Jobs database, and AI compares the CV with that job profile to give a score and short reasons.
The candidate, score and reasons are saved in your Notion Candidates database, and you get an email summary.
Before it runs live
- Connect Google through your own Google app (a one-time, 10-minute setup), so it works with your own Gmail
- Connect Notion and share the database you want it to use
What you get
Build your own
Need it to work differently?
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 Gmail and Notion steps into one automation
Under the hood
The code that runs this automation
import base64, io
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai, notify, state, report_fetched
from pypdf import PdfReader
JOBS_DB, CANDIDATES_DB = "your-jobs-db-id", "your-candidates-db-id"
@on_trigger
def run(event):
gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).users()
seen = set(state.get("seen") or [])
ids = [m["id"] for m in gmail.messages().list(userId="me", q="subject:application has:attachment newer_than:2d").execute().get("messages", []) if m["id"] not in seen]
report_fetched(len(ids))
if not ids:
return {"summary": "Nothing new"}
nh = {"Authorization": f"Bearer {credentials.connection('notion', 'work')}", "Notion-Version": "2022-06-28"}
jobs = http.post(f"https://api.notion.com/v1/databases/{JOBS_DB}/query", headers=nh, json={}).json()["results"]
for mid in ids:
msg = gmail.messages().get(userId="me", id=mid).execute()
subject = next(h["value"] for h in msg["payload"]["headers"] if h["name"] == "Subject")
part = next(p for p in msg["payload"].get("parts", []) if p.get("filename", "").lower().endswith(".pdf"))
raw = gmail.messages().attachments().get(userId="me", messageId=mid, id=part["body"]["attachmentId"]).execute()["data"]
cv = "".join(p.extract_text() or "" for p in PdfReader(io.BytesIO(base64.urlsafe_b64decode(raw))).pages)[:12000]
job = next((j for j in jobs if j["properties"]["Name"]["title"][0]["plain_text"].lower() in subject.lower()), None)
profile = job["properties"]["Description"]["rich_text"][0]["plain_text"] if job else "general role"
res = ai.generate(f"Score this CV 0-100 against the job and give 3 reasons.\nJOB:\n{profile}\nCV:\n{cv}", max_output_tokens=300).text
http.post("https://api.notion.com/v1/pages", headers=nh, json={"parent": {"database_id": CANDIDATES_DB}, "properties": {
"Name": {"title": [{"text": {"content": subject[:100]}}]}, "Assessment": {"rich_text": [{"text": {"content": res[:1900]}}]}}})
notify.email_me(f"CV scored: {subject[:150]}", res)
seen.add(mid)
state.set("seen", list(seen)[-1000:])
return {"scored": len(ids)}FAQ
Common questions
How does it match an application to a role?
Does it reject candidates automatically?
What file types can it read?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Track sponsorship offers from Gmail in Notion
Sponsorship and brand deal emails are spotted in your Gmail and added to your Notion deals board with brand, budget and deadline.
See how it worksSummarise and sort new emails into a Notion inbox
Every hour, your new emails are summarised, given a category and added to your Notion inbox database with any action needed.
See how it worksSave labelled Gmail emails to Notion
Any email you label Notion in Gmail is saved as a page in your Notion database with its subject, sender and text.
See how it worksKeep exploring
Set up “Score CVs from email against your Notion job profiles” from your assistant
Copy the prompt above, or connect your assistant first. Free plan, no credit card.