January 22, 2026

Gmail + Google Sheets: CV scores sorted for you

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your inbox shouldn’t be your hiring system. But when CVs arrive in Gmail all day, it quietly becomes one: downloads, renames, “where did I save that file?”, then a rushed first-pass review that changes depending on who’s reading.

This Gmail CV scoring automation hits HR managers first, honestly. Recruiters feel it too. Founders doing hiring between meetings get the worst of it, because screening time steals from everything else.

This workflow pulls CVs from Gmail, stores the original in Google Drive, scores the candidate with GPT-4 against the right job details, then logs everything into Google Sheets so you can shortlist faster and more consistently.

How This Automation Works

See how this solves the problem:

n8n Workflow Template: Gmail + Google Sheets: CV scores sorted for you

Click to explore

flowchart LR

    subgraph sg0["Gmail: Watch for new CV Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Gmail: Watch for new CV", pos: "b", h: 48 }
        n1@{ icon: "mdi:robot", form: "rounded", label: "Classify Email Type", pos: "b", h: 48 }
        n2@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Model – Email Classif..", pos: "b", h: 48 }
        n3@{ icon: "mdi:cog", form: "rounded", label: "Skip (If not a job applicati..", pos: "b", h: 48 }
        n4@{ icon: "mdi:cog", form: "rounded", label: "Extract Resume Text (PDF)", pos: "b", h: 48 }
        n5@{ icon: "mdi:cog", form: "rounded", label: "Save Resume to Google Drive", pos: "b", h: 48 }
        n6@{ icon: "mdi:database", form: "rounded", label: "Retrieve Job Offer Details (..", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "AI Agent: Score Resume", pos: "b", h: 48 }
        n8@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Model – Resume Scoring", pos: "b", h: 48 }
        n9@{ icon: "mdi:message-outline", form: "rounded", label: "Send Confirmation Email", pos: "b", h: 48 }
        n10@{ icon: "mdi:robot", form: "rounded", label: "Parse Resume Evaluation Result", pos: "b", h: 48 }
        n11@{ icon: "mdi:database", form: "rounded", label: "Save Score to Google Sheets", pos: "b", h: 48 }
        n12@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Switch", pos: "b", h: 48 }
        n13@{ icon: "mdi:database", form: "rounded", label: "Save CV to Google Sheets", pos: "b", h: 48 }
        n12 --> n5
        n12 --> n4
        n1 --> n3
        n1 --> n12
        n7 --> n11
        n0 --> n1
        n9 -.-> n7
        n4 --> n6
        n5 --> n13
        n10 -.-> n7
        n8 -.-> n7
        n2 -.-> n1
        n6 --> n7
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n1,n7,n10 ai
    class n2,n8 aiModel
    class n12 decision
    class n6,n11,n13 database

The Challenge: Consistent CV Screening Without Living in Your Inbox

Manual resume review feels simple until volume shows up. A candidate emails a PDF, you download it, scan it, and try to remember the job requirements from a doc you opened yesterday. Then another CV lands, and another, and suddenly you have three versions of the “shortlist” living in different places. The real pain isn’t just time. It’s inconsistency, lost context, and the nagging sense you might be missing strong candidates because you’re tired or rushed.

It adds up fast. Here’s where it breaks down in day-to-day hiring.

CVs get reviewed with different standards because the job criteria isn’t right in front of you every time.
Attachments get saved “somewhere,” which becomes a scavenger hunt when a hiring manager asks for the original file.
Good candidates slip through because the first pass takes too long, so follow-ups happen late.
Notes live in email threads or sticky docs, which makes filtering and comparing candidates a chore.

The Fix: Auto-Score CVs From Gmail and Sort Them in Sheets

This workflow turns your incoming CV emails into a clean, searchable screening pipeline. When a new email hits your CV inbox, it first checks if the message is actually an application (not a vendor pitch or a random newsletter). If it is, the workflow looks for the resume attachment, stores the original file in Google Drive, and extracts the text from the PDF so it’s usable for evaluation. Next, it pulls the relevant job details from a connected Google Sheet and asks GPT-4 to score the candidate against that role. Finally, it writes the score and key notes back into your central Google Sheet and sends a receipt email to the applicant so they know you got it.

The workflow starts with Gmail monitoring your inbox. From there, an AI classifier filters noise, PDF text extraction makes the resume readable, and Google Drive keeps the original safe. Then GPT-4 evaluates fit using job data from Sheets, and the final score lands in a single spreadsheet row you can sort and filter.

What Changes: Before vs. After

What This Eliminates

Impact You’ll See

Downloading PDFs, renaming files, and manually uploading them to a drive folder.
Reading every email thread just to find the latest resume and context.
Scoring candidates from memory because the job criteria isn’t pulled into the process.
Copy-pasting notes into a spreadsheet row-by-row after the fact.

Most teams save about 5 hours a week once applications pick up.
More consistent first-pass screening because every CV is scored against the same job sheet.
A Drive link to the original resume is always stored with the candidate record.
Sorting by score becomes instant, so shortlist reviews take minutes, not an afternoon.
Applicants get a quick confirmation email automatically, which reduces follow-up noise.

Real-World Impact

Say you receive 20 CVs a week for one role. Manually, you might spend about 10 minutes per email to download the file, skim it, compare it to the job description, then log notes somewhere, which is roughly 3 hours a week. With this workflow, you spend maybe 5 minutes setting it up once, then each new CV is automatically filed in Drive and scored into Sheets while you keep working. You just open the spreadsheet and sort by score.

Requirements

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Gmail to detect new CV emails and reply.
Google Sheets to store job details and candidate scores.
Google Drive to store original resume files securely.
OpenAI API key (get it from your OpenAI dashboard).

Skill level: Intermediate. You’ll connect Google accounts in n8n and paste an API key, then adjust a few sheet columns and prompts.

Need help implementing this? Talk to an automation expert (free 15-minute consultation).

The Workflow Flow

Gmail detects a new CV email. The workflow watches the inbox you use for applications, then grabs the message content and attachments as soon as it arrives.

An AI classifier filters out non-applications. Using an OpenAI chat model plus a text classification step, it separates actual candidates from everything else so your sheet doesn’t fill with junk.

The resume is stored and converted into usable text. If there’s an attachment, the PDF is uploaded to Google Drive, and the workflow extracts the resume text so GPT-4 can evaluate it reliably.

Job details are pulled from Google Sheets, then scoring happens. The workflow fetches the job offer row (or sheet) you maintain, sends the job criteria plus resume text into the AI scoring agent, and parses the structured output into a clean score and notes.

Results land in Sheets and the applicant gets a receipt. Candidate name, score, notes, and a Drive link are recorded, and Gmail sends a simple confirmation email back to the applicant.

You can easily modify the scoring criteria to match each role, or expand the sheet columns to include “Stage,” “Owner,” or “Interview date” based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Gmail Trigger

Set up the inbound email trigger so only unread emails with attachments are processed for resume intake.

Open Gmail CV Watcher and confirm the filter query is set to has:attachment.
Set Read status to unread and ensure Download attachments is enabled.
Set the polling schedule to run everyHour at minute 1.
Credential Required: Connect your gmailOAuth2 credentials to Gmail CV Watcher.

Tip: Test with a real resume email marked as unread to confirm attachments download correctly.

Step 2: Connect Google Drive and Google Sheets

Store attachments in Drive and log links and scoring data into Sheets.

In Store Resume in Drive, set Name to {{ $('Gmail CV Watcher').item.json.from.value[0].address }} and Input Data Field Name to attachment_0.
Select the target folder for resumes in Store Resume in Drive (e.g., the folder labeled CV - HR).
Credential Required: Connect your googleDriveOAuth2Api credentials to Store Resume in Drive.
In Append CV Link Sheet, keep Operation as append and map Email to {{ $('Gmail CV Watcher').item.json.from.value[0].address }} and Link CV to {{ $('Store Resume in Drive').item.json.webViewLink }}.
In Fetch Job Offer Sheet, select the correct Document and Sheet where job descriptions live.
In Record Score in Sheets, keep Operation as appendOrUpdate and Matching Columns set to Email.
Credential Required: Connect your googleSheetsOAuth2Api credentials to Append CV Link Sheet, Fetch Job Offer Sheet, and Record Score in Sheets.

⚠️ Common Pitfall: If the Document or Sheet selectors are blank, the nodes will run but log no data. Make sure each Sheets node points to an actual file and tab.

Step 3: Set Up Classification and Routing

Classify the email intent and route only valid job applications with attachments.

In Categorize Email Intent, set Input Text to {{ $json.text }}.
Ensure OpenAI Classifier Model is connected as the language model for Categorize Email Intent.
Credential Required: Connect your openAiApi credentials to OpenAI Classifier Model.
In Route Attachment Presence, keep the rules that check for attachment_0 existence.
Confirm the route from Categorize Email Intent to Ignore Non-Applications handles the “Doesn't apply” category.

Tip: If classification is too strict, adjust the category descriptions in Categorize Email Intent before running live.

Step 4: Set Up Resume Extraction and AI Scoring

Extract PDF text, fetch the job description, and run the AI agent to score candidates.

In Extract PDF Resume Text, set Operation to pdf and Binary Property Name to attachment_0.
In AI Resume Scoring Agent, set the Text field to the full prompt including {{ $('Extract PDF Resume Text').item.json.text }}, {{ $json['Title offer'] }}, and {{ $json.Description }}.
Ensure OpenAI Scoring Model is connected as the language model for AI Resume Scoring Agent.
Credential Required: Connect your openAiApi credentials to OpenAI Scoring Model.
Confirm Parse Scoring Output is connected as the output parser for AI Resume Scoring Agent and uses the provided JSON schema.

⚠️ Common Pitfall: Parse Scoring Output is an AI sub-node—add credentials to OpenAI Scoring Model and not to the parser itself.

Step 5: Configure Output Actions

Log the AI results and send a confirmation email to the candidate.

In Record Score in Sheets, map fields to the AI output and resume text, including {{ $json.output.name }}, {{ $json.output.score }}, and {{ $('Extract PDF Resume Text').item.json.text }}.
In Send Receipt Email, set Send To to {{ $('Gmail CV Watcher').item.json.from.value[0].address }} and Subject to Application Received.
Leave the AI-generated message as {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }} so the agent can compose it.
Credential Required: Connect your gmailOAuth2 credentials to Send Receipt Email.

Tip: Send Receipt Email is an AI tool sub-node—ensure credentials are added to the Gmail tool itself, and verify the agent has permission to use it.

Step 6: Test and Activate Your Workflow

Validate the end-to-end flow before switching it on for production.

Manually run the workflow by sending an unread email with a PDF resume attachment to the monitored inbox.
Confirm that Store Resume in Drive creates a file and Append CV Link Sheet logs the email and Drive link.
Verify that Record Score in Sheets writes the candidate’s extracted details and score.
Check the inbox for the confirmation email sent by Send Receipt Email.
Once successful, toggle the workflow to Active for continuous processing.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Watch Out For

Google OAuth credentials can expire or need specific permissions. If things break, check the n8n credential connection status and your Google Cloud API access first (Gmail, Drive, and Sheets).
If your resumes are large or scanned PDFs, PDF text extraction can return thin results. In that case, you may need a different extraction method, or you’ll see vague AI scoring because there’s not enough text.
Default AI prompts are generic. Add your must-haves (years of experience, required tools, location rules) early, or you will be second-guessing scores in the sheet every day.

Common Questions

How quickly can I implement this Gmail CV scoring automation?

About an hour if your Google accounts and OpenAI key are ready.

Can non-technical teams implement this CV scoring?

Yes, but you’ll want one person comfortable with connecting OAuth credentials in n8n. No coding, just setup and a bit of testing with real emails.

Is n8n free to use for this Gmail CV scoring workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage, which is usually a few cents per CV depending on resume length and your prompt.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

How do I adapt this Gmail CV scoring solution to my specific challenges?

You can change the evaluation criteria inside the AI Resume Scoring Agent prompt so the score reflects your hiring rubric, not a generic “good resume” standard. Many teams add columns like “Must-have match,” “Concerns,” and “Recommended stage,” then map those fields from Parse Scoring Output straight into Record Score in Sheets. If you hire for multiple roles, pull different job profiles in Fetch Job Offer Sheet and route to different prompts based on the role name. You can also replace the receipt message in Send Receipt Email to match your tone and include next steps.

Why is my Gmail connection failing in this workflow?

Usually it’s expired Google OAuth credentials or a missing Gmail API permission in your Google Cloud project. Reconnect the Gmail credential in n8n, then confirm Gmail API is enabled and your consent screen is still valid. If it fails only sometimes, rate limits or inbox rules can be involved, especially when you receive many CVs at once.

What’s the capacity of this Gmail CV scoring solution?

It scales fine for most small teams, and the practical limit is usually your n8n plan and OpenAI usage, not the logic itself.

Is this Gmail CV scoring automation better than using Zapier or Make?

Often, yes, especially if you want structured parsing, branching logic, and the option to self-host. This workflow uses AI classification, file handling, and structured output parsing, which tends to get awkward (and pricey) in simpler automation tools once you add real screening rules. n8n also makes it easier to keep everything in one workflow: Gmail in, Drive storage, Sheets updates, then an email out. Zapier or Make can still be a good choice if you only need “email received → add row to sheet” and nothing more. Talk to an automation expert if you want a quick recommendation for your exact stack.

You end up with one sheet that tells the truth: who applied, where the CV is, and how strong the fit looks. The workflow handles the repetitive parts so your hiring decisions can get the attention.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "0f919d4361790979670fde6aa42270e226683c6a4cd9ab94af7073c9b4a8c6be",
"templateCredsSetupCompleted": null
},
"name": "Automated Resume Intake and Scoring",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-6207",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
40
],
"parameters": {
"color": 7,
"width": 1300,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "3575cc8d-18b8-436d-a026-b022814fbd3d",
"name": "Gmail CV Watcher",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
1220,
250
],
"parameters": {
"simple": false,
"filters": {
"q": "has:attachment",
"labelIds": [
"UNREAD"
],
"readStatus": "unread"
},
"options": {
"downloadAttachments": true
},
"pollTimes": {
"item": [
{
"mode": "everyHour",
"minute": 1
}
]
}
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "e1d682f8-9723-4dd6-ad45-e8959a273d32",
"name": "Categorize Email Intent",
"type": "@n8n/n8n-nodes-langchain.textClassifier",
"position": [
915,
195
],
"parameters": {
"options": {
"systemPromptTemplate": "Classify the user's text into one of the following categories: {categories}.\nFollow the formatting instructions provided below exactly.\nDo not include any explanation \u2014 output only the final JSON result."
},
"inputText": "={{ $json.text }}",
"categories": {
"categories": [
{
"category": "Doesn't apply",
"description": "The candidate is not a job application"
},
{
"category": "Apply",
"description": "This is a job application submitted by a candidate applying for a position at our organization, included as an attached file."
}
]
}
},
"typeVersion": 1
},
{
"id": "5f241a19-c30a-4cc4-a2c0-7e9d97711c78",
"name": "OpenAI Classifier Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
970,
140
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "848188ac-52fa-43b7-953f-b2cd45c727f1",
"name": "Ignore Non-Applications",
"type": "n8n-nodes-base.noOp",
"position": [
800,
155
],
"parameters": [],
"typeVersion": 1
},
{
"id": "c931b4a0-a1a4-4c59-85b8-9099064a74d0",
"name": "Route Attachment Presence",
"type": "n8n-nodes-base.switch",
"position": [
685,
240
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e9debd3b-3fa3-425a-bd61-6bf23a3a652b",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "attachment_0",
"rightValue": ""
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f0eabfca-ff5e-4e5d-9b4e-f3f80c7fa5b4",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "attachment_0",
"rightValue": ""
}
]
}
}
]
},
"options": {
"allMatchingOutputs": true
}
},
"typeVersion": 3.2
},
{
"id": "49107c53-eb76-4082-9d52-88d3fc391153",
"name": "Store Resume in Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
440,
190
],
"parameters": {
"name": "={{ $('Gmail CV Watcher').item.json.from.value[0].address }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive",
"cachedResultName": "My Drive"
},
"options": [],
"folderId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "CV - HR"
},
"inputDataFieldName": "=attachment_0"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 3
},
{
"id": "260dae6d-9234-4bab-bb79-d15b4923d801",
"name": "Append CV Link Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
265,
235
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $('Gmail CV Watcher').item.json.from.value[0].address }}",
"Link CV": "={{ $('Store Resume in Drive').item.json.webViewLink }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Resume text",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Resume text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Link CV",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Link CV",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"useAppend": true
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "fe0e8d5c-e3f6-4098-891b-0fb3594b71c8",
"name": "Extract PDF Resume Text",
"type": "n8n-nodes-base.extractFromFile",
"position": [
750,
400
],
"parameters": {
"options": [],
"operation": "pdf",
"binaryPropertyName": "attachment_0"
},
"typeVersion": 1
},
{
"id": "b5d472bf-4acf-4e86-aeb7-5d1604ded5ff",
"name": "Fetch Job Offer Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
515,
340
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "9b09d2ba-7669-4f64-8a77-ee5ff5280d72",
"name": "AI Resume Scoring Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
210,
385
],
"parameters": {
"text": "=Here is the resume:\n{{ $('Extract PDF Resume Text').item.json.text }}\n\nAnalyze the current information from the received candidate and score between 0 to 10 the said candidate, 0 meaning not a good fit for the position, 10 being outstanding for the job.\n\nJob Tile :  {{ $json['Title offer'] }}\nJob Description: {{ $json.Description }}\n\nReply by Email : \nSend a reply to the candidate to confirm that we have received their application and that we will get back to them as soon as possible.",
"options": {
"systemMessage": "=You are an invaluable assistant. You were given a resume. You have to help me analyze the resume and give it a score based on the details available in the resume. Also, extract the name, email, phone, location and LinkedIn profile from the resume.\n\nReply by Email : \nSend a reply to the candidate to confirm that we have received their application and that we will get back to them as soon as possible."
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.8
},
{
"id": "e9d2dfb0-0202-422c-a1f1-8d25a19bacc3",
"name": "Record Score in Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
30,
325
],
"parameters": {
"columns": {
"value": {
"Name": "={{ $json.output.name }}",
"Email": "={{ $('Gmail CV Watcher').item.json.from.value[0].address }}",
"Phone": "='{{ $json.output.Phone }}",
"Score": "={{ $json.output.score }}",
"LinkedIn": "={{ $json.output.linkedin }}",
"Location": "={{ $json.output.Location }}",
"Resume text": "={{ $('Extract PDF Resume Text').item.json.text }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LinkedIn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Score",
"type": "string",
"display": true,
"required": false,
"displayName": "Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Resume text",
"type": "string",
"display": true,
"required": false,
"displayName": "Resume text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Link CV",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Link CV",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"useAppend": true
},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "="
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "="
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "85edf215-bfa3-4b93-8f4f-7cede1132797",
"name": "OpenAI Scoring Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
280,
550
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "o4-mini",
"cachedResultName": "o4-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "90da624b-9653-444f-a36b-9bfe6df4922a",
"name": "Send Receipt Email",
"type": "n8n-nodes-base.gmailTool",
"position": [
455,
495
],
"webhookId": "b56651a5-a82e-4550-ae4e-ffea0304cd52",
"parameters": {
"sendTo": "={{ $('Gmail CV Watcher').item.json.from.value[0].address }}",
"message": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Message', ``, 'string') }}",
"options": [],
"subject": "Application Received"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "119808cc-82fb-43d2-931f-351f8e2e3267",
"name": "Parse Scoring Output",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
20,
540
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n\t\"type\": \"object\",\n\t\"properties\": {\n\t\t\"name\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n      \"email\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n      \"linkedin\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n      \"score\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n      \"Phone\": {\n\t\t\t\"type\": \"string\"\n\t\t},\n      \"Location\": {\n\t\t\t\"type\": \"string\"\n\t\t}\n\t\t\n\t}\n}"
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Route Attachment Presence": {
"main": [
[
{
"node": "Store Resume in Drive",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract PDF Resume Text",
"type": "main",
"index": 0
}
]
]
},
"Categorize Email Intent": {
"main": [
[
{
"node": "Ignore Non-Applications",
"type": "main",
"index": 0
}
],
[
{
"node": "Route Attachment Presence",
"type": "main",
"index": 0
}
]
]
},
"AI Resume Scoring Agent": {
"main": [
[
{
"node": "Record Score in Sheets",
"type": "main",
"index": 0
}
]
]
},
"Gmail CV Watcher": {
"main": [
[
{
"node": "Categorize Email Intent",
"type": "main",
"index": 0
}
]
]
},
"Send Receipt Email": {
"ai_tool": [
[
{
"node": "AI Resume Scoring Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Append CV Link Sheet": {
"main": [
[]
]
},
"Extract PDF Resume Text": {
"main": [
[
{
"node": "Fetch Job Offer Sheet",
"type": "main",
"index": 0
}
]
]
},
"Store Resume in Drive": {
"main": [
[
{
"node": "Append CV Link Sheet",
"type": "main",
"index": 0
}
]
]
},
"Parse Scoring Output": {
"ai_outputParser": [
[
{
"node": "AI Resume Scoring Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"OpenAI Scoring Model": {
"ai_languageModel": [
[
{
"node": "AI Resume Scoring Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Classifier Model": {
"ai_languageModel": [
[
{
"node": "Categorize Email Intent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Fetch Job Offer Sheet": {
"main": [
[
{
"node": "AI Resume Scoring Agent",
"type": "main",
"index": 0
}
]
]
}
}
}