{ "edges": [ { "to": "4648ef51-49af-40f8-9c82-490c5965e5be", "from": "75fe46c9-d9eb-455e-8f9d-7384c4a1d172", "toPort": "0", "fromPort": "0" }, { "to": "5943f68f-a39f-4532-a437-732d98d53079", "from": "3937cc5c-ea58-4b5d-b22d-591f8097481f", "toPort": "0", "fromPort": "0" }, { "to": "2a8e9656-df75-439f-ac16-ba608b29c87d", "from": "4648ef51-49af-40f8-9c82-490c5965e5be", "toPort": "0", "fromPort": "0" }, { "to": "f479ae8a-490b-4b08-9fe3-dbe6a26b2320", "from": "4648ef51-49af-40f8-9c82-490c5965e5be", "toPort": "0", "fromPort": "0" }, { "to": "2a8e9656-df75-439f-ac16-ba608b29c87d", "from": "ba41cb19-9463-4c8a-a94d-a7d579346b1e", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "3937cc5c-ea58-4b5d-b22d-591f8097481f", "from": "2a8e9656-df75-439f-ac16-ba608b29c87d", "toPort": "0", "fromPort": "0" }, { "to": "9509d5c2-f66f-4294-9432-0b2587283b7a", "from": "5943f68f-a39f-4532-a437-732d98d53079", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "75fe46c9-d9eb-455e-8f9d-7384c4a1d172", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "triggerAtHour": 6 } ] } }, "position": [ -340, -80 ] }, { "id": "ba41cb19-9463-4c8a-a94d-a7d579346b1e", "name": "Google Gemini Chat Model", "type": "llm", "params": { "options": {}, "provider": "google", "modelName": "models/gemini-1.5-flash" }, "position": [ 120, 120 ] }, { "id": "4648ef51-49af-40f8-9c82-490c5965e5be", "name": "fetch_applicant_emails", "type": "integration", "params": { "filters": { "q": "label: applicant newer_than:1d is:unread" }, "service": "gmail", "operation": "getAll" }, "position": [ -120, -80 ] }, { "id": "f479ae8a-490b-4b08-9fe3-dbe6a26b2320", "name": "readAll_applicant_emails", "type": "integration", "params": { "service": "gmail", "messageId": "={{ $json.id }}", "operation": "markAsRead" }, "position": [ 120, -280 ] }, { "id": "2a8e9656-df75-439f-ac16-ba608b29c87d", "name": "Extract Applicant Details", "type": "llm", "params": { "text": "=You are an assistant that extracts job applicant information from emails.\n\nExtract the following fields and return ONLY valid JSON with these keys:\n- name\n- email\n- phone\n- role\n- years_of_experience\n- top_skills\n- location\n- notice_period\n- summary\n\nApplicant email:\n\"\"\"\n{{$json.snippet }}\n\"\"\"\n", "prompt": "=You are an assistant that extracts job applicant information from emails.\n\nExtract the following fields and return ONLY valid JSON with these keys:\n- name\n- email\n- phone\n- role\n- years_of_experience\n- top_skills\n- location\n- notice_period\n- summary\n\nApplicant email:\n\"\"\"\n{{$json.snippet }}\n\"\"\"\n", "batching": {}, "provider": "openai", "promptType": "define", "approximated": true }, "position": [ 100, -80 ] }, { "id": "3937cc5c-ea58-4b5d-b22d-591f8097481f", "name": "Assign Manager Emails", "type": "code", "params": { "jsCode": "function stripMarkdownJson(input) {\n let str = (input || '').trim();\n\n // Remove the ```json at the start and ```\n // This regex removes triple backticks and the 'json' keyword at the start\n str = str.replace(/^```json\\s*/, ''); // Remove starting ```\n str = str.replace(/```$/, ''); // Remove ending ```\n \n return str.trim();\n}\n\nfunction normalizeRole(role) {\n return (role || '').trim().toLowerCase();\n}\n\nconst roleToManagerEmail = {\n 'java team lead': 'user@example.com',\n 'python developer': 'user@example.com',\n 'frontend developer': 'user@example.com',\n // add other roles as needed\n};\n\nconst fallbackManagerEmail = 'user@example.com';\n\nreturn items.map(item => {\n const raw = item.json.text || '';\n const jsonStr = stripMarkdownJson(raw);\n\n let parsed;\n try {\n parsed = JSON.parse(jsonStr);\n } catch (e) {\n item.json.error = `JSON parse failed: ${e.message}`;\n return item;\n }\n\n // Merge the parsed JSON fields into the current item\n Object.assign(item.json, parsed);\n\n // Normalize role and assign manager email\n const normalizedRole = normalizeRole(item.json.role);\n const managerEmail = Object.prototype.hasOwnProperty.call(roleToManagerEmail, normalizedRole)\n ? roleToManagerEmail[normalizedRole]\n : fallbackManagerEmail;\n\n item.json.managerEmail = managerEmail;\n\n return item;\n});\n" }, "position": [ 480, -80 ] }, { "id": "5943f68f-a39f-4532-a437-732d98d53079", "name": "Group & Build HTML Tables", "type": "code", "params": { "jsCode": "function escapeHtml(text) {\n if (!text) return '';\n return text\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\n// Group applicants by managerEmail, then by role\nconst groupedByManager = {};\n\n// Step 1: Group items\nitems.forEach(item => {\n const applicant = item.json;\n const managerEmail = applicant.managerEmail || 'user@example.com';\n const role = applicant.role || 'Unknown Role';\n\n if (!groupedByManager[managerEmail]) {\n groupedByManager[managerEmail] = {};\n }\n if (!groupedByManager[managerEmail][role]) {\n groupedByManager[managerEmail][role] = [];\n }\n \n groupedByManager[managerEmail][role].push(applicant);\n});\n\n// Step 2: Build HTML per manager with tables per role\nconst output = [];\n\nfor (const [managerEmail, roles] of Object.entries(groupedByManager)) {\n\n let emailHtml = `

Today's New Applicants

`;\n\n for (const [role, applicants] of Object.entries(roles)) {\n emailHtml += `

Role: ${escapeHtml(role)}

`;\n \n // Build table header\n emailHtml += `\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n `;\n\n // Add each applicant as a row\n applicants.forEach(app => {\n emailHtml += `\n \n \n \n \n \n \n \n \n \n \n `;\n });\n\n emailHtml += `

Name	Email	Phone	Years of Experience	Top Skills	Location	Notice Period	Summary
${escapeHtml(app.name)}	${escapeHtml(app.email)}	${escapeHtml(app.phone)}	${escapeHtml(app.years_of_experience?.toString())}	${Array.isArray(app.top_skills) ? escapeHtml(app.top_skills.join(', ')) : escapeHtml(app.top_skills)}	${escapeHtml(app.location)}	${escapeHtml(app.notice_period)}	${escapeHtml(app.summary)}

`;\n }\n\n // Push one item per manager, as output for the next step (email sending)\n output.push({\n json: {\n managerEmail,\n html: emailHtml\n }\n });\n}\n\nreturn output;\n" }, "position": [ 700, -80 ] }, { "id": "9509d5c2-f66f-4294-9432-0b2587283b7a", "name": "Send Digest to Managers", "type": "integration", "params": { "sendTo": "={{ $json.managerEmail }}", "message": "={{ $json.html }}", "options": {}, "service": "gmail", "subject": "=Today's Applicants Digest – {{ $now.format('MM-DD') }}", "operation": "read" }, "position": [ 900, -80 ] } ] }

Daily applicant digest by role with Gemini AI extraction for hiring managers