Rahul Shah This workflow corresponds to n8n.io template #18177 — we link there as the canonical source.
This workflow follows the Agent → Airtable recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "8ggrc1xR60NoLT4X",
"name": "HR Job Posting and Evaluation with AI",
"tags": [],
"nodes": [
{
"id": "cfc70fc7-5f28-419b-a488-ce364c0d09e6",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"width": 480,
"height": 896,
"content": "## HR Job Posting and Evaluation with AI\n\n### How it works\n\nThis workflow automates an HR candidate intake and evaluation process from form submission through interview preparation. It uploads and records applicant details, extracts CV content, uses AI to assess fit, then routes candidates into rejected or potential hire records. For shortlisted candidates, it generates questionnaires, sends a personalized email, books a phone meeting, and stores tailored screening questions.\n\n### Setup steps\n\n- Configure the form trigger fields for applicant name, phone, email, experience, and CV upload.\n- Connect Google Drive credentials and set the target folder for CV upload/download.\n- Configure Airtable credentials, bases, and tables for applicant records, job postings, candidate insights, questionnaire updates, meeting times, rejection records, and screening questions.\n- Connect OpenAI credentials for the AI Agent and OpenAI nodes, and review prompts/output schemas for candidate scoring, questionnaire generation, email personalization, booking, and screening questions.\n- Set up email sending credentials and verify the sender, subject, and recipient field mappings.\n- Connect Google Calendar credentials for the meeting-booking tool and choose the calendar/availability rules to use.\n\n### Customization\n\nAdjust the AI evaluation criteria, shortlist threshold, Airtable field mappings, generated questionnaire format, email tone, meeting duration, and screening-question templates to match the hiring process."
},
"typeVersion": 1
},
{
"id": "e6e718af-6a8b-433b-a8c2-aeae01b37671",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
560,
160
],
"parameters": {
"color": 7,
"width": 832,
"height": 304,
"content": "## Collect applicant intake\n\nStarts when an applicant submits the form, uploads the CV to Google Drive, formats key applicant fields, and creates or updates the initial Airtable record."
},
"typeVersion": 1
},
{
"id": "5c9efe8c-50ab-4536-87dd-e6052a2ee70c",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1440,
128
],
"parameters": {
"color": 7,
"width": 416,
"height": 320,
"content": "## Extract CV content\n\nDownloads the stored CV from Google Drive and extracts readable text so it can be analyzed by AI."
},
"typeVersion": 1
},
{
"id": "3e66c529-515c-426d-878b-0ff792dd6c5b",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1888,
128
],
"parameters": {
"color": 7,
"width": 656,
"height": 496,
"content": "## Evaluate candidate fit\n\nUses the AI Agent with OpenAI, Airtable lookup access, and a structured output parser to evaluate the CV and decide whether the applicant should be shortlisted."
},
"typeVersion": 1
},
{
"id": "c6b020d3-0133-4163-86a3-8abc17f0ae7b",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2576,
0
],
"parameters": {
"color": 7,
"height": 592,
"content": "## Record hiring decision\n\nWrites the branch outcome to Airtable, saving rejected candidates separately from potential hires who continue through the process."
},
"typeVersion": 1
},
{
"id": "61b85e1b-c70a-47ff-9f4e-d9ce8b541e39",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2848,
64
],
"parameters": {
"color": 7,
"width": 768,
"height": 544,
"content": "## Generate candidate questionnaire\n\nFor potential hires, generates tailored questionnaire content with AI using Airtable context, presents it in a form, and updates Airtable with the completed questionnaire data."
},
"typeVersion": 1
},
{
"id": "16ee12c8-916b-40c6-bfc4-f09335f6661c",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3648,
96
],
"parameters": {
"color": 7,
"width": 768,
"height": 528,
"content": "## Prepare and send email\n\nCreates a personalized candidate email using job posting and candidate insight data, maps the generated content into email fields, and sends the message."
},
"typeVersion": 1
},
{
"id": "8ed335e8-522c-4bf7-b5b4-70e2580cc2c7",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
4448,
96
],
"parameters": {
"color": 7,
"width": 576,
"height": 496,
"content": "## Schedule phone meeting\n\nUses AI with Google Calendar access to book a phone screening meeting, then saves the scheduled meeting time back to Airtable."
},
"typeVersion": 1
},
{
"id": "d46b0cd6-67c5-4d91-b6b1-dc4a5350ef8f",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
5056,
96
],
"parameters": {
"color": 7,
"width": 768,
"height": 496,
"content": "## Create screening questions\n\nGenerates tailored phone-screening questions from job posting and candidate insight data, formats the output field, and stores the questions in Airtable."
},
"typeVersion": 1
},
{
"id": "edf1a6e4-20c7-450c-bfbb-58306bc1e40e",
"name": "When Form Submitted",
"type": "n8n-nodes-base.formTrigger",
"position": [
624,
288
],
"parameters": {
"options": {
"path": "automation-specialist-application",
"ignoreBots": false,
"buttonLabel": "Submit",
"appendAttribution": false,
"useWorkflowTimezone": true
},
"formTitle": "Job Application",
"formFields": {
"values": [
{
"fieldLabel": "First Name",
"requiredField": true
},
{
"fieldLabel": "Last Name",
"requiredField": true
},
{
"fieldType": "email",
"fieldLabel": "Email",
"requiredField": true
},
{
"fieldType": "number",
"fieldLabel": "Phone",
"requiredField": true
},
{
"fieldType": "number",
"fieldLabel": "Years of experience",
"requiredField": true
},
{
"fieldType": "file",
"fieldLabel": "Upload your CV",
"requiredField": true,
"acceptFileTypes": ".pdf"
}
]
},
"formDescription": "=Fill this for to apply for the role Automation Specialist:\n\nLocation: Remote\nExperience: Minimum 3 years\nEmployment Type: Full-time\n\nJob Description:\nWe are seeking a highly skilled Automation Specialist with at least 3 years of experience in designing and implementing workflow automation solutions. The ideal candidate will have expertise in tools such as n8n, Zapier, Make.com, or similar platforms, and a strong background in integrating APIs, streamlining processes, and enhancing operational efficiency.\n\nKey Responsibilities:\n\n Develop and implement automated workflows to optimize business processes.\n Integrate third-party APIs and systems to create seamless data flow.\n Analyze, debug, and improve existing automation setups.\n Collaborate with cross-functional teams to identify automation opportunities.\n Monitor and maintain automation systems to ensure reliability.\n\nRequired Skills & Qualifications:\n\n Proven 3+ years of experience in workflow automation and integration.\n Proficiency with tools like n8n, Zapier, or Make.com.\n Strong understanding of APIs, webhooks, and data transformation.\n Familiarity with scripting languages (e.g., JavaScript or Python).\n Excellent problem-solving and communication skills.\n\nPreferred Qualifications:\n\n Experience with database management and cloud services.\n Background in business process analysis or RPA tools.\n\nWhy Join Us?\n\n Opportunity to work on cutting-edge automation projects.\n Supportive and collaborative team environment.\n Competitive salary and benefits package."
},
"typeVersion": 2.2
},
{
"id": "299a6925-c101-4e38-aca9-b0fba9a0ca29",
"name": "Store in Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
1264,
288
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appublMkWVQfHkZ09",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09",
"cachedResultName": "Simple applicant tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblllvQaRTSnEr17a",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09/tblllvQaRTSnEr17a",
"cachedResultName": "Applicants"
},
"columns": {
"value": {
"Name": "={{ $json.Name }}",
"Phone": "={{ $json.Phone }}",
"CV Link": "={{ $json[\"CV link\"] }}",
"Applying for": "=[\"Automation Specialist\"]",
"Email address": "={{ $json.email }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email address",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Stage",
"type": "options",
"display": true,
"options": [
{
"name": "No hire",
"value": "No hire"
},
{
"name": "Interviewing",
"value": "Interviewing"
},
{
"name": "Decision needed",
"value": "Decision needed"
},
{
"name": "Hire",
"value": "Hire"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Applying for",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Applying for",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CV Link",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "CV Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JD CV score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "JD CV score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interviewer",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interviewer",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Attachments",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Attachments",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": []
},
"options": {
"typecast": true
},
"operation": "create"
},
"typeVersion": 2.1
},
{
"id": "ce56d22a-5765-4ef6-99f9-7849efd76992",
"name": "Upload CV to Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
832,
288
],
"parameters": {
"name": "={{ $binary.Upload_your_CV.fileName }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "1u_YBpqSU5TjNsu72sQKFMIesb62JKHXz",
"cachedResultUrl": "https://drive.google.com/drive/folders/1u_YBpqSU5TjNsu72sQKFMIesb62JKHXz",
"cachedResultName": "HR Test"
},
"inputDataFieldName": "Upload_your_CV"
},
"typeVersion": 3
},
{
"id": "727adae6-2cb9-479c-a395-0138638346b5",
"name": "Set Applicant Details",
"type": "n8n-nodes-base.set",
"position": [
1056,
288
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bffff778-859a-4bb8-b973-39237ce7486e",
"name": "Name",
"type": "string",
"value": "={{ $('When Form Submitted').item.json['First Name'] + \" \" + $('When Form Submitted').item.json['Last Name'] }}"
},
{
"id": "cd6e7372-c65f-4e6f-9612-6ea513bb8e15",
"name": "Phone",
"type": "number",
"value": "={{ $('When Form Submitted').item.json.Phone }}"
},
{
"id": "eb19138e-7ff3-4f0c-ad95-ac33f8835717",
"name": "email",
"type": "string",
"value": "={{ $('When Form Submitted').item.json.Email }}"
},
{
"id": "25172db9-91fb-45da-b036-ee9aea1e8b09",
"name": "Experience",
"type": "number",
"value": "={{ $('When Form Submitted').item.json[\"Years of experience\"] }}"
},
{
"id": "64393285-3770-47e0-bbbb-3c5d5e14f1f4",
"name": "Applied On",
"type": "string",
"value": "={{ $('When Form Submitted').item.json.submittedAt }}"
},
{
"id": "dc052fd6-f57d-4da1-9976-67fcd9496e58",
"name": "CV link",
"type": "string",
"value": "={{ $json.webViewLink }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ea90c237-9b31-4b94-82ff-271ead769484",
"name": "Download CV from Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
1488,
288
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "url",
"value": "={{ $json.fields[\"CV Link\"] }}"
},
"options": {},
"operation": "download"
},
"typeVersion": 3
},
{
"id": "4c4113d8-02d1-4106-b56c-65082ea82557",
"name": "Extract CV Data",
"type": "n8n-nodes-base.extractFromFile",
"position": [
1712,
288
],
"parameters": {
"options": {},
"operation": "pdf"
},
"typeVersion": 1
},
{
"id": "460622ab-46c0-4f0c-9cdb-a653e93da4be",
"name": "AI Evaluation Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2016,
288
],
"parameters": {
"text": "=Compare the following job description and resume. Assign a qualification score between 0 and 1, where 1 indicates the best match. Provide only the score and the reason for the score in less than 20 words.\nJob Description: Use Airtable tool to get the job description\nResume: \n{{ $json.text }}",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "d9e72d58-932e-4fe5-b20f-ceaff6e9f8db",
"name": "OpenAI GPT-4 Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2064,
496
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "0166de54-9a3b-4d11-8391-653de3c7d278",
"name": "Fetch Airtable Data",
"type": "n8n-nodes-base.airtableTool",
"position": [
2272,
496
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appublMkWVQfHkZ09",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09",
"cachedResultName": "Simple applicant tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbljhmLdPULqSya0d",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09/tbljhmLdPULqSya0d",
"cachedResultName": "Positions"
},
"options": {},
"operation": "search"
},
"typeVersion": 2.1
},
{
"id": "b4e45d0d-8b1a-4828-9f34-98a07aecc889",
"name": "Parse Structured Output",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2384,
496
],
"parameters": {
"jsonSchemaExample": "{\n \"score\": 0.8,\n \"reason\": \"Does not meet required number of experience in years\"\n}"
},
"typeVersion": 1.2
},
{
"id": "9620be2d-e62f-49db-abda-465d5a3d7aa2",
"name": "If Shortlisted",
"type": "n8n-nodes-base.if",
"position": [
2400,
288
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7b4950b2-d218-4911-89cd-22a60b7465d8",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.output.score }}",
"rightValue": 0.7
}
]
}
},
"typeVersion": 2.2
},
{
"id": "89b5fed6-f213-427b-994f-9a851162cb3f",
"name": "Log Rejected Candidate",
"type": "n8n-nodes-base.airtable",
"position": [
2624,
432
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appublMkWVQfHkZ09",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09",
"cachedResultName": "Simple applicant tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblllvQaRTSnEr17a",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09/tblllvQaRTSnEr17a",
"cachedResultName": "Applicants"
},
"columns": {
"value": {
"id": "={{ $('Store in Airtable').item.json.id }}",
"Stage": "No hire",
"JD CV score": "={{ $json.output.score }}",
"CV Score Notes": "={{ $json.output.reason }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email address",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Stage",
"type": "options",
"display": true,
"options": [
{
"name": "No hire",
"value": "No hire"
},
{
"name": "Interviewing",
"value": "Interviewing"
},
{
"name": "Decision needed",
"value": "Decision needed"
},
{
"name": "Hire",
"value": "Hire"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Applying for",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Applying for",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CV Link",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "CV Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JD CV score",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "JD CV score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CV Score Notes",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "CV Score Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interviewer",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interviewer",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Attachments",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Attachments",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
]
},
"options": {},
"operation": "update"
},
"typeVersion": 2.1
},
{
"id": "a0db95d4-d22d-4ba9-9cf0-5029faaed3c9",
"name": "Log Potential Hire",
"type": "n8n-nodes-base.airtable",
"position": [
2624,
224
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appublMkWVQfHkZ09",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09",
"cachedResultName": "Simple applicant tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblllvQaRTSnEr17a",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09/tblllvQaRTSnEr17a",
"cachedResultName": "Applicants"
},
"columns": {
"value": {
"id": "={{ $('Store in Airtable').item.json.id }}",
"Stage": "Interviewing",
"JD CV score": "={{ $json.output.score }}",
"CV Score Notes": "={{ $json.output.reason }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email address",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Stage",
"type": "options",
"display": true,
"options": [
{
"name": "No hire",
"value": "No hire"
},
{
"name": "Interviewing",
"value": "Interviewing"
},
{
"name": "Decision needed",
"value": "Decision needed"
},
{
"name": "Hire",
"value": "Hire"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Applying for",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Applying for",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CV Link",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "CV Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JD CV score",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "JD CV score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CV Score Notes",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "CV Score Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interviewer",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interviewer",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Attachments",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Attachments",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
]
},
"options": {},
"operation": "update"
},
"typeVersion": 2.1
},
{
"id": "821ee844-15c9-485c-ab6f-08ec89dc914f",
"name": "Additional Airtable Data",
"type": "n8n-nodes-base.airtableTool",
"position": [
3136,
464
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appublMkWVQfHkZ09",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09",
"cachedResultName": "Simple applicant tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbljhmLdPULqSya0d",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09/tbljhmLdPULqSya0d",
"cachedResultName": "Positions"
},
"options": {},
"operation": "search"
},
"typeVersion": 2.1
},
{
"id": "2ac7ee88-9748-4291-95a0-e1795c1ad2e1",
"name": "Generate Questionnaires",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
2896,
224
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "GPT-4O-MINI"
},
"options": {},
"messages": {
"values": [
{
"content": "=Given the following job description and candidate CV, create 5 insightful interview questions to gather more information about the candidate's suitability for the role. The questions should focus on:\n\n Specific projects the candidate has worked on.\n Key responsibilities and achievements in their previous roles.\n Skills relevant to the job description.\n Problem-solving abilities and how they handled challenges.\n Alignment with the company\u2019s goals and values.\n\nProvide the questions in a clear, concise format.\n\nJob Description:\nUse the airtable tool to get the job description\n\nCandidate CV:\n{{ $('Extract CV Data').item.json.text }}"
}
]
},
"jsonOutput": true
},
"typeVersion": 1.7
},
{
"id": "aa3b2511-740b-4dd7-bc24-79ac8d38e96a",
"name": "Prepare Questionnaires Form",
"type": "n8n-nodes-base.form",
"position": [
3264,
224
],
"parameters": {
"options": {
"formTitle": "Questionnaires",
"buttonLabel": "Submit",
"formDescription": "Kindly fill in the following questions to proceed."
},
"formFields": {
"values": [
{
"fieldLabel": "={{ $json.message.content.interview_questions[0].question }}",
"requiredField": true
},
{
"fieldLabel": "={{ $json.message.content.interview_questions[1].question }}",
"requiredField": true
},
{
"fieldLabel": "={{ $json.message.content.interview_questions[2].question }}",
"requiredField": true
},
{
"fieldLabel": "={{ $json.message.content.interview_questions[3].question }}",
"requiredField": true
},
{
"fieldLabel": "={{ $json.message.content.interview_questions[4].question }}",
"requiredField": true
}
]
}
},
"typeVersion": 1
},
{
"id": "b7f665e1-d7f0-4271-ab09-f67880a7d57c",
"name": "Update Airtable with Questionnaires",
"type": "n8n-nodes-base.airtable",
"position": [
3488,
224
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appublMkWVQfHkZ09",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09",
"cachedResultName": "Simple applicant tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblllvQaRTSnEr17a",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09/tblllvQaRTSnEr17a",
"cachedResultName": "Applicants"
},
"columns": {
"value": {
"id": "={{ $('Store in Airtable').item.json.id }}",
"Questonnaires and responses": "={{ $('Generate Questionnaires').item.json.message.content.interview_questions[0].question }}: {{ $json['Can you describe one of the most complex automation projects you worked on, particularly detailing your role and the technologies you used?'] }}\n\n\n{{ $('Generate Questionnaires').item.json.message.content.interview_questions[1].question }}: {{ $json['What specific achievements in your previous roles do you believe demonstrate your ability to meet the responsibilities listed in the Automation Specialist position?'] }}\n\n\n{{ $('Generate Questionnaires').item.json.message.content.interview_questions[2].question }}: {{ $json['Given your experience with automation tools like n8n and APIs, can you provide an example of how you\\'ve successfully integrated different systems to improve operational efficiency?'] }}\n\n\n{{ $('Generate Questionnaires').item.json.message.content.interview_questions[3].question }}: {{ $json['Describe a challenging situation you faced during a project, how you approached the problem, and what the outcome was.'] }}\n\n\n{{ $('Generate Questionnaires').item.json.message.content.interview_questions[4].question }}: {{ $json['How do your values and career goals align with our company\\'s mission to optimize and enhance automation solutions?'] }}\n\n"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email address",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Stage",
"type": "options",
"display": true,
"options": [
{
"name": "No hire",
"value": "No hire"
},
{
"name": "Interviewing",
"value": "Interviewing"
},
{
"name": "Decision needed",
"value": "Decision needed"
},
{
"name": "Hire",
"value": "Hire"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Applying for",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Applying for",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CV Link",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "CV Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JD CV score",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "JD CV score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CV Score Notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "CV Score Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Questonnaires and responses",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Questonnaires and responses",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interviewer",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone interview notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Phone interview notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interviewer",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interviewer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview score",
"type": "options",
"display": true,
"options": [
{
"name": "0 \u2013 No hire",
"value": "0 \u2013 No hire"
},
{
"name": "1 \u2013 Probably no hire",
"value": "1 \u2013 Probably no hire"
},
{
"name": "2 \u2013 Worth consideration",
"value": "2 \u2013 Worth consideration"
},
{
"name": "3 \u2013 Good candidate",
"value": "3 \u2013 Good candidate"
},
{
"name": "4 \u2013 Please hire this person",
"value": "4 \u2013 Please hire this person"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Onsite interview notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Onsite interview notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Attachments",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Attachments",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
]
},
"options": {},
"operation": "update"
},
"typeVersion": 2.1
},
{
"id": "65542288-280f-462c-88c4-a550e511cf5a",
"name": "Access Job Posting Data",
"type": "n8n-nodes-base.airtableTool",
"position": [
3872,
464
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appublMkWVQfHkZ09",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09",
"cachedResultName": "Simple applicant tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbljhmLdPULqSya0d",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09/tbljhmLdPULqSya0d",
"cachedResultName": "Positions"
},
"options": {},
"operation": "search"
},
"typeVersion": 2.1
},
{
"id": "00a9ec90-3712-475c-8074-c88eb28e9d82",
"name": "Fetch Candidate Insights",
"type": "n8n-nodes-base.airtableTool",
"position": [
3984,
464
],
"parameters": {
"id": "={{ $('Update Airtable with Questionnaires').item.json.id }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appublMkWVQfHkZ09",
"cachedResultUrl": "https://airtable.com/appublMkWVQfHkZ09",
"cachedResultName": "Simple applicant tracker"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblllvQaRTSnEr17a",
"cachedResultUrl": "https://air
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow collects job applications via an n8n form, stores applicant details and CVs in Google Drive and Airtable, uses OpenAI to score CV fit, branches candidates into rejected or interviewing stages, then generates followup questionnaires, emails shortlisted candidates,…
Source: https://n8n.io/workflows/18177/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
🎯 Create viral TikToks, Shorts, Reels, podcasts, and ASMR videos in minutes — all on autopilot.
OpenAI, HTTP Request, Form Trigger +7
Unlock the Power of Language with Personalized AI Learning! MOTION TUTOR is a revolutionary AI-powered language learning platform that adapts to your progress and guides you from basic vocabulary to c
Agent, Airtable Tool, OpenAI Chat +6
22-Automate_Multi_Platform_Social_Media_Content_Creation. Uses outputParserStructured, lmChatGoogleGemini, lmChatOpenAi, httpRequest. Event-driven trigger; 57 nodes.
Output Parser Structured, Google Gemini Chat, OpenAI Chat +11
Template Carnaval - time instagram. Uses toolWorkflow, lmChatOpenAi, memoryBufferWindow, agent. Event-driven trigger; 56 nodes.
Tool Workflow, OpenAI Chat, Memory Buffer Window +10
📄 Documentation: Notion Guide
Telegram Trigger, HTTP Request, Agent +8