January 22, 2026

Google Drive to Google Sheets, resumes logged clean

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You get a resume. You open a PDF. Then you copy the same details into a sheet again. Somewhere in that mess, a typo slips in, an email gets missed, and now you’ve got a “new candidate” who is actually a duplicate.

This is where Drive resume parsing hits hardest for recruiters doing high-volume screening. HR coordinators feel it too, especially when the spreadsheet becomes the “system” by default. And if you run an agency, you know the pain of keeping clients updated without living inside spreadsheets.

This workflow watches a Google Drive folder for new or updated resume PDFs, extracts the candidate data with AI, writes it cleanly into Google Sheets, and posts a Slack summary to the hiring team. You’ll see how it works, what you need, and where teams usually trip up.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Drive to Google Sheets, resumes logged clean

Click to explore

flowchart LR

    subgraph sg0["New profile uploaded to drive folder Flow"]
        direction LR
        n0@{ icon: "mdi:robot", form: "rounded", label: "json parser", pos: "b", h: 48 }
        n1@{ icon: "mdi:brain", form: "rounded", label: "gpt4-1 model", pos: "b", h: 48 }
        n2@{ icon: "mdi:robot", form: "rounded", label: "Profile Analyzer Agent", pos: "b", h: 48 }
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Transform output"]
        n4@{ icon: "mdi:play-circle", form: "rounded", label: "New profile uploaded to driv..", pos: "b", h: 48 }
        n5@{ icon: "mdi:cog", form: "rounded", label: "Get profile detail", pos: "b", h: 48 }
        n6@{ icon: "mdi:database", form: "rounded", label: "Append or update row in sheet", pos: "b", h: 48 }
        n7@{ icon: "mdi:play-circle", form: "rounded", label: "Existing profile updated", pos: "b", h: 48 }
        n8@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Verify profile email", pos: "b", h: 48 }
        n9@{ icon: "mdi:cog", form: "rounded", label: "Extract profile information", pos: "b", h: 48 }
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Let the hiring team know"]
        n0 -.-> n2
        n1 -.-> n2
        n3 --> n6
        n3 --> n10
        n5 --> n9
        n8 --> n3
        n2 --> n8
        n7 --> n5
        n9 --> n2
        n4 --> n5
    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 n4,n7 trigger
    class n0,n2 ai
    class n1 aiModel
    class n8 decision
    class n6 database
    class n3 code
    classDef customIcon fill:none,stroke:none
    class n3,n10 customIcon

The Problem: Resume data entry breaks hiring speed

Manually moving candidate details from PDFs into a spreadsheet feels “quick” until you do it 30 times in a week. Then it becomes this slow, draining loop: download the file, skim for email and phone, guess the right job title, paste skills into a cell, and hope formatting doesn’t explode. Worse, updates are invisible. A candidate sends a revised CV, you upload it to the same folder, and nobody notices. The sheet stays stale, which means screening decisions get made from outdated info.

The friction compounds. And it shows up in small ways that turn into big ones during a busy hiring sprint.

You spend about 10 minutes per resume just to capture basics like email, phone, role, and skills.
Duplicates creep in because “John Smith” is not a unique identifier, and people forget to check by email first.
Hiring managers get scattered updates in Slack, email threads, and DMs, so decisions slow down.
When the sheet is inconsistent, screening becomes subjective because everyone is reading different parts of the resume.

The Solution: Auto-parse Google Drive resumes into Sheets + Slack

This workflow turns your Google Drive folder into a clean intake pipeline. When a resume PDF is uploaded (or an existing file is updated), n8n downloads it and extracts the text content. That raw resume text goes to an AI agent powered by the OpenAI chat model, which pulls out the fields recruiters actually need: name, email, phone, location, experience highlights, education, skills, and more. Next, the workflow validates that the candidate has a usable email address (so you have a reliable unique key). Then it maps everything into the exact columns of your Google Sheet and upserts the row, which means new candidates get added and updated candidates overwrite the right record instead of creating duplicates. Finally, Slack gets a readable summary so the team can act right away.

The workflow starts with Google Drive triggers (new file and updated file). It processes the PDF into structured JSON using AI and a structured output parser, then cleans and maps the fields with a code step. At the end, it updates Google Sheets and posts a Slack message to keep everyone aligned.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

It monitors a specific Google Drive folder for new or updated resume PDFs.
It downloads each file and extracts readable text from the PDF automatically.
It uses AI to convert messy resume text into a structured candidate profile.
It upserts the record into Google Sheets and posts a summary to Slack.

If you process 30 resumes a week, you can save about 5 hours of copy-paste work.
Your sheet stays consistent because fields land in the same columns every time.
Duplicates drop sharply since email is used as the unique match key.
Hiring managers get faster updates in Slack, which helps them respond the same day.
It becomes easier to search and filter candidates because your “database” is finally clean.

Example: What This Looks Like

Say your team handles 10 resumes a day. Manually, even a “fast” process is about 10 minutes per resume (download, scan, copy, paste, format), which is roughly 100 minutes daily. With this workflow, you upload the PDF to the Drive folder and you’re done; the automation does the extraction, Sheet update, and Slack summary in the background. In practice, teams usually get back about 1–2 hours a day during active hiring weeks, plus fewer mistakes to clean up later.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Drive to store incoming resume PDFs
Google Sheets to act as the talent database
Slack to alert the hiring team with summaries
OpenAI API key (get it from the OpenAI dashboard)

Skill level: Intermediate. You’ll connect accounts, set folder and sheet IDs, and adjust field mappings to match your columns.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A resume lands in your Drive folder. The workflow triggers when a PDF is created or when an existing resume file is updated inside the folder you choose.

The PDF gets turned into usable text. n8n downloads the file and runs a PDF extraction step so the content can be processed reliably (even when formatting is ugly).

AI builds a structured candidate profile. The resume text is sent to an AI agent using the OpenAI chat model, then a structured output parser helps ensure the data comes back in a predictable JSON shape. That’s what makes the sheet mapping stable instead of brittle.

Your sheet updates and Slack gets the headline. After a quick validation that an email address exists, a mapping step aligns fields to your Google Sheet headers, upserts the row by email, and posts a clean summary message in Slack.

You can easily modify the fields captured (like LinkedIn, portfolio, or visa status) to match your hiring process. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Drive Upload Trigger

Set up the Google Drive triggers so the workflow starts when a resume is created or updated in a specific folder.

Select Drive Upload Trigger and set Event to fileCreated.
Set Trigger On to specificFolder and choose the folder in Folder to Watch (e.g., cv).
Credential Required: Connect your googleDriveOAuth2Api credentials in Drive Upload Trigger.
Select Drive Update Trigger and set Event to fileUpdated with the same Folder to Watch value.
Credential Required: Connect your googleDriveOAuth2Api credentials in Drive Update Trigger.

Tip: Use the same Drive folder in both triggers to capture new uploads and updates consistently.

Step 2: Connect Google Drive for File Download

Download the uploaded resume file so it can be parsed and analyzed.

Add or open Download Profile File and set Operation to download.
Set File ID to ={{ $json.webViewLink }}.
Credential Required: Connect your googleDriveOAuth2Api credentials in Download Profile File.

Step 3: Set Up PDF Parsing and AI Extraction

Parse the resume PDF and extract structured candidate data using the AI agent and output parser.

Configure Parse PDF Content with Operation set to pdf.
In Candidate Profile Agent, set Text to =Please extract all relevant information from this candiadte:\nCV Content:\n===\n{{ $json["text"] }}\n=== and enable output parsing.
Connect OpenAI Chat Model as the language model for Candidate Profile Agent and select Model gpt-4.1-mini.
Credential Required: Connect your openAiApi credentials in OpenAI Chat Model.
Attach Structured JSON Extractor as the output parser for Candidate Profile Agent and keep the provided JSON schema example intact.

⚠️ Common Pitfall: The Structured JSON Extractor is an AI sub-node. Add credentials to OpenAI Chat Model, not the parser itself.

Step 4: Validate and Map Candidate Fields

Filter out records missing an email and transform the AI output into a structured format for storage and notifications.

Configure Validate Email Presence with a string condition set to notEmpty and Left Value ={{ $json.output.contact.email }}.
In Map Candidate Fields, keep the current JavaScript mapping logic and ensure it references $('Download Profile File').first().json.webContentLink for ProfileUrl.

Step 5: Configure Output Destinations

Store candidate records in Google Sheets and notify your hiring Slack channel. These two actions run in parallel.

Open Upsert Sheet Record and set Operation to appendOrUpdate.
Select the Document ID [YOUR_ID] and Sheet Name gid=0 (Sheet1).
Set Matching Columns to Email so records update by email.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Upsert Sheet Record.
Configure Notify Hiring Slack with Text ={{ $json.FullName }} profile has been processed and recorded in Google Drive! and select a channel.
Credential Required: Connect your slackApi credentials in Notify Hiring Slack.

Map Candidate Fields outputs to both Upsert Sheet Record and Notify Hiring Slack in parallel.

Tip: Ensure your Google Sheet headers match the mapped fields (e.g., FullName, Email, Skills) for clean auto-mapping.

Step 6: Test and Activate Your Workflow

Run a manual test to confirm file parsing, AI extraction, and output actions work end-to-end.

Use Drive Upload Trigger to run a manual test by uploading a sample PDF into the watched folder.
Verify Parse PDF Content extracts text and Candidate Profile Agent outputs structured JSON.
Confirm a row is appended or updated in Upsert Sheet Record and a message appears in Notify Hiring Slack.
When satisfied, toggle the workflow to Active to run continuously.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Drive credentials can expire or need specific permissions. If things break, check the n8n credential connection test and the Drive folder access first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Drive resume parsing automation?

About 30 minutes if your folder, sheet, and credentials are ready.

Do I need coding skills to automate Drive resume parsing?

No. You’ll mostly connect accounts and paste in IDs for the Drive folder and Google Sheet. There is a mapping step, but it’s usually simple field-to-column matching.

Is n8n free to use for this Drive resume parsing 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 costs (often a few cents per resume, depending on length).

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.

Can I customize this Drive resume parsing workflow for different roles (like engineers vs. sales)?

Yes, and you should. Update the prompt used by the Candidate Profile Agent to prioritize what you care about (projects and stack for engineers, quota and deal size for sales). Common customizations include adding fields like LinkedIn/portfolio, splitting “skills” into categories, and changing the Slack message format so it matches your team’s screening rubric.

Why is my Google Drive connection failing in this workflow?

Most of the time it’s an expired OAuth connection or the Drive account simply doesn’t have access to the folder you selected. Reconnect the Google Drive credential in n8n, then confirm the trigger is pointed at the correct folder ID. If it still fails, check if the file is owned by another Google Workspace user and shared in a way that blocks automated download.

How many resumes can this Drive resume parsing automation handle?

A lot. On n8n Cloud, the practical limit depends on your monthly execution quota and how many files you process, and on self-hosting it mostly depends on your server and OpenAI throughput. For most small teams, processing a few hundred resumes a week is realistic as long as you’re not firing everything at once.

Is this Drive resume parsing automation better than using Zapier or Make?

Often, yes. This workflow isn’t just “move a file to a sheet”; it includes PDF text extraction, structured AI output, validation, and upserting by a unique key. n8n handles branching and custom logic without turning every extra step into a pricing surprise, and self-hosting is a real option if you need volume. Zapier or Make can still be fine for a very simple intake flow, especially if you never need custom mapping. If you’re unsure, Talk to an automation expert and describe your hiring volume and current tools.

Once this is running, your spreadsheet stops being a dumping ground and starts acting like a real recruiting database. The workflow handles the repetitive admin. You can focus on screening and conversations.

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": null,
"meta": {
"instanceId": "b4fdcca3ec34fc95758a3243823672ae2f2b1728ef45a23026283b052d076565",
"templateId": null,
"templateCredsSetupCompleted": null
},
"name": "Automated Resume Processing Pipeline",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-6835",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
70
],
"parameters": {
"color": 7,
"width": 1040,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "41adeefa-7ab5-47d9-babe-852d84a16f1a",
"name": "Structured JSON Extractor",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
230,
560
],
"parameters": {
"jsonSchemaExample": "{\n  \"full_name\": \"\",\n  \"job_title\": \"\",\n  \"summary\": \"\",\n  \"contact\": {\n    \"email\": \"\",\n    \"phone\": \"\",\n    \"address\": \"\",\n    \"linkedin\": \"\",\n    \"website\": \"\"\n  },\n  \"education\": [\n    {\n      \"degree\": \"\",\n      \"field_of_study\": \"\",\n      \"institution\": \"\",\n      \"location\": \"\",\n      \"start_year\": \"\",\n      \"end_year\": \"\"\n    }\n  ],\n  \"certifications\": [\n    {\n      \"name\": \"\",\n      \"issuer\": \"\",\n      \"date_obtained\": \"\",\n      \"expiration_date\": \"\"\n    }\n  ],\n  \"work_experience\": [\n    {\n      \"company\": \"\",\n      \"position\": \"\",\n      \"location\": \"\",\n      \"start_date\": \"\",\n      \"end_date\": \"\",\n      \"responsibilities\": [\n        \"\"\n      ],\n      \"achievements\": [\n        \"\"\n      ]\n    }\n  ],\n  \"skills\": {\n    \"technical_skills\": [\n      \"\"\n    ],\n    \"soft_skills\": [\n      \"\"\n    ],\n    \"languages\": [\n      {\n        \"language\": \"\",\n        \"proficiency\": \"\"\n      }\n    ],\n    \"tools_and_technologies\": [\n      \"\"\n    ]\n  },\n  \"projects\": [\n    {\n      \"name\": \"\",\n      \"description\": \"\",\n      \"technologies_used\": [\n        \"\"\n      ],\n      \"role\": \"\",\n      \"duration\": \"\"\n    }\n  ],\n  \"awards\": [\n    {\n      \"title\": \"\",\n      \"issuer\": \"\",\n      \"date\": \"\",\n      \"description\": \"\"\n    }\n  ],\n  \"volunteer_experience\": [\n    {\n      \"organization\": \"\",\n      \"role\": \"\",\n      \"description\": \"\",\n      \"start_date\": \"\",\n      \"end_date\": \"\"\n    }\n  ],\n  \"additional_information\": {\n    \"availability\": \"\",\n    \"preferred_location\": \"\",\n    \"salary_expectation\": \"\",\n    \"work_authorization\": \"\",\n    \"other_notes\": \"\"\n  }\n}"
},
"typeVersion": 1.3
},
{
"id": "c6f55faa-2836-40d9-a269-3eb858cfe2d0",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
430,
470
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "a77686bd-49d9-4723-bd5e-29900065ba3b",
"name": "Candidate Profile Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
400,
235
],
"parameters": {
"text": "=Please extract all relevant information from this candiadte:\nCV Content:\n===\n{{ $json[\"text\"] }}\n===",
"options": {
"systemMessage": ""
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.1
},
{
"id": "0129be50-4384-4e88-a583-4e2753607907",
"name": "Map Candidate Fields",
"type": "n8n-nodes-base.code",
"position": [
20,
240
],
"parameters": {
"jsCode": "const profile = $input.first().json.output\n\n// Get most recent job\nconst work = profile.work_experience || [];\nconst latest = work.length > 0 ? work[0] : {};\n\nfunction formatDate(dateStr) {\n  const date = new Date(dateStr);\n  return isNaN(date) ? dateStr : `${date.getFullYear()}-${(date.getMonth() + 1).toString().padStart(2, '0')}`;\n}\n\nfunction getExperienceYears(experiences) {\n  if (experiences.length === 0) return '';\n  const startDates = experiences.map(e => new Date(e.start_date)).filter(d => !isNaN(d));\n  const endDates = experiences.map(e => new Date(e.end_date === 'Present' ? new Date() : e.end_date)).filter(d => !isNaN(d));\n  if (startDates.length === 0 || endDates.length === 0) return '';\n  const start = new Date(Math.min(...startDates));\n  const end = new Date(Math.max(...endDates));\n  const diffYears = (end - start) / (1000 * 60 * 60 * 24 * 365);\n  return `${Math.floor(diffYears)} years`;\n}\n\nfunction formatEducation(edus) {\n  if (!edus || edus.length === 0) return '';\n  return edus.map(e => {\n    const start = new Date(e.start_year);\n    const end = new Date(e.end_year);\n    const startYear = isNaN(start) ? '' : start.getFullYear();\n    const endYear = isNaN(end) ? '' : end.getFullYear();\n    const duration = (startYear && endYear) ? `(${startYear}\u2013${endYear})` : '';\n    return `${e.degree} of ${e.field_of_study} at ${e.institution} ${duration}`;\n  }).join(' | ');\n}\n\nreturn [\n  {\n    json: {\n      FullName: profile.full_name,\n      JobTitle: profile.job_title,\n      Email: profile.contact.email.toLowerCase(),\n      Phone: profile.contact.phone,\n      Location: profile.contact.address,\n      LinkedIn: profile.contact.linkedin,\n      Education: formatEducation(profile.education),\n      Summary: profile.summary,\n      MostRecentCompany: latest.company || '',\n      MostRecentPosition: latest.position || '',\n      StartDate: formatDate(latest.start_date || ''),\n      EndDate: formatDate(latest.end_date || ''),\n      Skills: (profile.skills?.technical_skills || []).slice(0, 3).join(', '),\n      Experience: getExperienceYears(work), \n      ProfileUrl: $('Download Profile File').first().json.webContentLink\n    }\n  }\n];"
},
"typeVersion": 2
},
{
"id": "4d98e935-f7f6-4522-adac-8b594dddb5a3",
"name": "Drive Upload Trigger",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
940,
170
],
"parameters": {
"event": "fileCreated",
"options": [],
"pollTimes": {
"item": [
{
"mode": "everyX",
"unit": "minutes",
"value": 5
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://drive.google.com/drive/folders/[YOUR_ID]",
"cachedResultName": "cv"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "0279bccd-e14d-471d-9206-705472035c71",
"name": "Download Profile File",
"type": "n8n-nodes-base.googleDrive",
"position": [
760,
265
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "url",
"value": "={{ $json.webViewLink }}"
},
"options": [],
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 3
},
{
"id": "ca964937-f0bd-41b7-96b4-c71640fdb5ee",
"name": "Upsert Sheet Record",
"type": "n8n-nodes-base.googleSheets",
"position": [
40,
430
],
"parameters": {
"columns": {
"value": [],
"schema": [
{
"id": "FullName",
"type": "string",
"display": true,
"required": false,
"displayName": "FullName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JobTitle",
"type": "string",
"display": true,
"required": false,
"displayName": "JobTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn",
"type": "string",
"display": true,
"required": false,
"displayName": "LinkedIn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education",
"type": "string",
"display": true,
"required": false,
"displayName": "Education",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MostRecentCompany",
"type": "string",
"display": true,
"required": false,
"displayName": "MostRecentCompany",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MostRecentPosition",
"type": "string",
"display": true,
"required": false,
"displayName": "MostRecentPosition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "StartDate",
"type": "string",
"display": true,
"required": false,
"displayName": "StartDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EndDate",
"type": "string",
"display": true,
"required": false,
"displayName": "EndDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skills",
"type": "string",
"display": true,
"required": false,
"displayName": "Skills",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Experience",
"type": "string",
"display": true,
"required": false,
"displayName": "Experience",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ProfileUrl",
"type": "string",
"display": true,
"required": false,
"displayName": "ProfileUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit?usp=drivesdk",
"cachedResultName": "Processed Candidates"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "fd549ec2-36cb-4948-bbea-d58e40b6a304",
"name": "Drive Update Trigger",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
960,
360
],
"parameters": {
"event": "fileUpdated",
"options": [],
"pollTimes": {
"item": [
{
"mode": "everyX",
"unit": "minutes",
"value": 5
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://drive.google.com/drive/folders/[YOUR_ID]",
"cachedResultName": "cv"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "09fd43b0-55a9-427b-a874-736aef1f1439",
"name": "Validate Email Presence",
"type": "n8n-nodes-base.filter",
"position": [
210,
245
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d03f5a71-8e0c-4196-a6e1-5d5ec7a86894",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.output.contact.email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "7757bff2-7cac-4868-aa82-6171352e357a",
"name": "Parse PDF Content",
"type": "n8n-nodes-base.extractFromFile",
"position": [
580,
250
],
"parameters": {
"options": [],
"operation": "pdf"
},
"typeVersion": 1
},
{
"id": "d96f6dbe-608b-479a-b5f5-015813207844",
"name": "Notify Hiring Slack",
"type": "n8n-nodes-base.slack",
"position": [
260,
430
],
"webhookId": "3e16b79d-e39e-461f-8718-510eab00b7ea",
"parameters": {
"text": "={{ $json.FullName }} profile has been processed and recorded in Google Drive!",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "all-automatewithme"
},
"otherOptions": []
},
"credentials": {
"slackApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.3
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Structured JSON Extractor": {
"ai_outputParser": [
[
{
"node": "Candidate Profile Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Candidate Profile Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Map Candidate Fields": {
"main": [
[
{
"node": "Upsert Sheet Record",
"type": "main",
"index": 0
},
{
"node": "Notify Hiring Slack",
"type": "main",
"index": 0
}
]
]
},
"Download Profile File": {
"main": [
[
{
"node": "Parse PDF Content",
"type": "main",
"index": 0
}
]
]
},
"Validate Email Presence": {
"main": [
[
{
"node": "Map Candidate Fields",
"type": "main",
"index": 0
}
]
]
},
"Candidate Profile Agent": {
"main": [
[
{
"node": "Validate Email Presence",
"type": "main",
"index": 0
}
]
]
},
"Drive Update Trigger": {
"main": [
[
{
"node": "Download Profile File",
"type": "main",
"index": 0
}
]
]
},
"Parse PDF Content": {
"main": [
[
{
"node": "Candidate Profile Agent",
"type": "main",
"index": 0
}
]
]
},
"Drive Upload Trigger": {
"main": [
[
{
"node": "Download Profile File",
"type": "main",
"index": 0
}
]
]
}
}
}