{ "edges": [ { "to": "ac244e53-235e-425e-bae4-5e9d91aec305", "from": "9ebadf68-ba24-4889-9bcc-e74e39f3aab2", "toPort": "0", "fromPort": "0" }, { "to": "2207292d-6455-478d-bcdd-1314066738ea", "from": "e22db6e8-3dca-4f92-964d-307cfff24927", "toPort": "0", "fromPort": "0" }, { "to": "2d54c6ad-d960-4a5b-971d-853bdddbde47", "from": "2207292d-6455-478d-bcdd-1314066738ea", "toPort": "0", "fromPort": "0" }, { "to": "9ae3966c-09cb-4e5d-9a9a-94ed01b52229", "from": "ac244e53-235e-425e-bae4-5e9d91aec305", "toPort": "0", "fromPort": "0" }, { "to": "9ebadf68-ba24-4889-9bcc-e74e39f3aab2", "from": "c61ef3a2-4ef5-4a2b-a4a9-07c5db11a212", "toPort": "0", "fromPort": "0" }, { "to": "ccdb0c73-5757-45f2-84a6-8b22f743786a", "from": "2d54c6ad-d960-4a5b-971d-853bdddbde47", "toPort": "0", "fromPort": "0" }, { "to": "ccdb0c73-5757-45f2-84a6-8b22f743786a", "from": "a8050a45-eb9a-44b5-bbe8-24e1fe813f48", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "ccdb0c73-5757-45f2-84a6-8b22f743786a", "from": "d419a8e2-13ba-4505-9b51-07b7dc07bf2a", "toPort": "0", "fromPort": "ai_outputParser" }, { "to": "c61ef3a2-4ef5-4a2b-a4a9-07c5db11a212", "from": "ccdb0c73-5757-45f2-84a6-8b22f743786a", "toPort": "0", "fromPort": "0" }, { "to": "ccdb0c73-5757-45f2-84a6-8b22f743786a", "from": "9c82394a-aed4-4d09-949d-a66290915071", "toPort": "0", "fromPort": "ai_tool" } ], "nodes": [ { "id": "a8050a45-eb9a-44b5-bbe8-24e1fe813f48", "name": "Azure OpenAI Chat Model", "type": "llm", "params": { "model": "gpt-4o-mini", "options": {}, "provider": "openai" }, "position": [ 672, 128 ] }, { "id": "d419a8e2-13ba-4505-9b51-07b7dc07bf2a", "name": "Structured Output Parser", "type": "passthrough", "params": { "mode": "noOp", "jsonSchemaExample": "{\n\t\"Name\": \"Jyothi\",\n \"Location\": \"Hyderabad\",\n\t\"Language\": \"Telugu\",\n \"Gender\" : \"Male\",\n \"Disability\": \"No\",\n \"DEI\": \"Yes\",\n \"Factor\": \"Location\"\n}" }, "position": [ 928, 128 ] }, { "id": "9c82394a-aed4-4d09-949d-a66290915071", "name": "Get row(s) in sheet in Google Sheets", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1P8uforIuBJCkX0i9dl5BgUmzi4Nk63EHyFKLyeQvxT8/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1P8uforIuBJCkX0i9dl5BgUmzi4Nk63EHyFKLyeQvxT8", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1P8uforIuBJCkX0i9dl5BgUmzi4Nk63EHyFKLyeQvxT8/edit?usp=drivesdk", "cachedResultName": "HR Dei" } }, "position": [ 800, 128 ] }, { "id": "e22db6e8-3dca-4f92-964d-307cfff24927", "name": "CV Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.googleDriveTrigger", "event": "fileCreated", "options": {}, "pollTimes": { "item": [ { "mode": "everyMinute" } ] }, "triggerOn": "specificFolder", "folderToWatch": { "__rl": true, "mode": "list", "value": "1KyX5RGqeF7v0sAvvaoBnJPTQoq4aOHLz", "cachedResultUrl": "https://drive.google.com/drive/folders/1KyX5RGqeF7v0sAvvaoBnJPTQoq4aOHLz", "cachedResultName": "HR auto" } }, "position": [ 0, -96 ] }, { "id": "2207292d-6455-478d-bcdd-1314066738ea", "name": "Download CV", "type": "integration", "params": { "fileId": { "__rl": true, "mode": "url", "value": "={{ $json.webViewLink }}" }, "options": {}, "service": "googleDrive", "operation": "download" }, "position": [ 224, -96 ] }, { "id": "2d54c6ad-d960-4a5b-971d-853bdddbde47", "name": "Extract from PDF", "type": "passthrough", "params": { "mode": "noOp", "options": {}, "operation": "pdf" }, "position": [ 448, -96 ] }, { "id": "ccdb0c73-5757-45f2-84a6-8b22f743786a", "name": "Check for DEI Eligibility", "type": "llm", "params": { "text": "={{ $json.text }}", "prompt": "={{ $json.text }}", "options": { "systemMessage": "=You are an HR analytics assistant that processes candidate resumes and questionnaires and evaluates DEI hire eligibility using organization-defined balance rules. You must never infer protected attributes; only use self-reported data and Google Sheets records. Return strict, valid JSON exactly as specified. If data is missing or uncertain, use null and include conservative confidence scores.\n\nMandatory tooling\n • You MUST use the Google Sheets tool to read current representation of already hired employees before making any DEI eligibility decision.\nstate/country to location_bucket)\n\nObjectives\n • Extract structured proxies from the candidate: gender (self-reported only), location (city/state/country), language(s) (self-reported only), disability (self-reported only)\n• Determine DEI eligibility by comparing candidate’s categories against current workforce representation from the google sheet.\n\nOutput should be:\n- Name (self-reported)\n- gender (self-reported only)\n- location (city/state/country)\n- language (self-reported only)\n- disability (self-reported only)\n- DEI Eligible (Yes/No), If Yes in which factor.\n- Factor\n\nYOu will check the current employees and against this candidate and come to a conslucion whether or not this person is being underpresented in the firm in any factor " }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "=You are an HR analytics assistant that processes candidate resumes and questionnaires and evaluates DEI hire eligibility using organization-defined balance rules. You must never infer protected attributes; only use self-reported data and Google Sheets records. Return strict, valid JSON exactly as specified. If data is missing or uncertain, use null and include conservative confidence scores.\n\nMandatory tooling\n • You MUST use the Google Sheets tool to read current representation of already hired employees before making any DEI eligibility decision.\nstate/country to location_bucket)\n\nObjectives\n • Extract structured proxies from the candidate: gender (self-reported only), location (city/state/country), language(s) (self-reported only), disability (self-reported only)\n• Determine DEI eligibility by comparing candidate’s categories against current workforce representation from the google sheet.\n\nOutput should be:\n- Name (self-reported)\n- gender (self-reported only)\n- location (city/state/country)\n- language (self-reported only)\n- disability (self-reported only)\n- DEI Eligible (Yes/No), If Yes in which factor.\n- Factor\n\nYOu will check the current employees and against this candidate and come to a conslucion whether or not this person is being underpresented in the firm in any factor ", "hasOutputParser": true }, "position": [ 736, -96 ] }, { "id": "c61ef3a2-4ef5-4a2b-a4a9-07c5db11a212", "name": "Update on Sheet", "type": "integration", "params": { "columns": { "value": { "DEI": "={{ $json.output.DEI }}", "Name": "={{ $json.output.Name }}", "Factor": "={{ $json.output.Factor }}", "Gender": "={{ $json.output.Gender }}", "Language": "={{ $json.output.Language }}", "Location": "={{ $json.output.Location }}", "Disability": "={{ $json.output.Disability }}" }, "schema": [ { "id": "Name", "type": "string", "display": true, "required": false, "displayName": "Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Location", "type": "string", "display": true, "required": false, "displayName": "Location", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Gender", "type": "string", "display": true, "required": false, "displayName": "Gender", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Disability", "type": "string", "display": true, "required": false, "displayName": "Disability", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Language", "type": "string", "display": true, "required": false, "displayName": "Language", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "DEI", "type": "string", "display": true, "removed": false, "required": false, "displayName": "DEI", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Factor", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Factor", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1P8uforIuBJCkX0i9dl5BgUmzi4Nk63EHyFKLyeQvxT8/edit#gid=0", "cachedResultName": "Sheet1" }, "documentId": { "__rl": true, "mode": "list", "value": "1P8uforIuBJCkX0i9dl5BgUmzi4Nk63EHyFKLyeQvxT8", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1P8uforIuBJCkX0i9dl5BgUmzi4Nk63EHyFKLyeQvxT8/edit?usp=drivesdk", "cachedResultName": "HR Dei" } }, "position": [ 1136, -96 ] }, { "id": "9ebadf68-ba24-4889-9bcc-e74e39f3aab2", "name": "Logic", "type": "if", "params": { "options": {}, "conditions": { "options": { "version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "32ffb27d-1706-4aa8-b64c-9f661a38af22", "operator": { "name": "filter.operator.equals", "type": "string", "operation": "equals" }, "leftValue": "={{ $json.DEI }}", "rightValue": "Yes" } ] } }, "position": [ 1360, -96 ] }, { "id": "ac244e53-235e-425e-bae4-5e9d91aec305", "name": "Create Email", "type": "code", "params": { "jsCode": "// n8n Code node: build HTML email for DEI eligibility notification\n\n// Input data (replace with values from previous nodes or item fields)\nconst name = $json.Name || \"Candidate\";\nconst location = $json.Location || null;\nconst languages = $json.Language || null; // comma-delimited string\nconst gender = $json.Gender || null;\nconst disability = $json.Disability || null;\nconst deiEligible = ($json.DEI || \"No\").toLowerCase() === \"yes\";\nconst factor = $json.Factor || null;\n\n// Email metadata (adjust as needed or set in Gmail node)\nconst subject = `DEI Eligibility — ${name}`;\nconst preheader = `Candidate ${name} is ${deiEligible ? \"eligible\" : \"not eligible\"} for DEI hire${factor ? ` via ${factor}` : \"\"}.`;\n\n// Build a safe text summary\nconst textSummaryParts = [\n `Candidate: ${name}`,\n `DEI Eligibility: ${deiEligible ? \"Yes\" : \"No\"}`,\n];\nif (factor) textSummaryParts.push(`Factor: ${factor}`);\nif (location) textSummaryParts.push(`Location: ${location}`);\nif (languages) textSummaryParts.push(`Language(s): ${languages}`);\ntextSummaryParts.push(`Gender: ${gender ?? \"null\"}`);\ntextSummaryParts.push(`Disability: ${disability ?? \"null\"}`);\nconst textBody = textSummaryParts.join(\"\\n\");\n\n// Basic inline styles for email clients\nconst styles = {\n container: \"font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Arial, sans-serif; color:#111; background:#ffffff; margin:0; padding:0;\",\n wrapper: \"max-width:640px; margin:0 auto; padding:24px;\",\n card: \"border:1px solid #e5e7eb; border-radius:12px; padding:20px;\",\n h1: \"font-size:20px; margin:0 0 12px; color:#111;\",\n p: \"margin:0 0 12px; line-height:1.5; color:#374151;\",\n badgeYes: \"display:inline-block; background:#065f46; color:#ffffff; font-weight:600; font-size:12px; padding:6px 10px; border-radius:999px;\",\n badgeNo: \"display:inline-block; background:#7f1d1d; color:#ffffff; font-weight:600; font-size:12px; padding:6px 10px; border-radius:999px;\",\n table: \"width:100%; border-collapse:collapse; margin-top:12px;\",\n th: \"text-align:left; font-size:12px; color:#6b7280; padding:6px 0;\",\n td: \"font-size:14px; color:#111; padding:6px 0;\",\n footer: \"margin-top:16px; font-size:12px; color:#6b7280;\",\n divider: \"height:1px; background:#e5e7eb; border:none; margin:16px 0;\"\n};\n\n// Build HTML email\nconst html = `\n\n\n\n \n \n ${subject}\n \n \n \n \n\n\n

DEI Eligibility Review

\n Candidate ${name} has been evaluated for DEI eligibility.\n

\n Status:\n \n ${deiEligible ? \"DEI Eligible\" : \"Not DEI Eligible\"}\n \n

\n ${factor ? `

Primary eligibility factor: ${factor}.

` : \"\"}\n\n

\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n ${factor ? `\n \n \n \n ` : \"\"}\n \n

Name	${name}
Location	${location ?? \"—\"}
Language(s)	${languages ?? \"—\"}
Gender	${gender ?? \"null\"}
Disability	${disability ?? \"null\"}
DEI Eligible	${deiEligible ? \"Yes\" : \"No\"}
Factor	${factor}

\n\n

\n This notification is generated automatically from the latest evaluation records.\n

\n\n\n`;\n\n// Return for downstream Gmail node (use fields: subject, html, text)\nreturn [\n {\n json: {\n subject,\n html,\n text: textBody\n // Optionally include \"to\" and \"from\" here or set them in the Gmail node configuration.\n // to: \"user@example.com\",\n // from: \"user@example.com\"\n }\n }\n];\n" }, "position": [ 1584, -96 ] }, { "id": "9ae3966c-09cb-4e5d-9a9a-94ed01b52229", "name": "Email to Manager", "type": "integration", "params": { "sendTo": "user@example.com", "message": "={{ $json.html }}", "options": {}, "service": "gmail", "subject": "={{ $json.subject }}", "operation": "read" }, "position": [ 1808, -96 ] } ] }

Automate DEI eligibility screening with Azure GPT-4o, Google Drive and Sheets