planeta ai logo
Darmowy szablon automatyzacji

Zautomatyzowany przepływ pracy HR oparty na sztucznej inteligencji do analizy CV i oceny kandydatów

32159
25 dni temu
18
bloków

Jak to działa

Ten szablon automatyzacji usprawnia proces obsługi aplikacji o pracę poprzez wyodrębnianie kluczowych informacji z przesłanych CV, analizę kwalifikacji kandydata względem zdefiniowanego profilu oraz zapis wyników w arkuszu Google Sheets. Oto szczegóły działania:

Zbieranie i ekstrakcja danych

  • Proces rozpoczyna się od przesłania formularza (węzeł On form submission), który uruchamia ekstrakcję danych z pliku CV przy użyciu węzła Extract from File.
  • Dwa węzły informationExtractor (Qualifications i Personal Data) służą do parsowania szczegółów takich jak wykształcenie, doświadczenie zawodowe, umiejętności, miasto, data urodzenia i numer telefonu z tekstu CV.

Przetwarzanie i ocena

  • Węzeł Merge łączy wyodrębnione dane osobowe i kwalifikacyjne w jedną całość.
  • Połączone dane są następnie przetwarzane przez Summarization Chain, który generuje zwięzłe podsumowanie profilu kandydata.
  • Łańcuch HR Expert ocenia kandydata względem pożądanego profilu (Profile Wanted), przypisując wynik i dostarczając rekomendacje dotyczące zatrudnienia.
  • Wszystkie zebrane i przetworzone dane, wraz z wynikami oceny, są zapisywane w arkuszu Google Sheets za pomocą węzła Google Sheets.

Kroki konfiguracji

Aby wdrożyć ten workflow w swoim środowisku n8n, wykonaj następujące kroki:

Konfiguracja

  • Rozpocznij od skonfigurowania instancji n8n, jeśli jeszcze tego nie zrobiłeś. Możesz zarejestrować się na stronie n8n lub hostować aplikację samodzielnie.
  • Zaimportuj dostarczoną konfigurację JSON do swojego obszaru roboczego n8n. Upewnij się, że wszystkie niezbędne poświadczenia (np. Google Drive, Google Sheets, klucze API OpenAI) są poprawnie skonfigurowane w sekcji Credentials, ponieważ niektóre węzły wymagają integracji z zewnętrznymi usługami.

Dostosowanie

  • Dostosuj parametry każdego węzła zgodnie ze swoimi wymaganiami. Na przykład zmień pola w węźle formTrigger, aby pasowały do informacji, które chcesz zbierać od kandydatów.
  • Dostosuj prompty dla modeli AI w węzłach takich jak Qualifications, Summarization Chain i HR Expert, aby odpowiadały rodzajowi analiz, które chcesz przeprowadzić na profilach kandydatów.
  • Zaktualizuj ustawienia docelowe w węźle Google Sheets, aby wskazywały na Twój własny arkusz, w którym mają być zapisywane wyniki.

Przykłady zastosowań

Ta automatyzacja może być wykorzystana w różnych scenariuszach związanych z rekrutacją i zarządzaniem kandydatami. Oto kilka potencjalnych zastosowań:

  • Automatyczna weryfikacja zgodności CV z wymaganiami stanowiska.
  • Generowanie podsumowań profilów kandydatów dla szybkiej oceny przez rekruterów.
  • Automatyczne przypisywanie ocen kandydatom na podstawie ich kwalifikacji.
  • Zarządzanie bazą danych kandydatów w arkuszu Google Sheets.
  • Integracja z innymi narzędziami HR poprzez API.
  • Automatyczne wysyłanie odpowiedzi do kandydatów na podstawie wyników oceny.
  • Raportowanie i analiza statystyk rekrutacyjnych.

Potrzebujesz pomocy w dostosowaniu? Skontaktuj się ze mną w celu konsultacji i wsparcia lub dodaj mnie na LinkedIn.

   Skopiuj kod szablonu   
{"id":"t1P14FvfibKYCh3E","meta":{"instanceId":"a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462","templateCredsSetupCompleted":true},"name":"HR-focused automation pipeline with AI","tags":[],"nodes":[{"id":"b1092f93-502c-4af0-962e-2b69311b92a3","name":"On form submission","type":"n8n-nodes-base.formTrigger","position":[-520,-200],"webhookId":"2a87705d-8ba1-41f1-80ef-85f364ce253e","parameters":{"options":{},"formTitle":"Send CV","formFields":{"values":[{"fieldLabel":"Name","placeholder":"Name","requiredField":true},{"fieldType":"email","fieldLabel":"Email","placeholder":"Email","requiredField":true},{"fieldType":"file","fieldLabel":"CV","requiredField":true,"acceptFileTypes":".pdf"}]}},"typeVersion":2.2},{"id":"77edfe2a-4c6a-48c8-8dc9-b275491be090","name":"Extract from File","type":"n8n-nodes-base.extractFromFile","position":[-160,-200],"parameters":{"options":{},"operation":"pdf","binaryPropertyName":"CV"},"typeVersion":1},{"id":"ebf2e194-3515-4c0a-8745-790b63bf336f","name":"Qualifications","type":"@n8n/n8n-nodes-langchain.informationExtractor","position":[160,-100],"parameters":{"text":"={{ $json.text }}","options":{"systemPromptTemplate":"You are an expert extraction algorithm.nOnly extract relevant information from the text.nIf you do not know the value of an attribute asked to extract, you may omit the attribute's value."},"attributes":{"attributes":[{"name":"Educational qualification","required":true,"description":"Summary of your academic career. Focus on your high school and university studies. Summarize in 100 words maximum and also include your grade if applicable."},{"name":"Job History","required":true,"description":"Work history summary. Focus on your most recent work experiences. Summarize in 100 words maximum"},{"name":"Skills","required":true,"description":"Extract the candidate’s technical skills. What software and frameworks they are proficient in. Make a bulleted list."}]}},"typeVersion":1},{"id":"4f40404c-1d47-4bde-9b4b-16367cf11e4f","name":"Summarization Chain","type":"@n8n/n8n-nodes-langchain.chainSummarization","position":[900,-220],"parameters":{"options":{"summarizationMethodAndPrompts":{"values":{"prompt":"=Write a concise summary of the following:nnCity: {{ $json.output.city }}nBirthdate: {{ $json.output.birthdate }}nEducational qualification: {{ $json.output["Educational qualification"] }}nJob History: {{ $json.output["Job History"] }}nSkills: {{ $json.output.Skills }}nnUse 100 words or less. Be concise and conversational.","combineMapPrompt":"=Write a concise summary of the following:nnCity: {{ $json.output.city }}nBirthdate: {{ $json.output.birthdate }}nEducational qualification: {{ $json.output["Educational qualification"] }}nJob History: {{ $json.output["Job History"] }}nSkills: {{ $json.output.Skills }}nnUse 100 words or less. Be concise and conversational."}}}},"typeVersion":2},{"id":"9f9c5f16-1dc2-4928-aef8-284daeb6be51","name":"Merge","type":"n8n-nodes-base.merge","position":[660,-220],"parameters":{"mode":"combine","options":{},"combineBy":"combineAll"},"typeVersion":3},{"id":"51bd14cc-2c54-4f72-b162-255f7e277aff","name":"Profile Wanted","type":"n8n-nodes-base.set","position":[1300,-220],"parameters":{"options":{},"assignments":{"assignments":[{"id":"a3d049b0-5a70-4e7b-a6f2-81447da5282a","name":"profile_wanted","type":"string","value":"We are a web agency and we are looking for a full-stack web developer who knows how to use PHP, Python and Javascript. He has experience in the sector and lives in Northern Italy."}]}},"typeVersion":3.4},{"id":"4a120e5d-b849-4a29-b7f3-12c653552367","name":"Google Sheets","type":"n8n-nodes-base.googleSheets","position":[1960,-220],"parameters":{"columns":{"value":{"CITY":"={{ $('Merge').item.json.output.city }}","DATA":"={{ $now.format('dd/LL/yyyy') }}","NAME":"={{ $('On form submission').item.json.Nome }}","VOTE":"={{ $json.output.vote }}","EMAIL":"={{ $('On form submission').item.json.Email }}","SKILLS":"={{ $('Merge').item.json.output.Skills }}","TELEFONO":"={{ $('Merge').item.json.output.telephone }}","SUMMARIZE":"={{ $('Summarization Chain').item.json.response.text }}","EDUCATIONAL":"={{ $('Merge').item.json.output["Educational qualification"] }}","JOB HISTORY":"={{ $('Merge').item.json.output["Job History"] }}","DATA NASCITA":"={{ $('Merge').item.json.output.birthdate }}","CONSIDERATION":"={{ $json.output.consideration }}"},"schema":[{"id":"DATA","type":"string","display":true,"required":false,"displayName":"DATA","defaultMatch":false,"canBeUsedToMatch":true},{"id":"NAME","type":"string","display":true,"required":false,"displayName":"NAME","defaultMatch":false,"canBeUsedToMatch":true},{"id":"PHONE","type":"string","display":true,"removed":false,"required":false,"displayName":"PHONE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"CITY","type":"string","display":true,"required":false,"displayName":"CITY","defaultMatch":false,"canBeUsedToMatch":true},{"id":"EMAIL","type":"string","display":true,"required":false,"displayName":"EMAIL","defaultMatch":false,"canBeUsedToMatch":true},{"id":"DATA NASCITA","type":"string","display":true,"required":false,"displayName":"DATA NASCITA","defaultMatch":false,"canBeUsedToMatch":true},{"id":"EDUCATIONAL","type":"string","display":true,"required":false,"displayName":"EDUCATIONAL","defaultMatch":false,"canBeUsedToMatch":true},{"id":"JOB HISTORY","type":"string","display":true,"required":false,"displayName":"JOB HISTORY","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SKILLS","type":"string","display":true,"required":false,"displayName":"SKILLS","defaultMatch":false,"canBeUsedToMatch":true},{"id":"SUMMARIZE","type":"string","display":true,"required":false,"displayName":"SUMMARIZE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"VOTE","type":"string","display":true,"removed":false,"required":false,"displayName":"VOTE","defaultMatch":false,"canBeUsedToMatch":true},{"id":"CONSIDERATION","type":"string","display":true,"required":false,"displayName":"CONSIDERATION","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":[],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{},"operation":"append","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1ssz5RvN1Hr20Q31pnYnbjCLu1MGBvoLttBAjXunMRQE/edit#gid=0","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1ssz5RvN1Hr20Q31pnYnbjCLu1MGBvoLttBAjXunMRQE","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1ssz5RvN1Hr20Q31pnYnbjCLu1MGBvoLttBAjXunMRQE/edit?usp=drivesdk","cachedResultName":"Ricerca WebDev"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5},{"id":"a154d8a5-9f85-45bb-b082-f702c13c3507","name":"Structured Output Parser","type":"@n8n/n8n-nodes-langchain.outputParserStructured","position":[1720,-20],"parameters":{"schemaType":"manual","inputSchema":"{nt"type": "object",nt"properties": {ntt"vote": {nttt"type": "string"ntt},ntt"consideration": {nttt"type": "string"ntt}nt}n}"},"typeVersion":1.2},{"id":"037ac851-7885-4b78-ac75-dfa0ebb6003d","name":"HR Expert","type":"@n8n/n8n-nodes-langchain.chainLlm","position":[1560,-220],"parameters":{"text":"=Profilo ricercato:n{{ $json.profile_wanted }}nnCandidato:n{{ $('Summarization Chain').item.json.response.text }}","messages":{"messageValues":[{"message":"Sei un esperto HR e devi capire se il candidato è in linea con il profilo ricercato dall'azienda.nnDevi dare un voto da 1 a 10 dove 1 significa che il candidato non è in linea con quanto richiesto mentre 10 significa che è il candidato ideale perchè rispecchia in toto il profilo cercato.nnInoltre nel campo "consideration" motiva il perchè hai dato quel voto. "}]},"promptType":"define","hasOutputParser":true},"typeVersion":1.5},{"id":"ed5744c4-df06-4a01-a103-af4dd470d482","name":"Personal Data","type":"@n8n/n8n-nodes-langchain.informationExtractor","position":[160,-280],"parameters":{"text":"={{ $json.text }}","options":{"systemPromptTemplate":"You are an expert extraction algorithm.nOnly extract relevant information from the text.nIf you do not know the value of an attribute asked to extract, you may omit the attribute's value."},"schemaType":"manual","inputSchema":"{nt"type": "object",nt"properties": {ntt"telephone": {nttt"type": "string"ntt},n "city": {nttt"type": "string"ntt},n "birthdate": {nttt"type": "string"ntt}nt}n}"},"typeVersion":1},{"id":"181c1249-b05c-4c35-8cac-5f9738cc1fe6","name":"Upload CV","type":"n8n-nodes-base.googleDrive","position":[-160,-380],"parameters":{"name":"=CV-{{ $now.format('yyyyLLdd') }}-{{ $json.CV[0].filename }}","driveId":{"__rl":true,"mode":"list","value":"My Drive"},"options":{},"folderId":{"__rl":true,"mode":"list","value":"1tzeSpx4D3EAGXa3Wg-gqGbdaUk6LIZTV","cachedResultUrl":"https://drive.google.com/drive/folders/1tzeSpx4D3EAGXa3Wg-gqGbdaUk6LIZTV","cachedResultName":"CV"},"inputDataFieldName":"CV"},"credentials":{"googleDriveOAuth2Api":{"id":"HEy5EuZkgPZVEa9w","name":"Google Drive account"}},"typeVersion":3},{"id":"d31ee1c4-e4be-41d9-8f36-e6fb797ced8e","name":"OpenAI","type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","position":[920,240],"parameters":{"model":{"__rl":true,"mode":"list","value":"gpt-4o-mini"},"options":{}},"credentials":{"openAiApi":{"id":"CDX6QM4gLYanh0P4","name":"OpenAi account"}},"typeVersion":1.2},{"id":"0290cb72-a581-4aff-8b5d-1aa63e0a630f","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[-560,-680],"parameters":{"color":3,"width":540,"content":"## HR Expert nThis workflow automates the process of handling job applications by extracting relevant information from submitted CVs, analyzing the candidate's qualifications against a predefined profile, and storing the results in a Google Sheet"},"typeVersion":1},{"id":"361084ff-9735-4a56-8988-be573391838b","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[-240,-460],"parameters":{"width":300,"height":420,"content":"The CV is uploaded to Google Drive and converted so that it can be processedn"},"typeVersion":1},{"id":"4b6f004f-c77b-4522-99d4-737a68f6cfac","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[120,-380],"parameters":{"width":360,"height":440,"content":"The essential information for evaluating the candidate is collected in two different chains"},"typeVersion":1},{"id":"73e11af9-65e3-4fcd-bb99-8a3f212ce9fb","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[860,-300],"parameters":{"width":320,"height":240,"content":"Summary of relevant information useful for classifying the candidate"},"typeVersion":1},{"id":"606711d1-8e6d-44b3-91ac-c047d8a4054f","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[1240,-300],"parameters":{"width":220,"height":240,"content":"Characteristics of the profile sought by the company that intends to hire the candidate"},"typeVersion":1},{"id":"89c3210c-c599-41dc-97a3-bf8df2beb751","name":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[1500,-300],"parameters":{"width":360,"height":240,"content":"Candidate evaluation with vote and considerations of the HR agent relating the profile sought with the candidate's skills"},"typeVersion":1}],"active":false,"pinData":{},"settings":{"executionOrder":"v1"},"versionId":"594728c0-b842-404d-8810-c6f7f3f4631d","connections":{"Merge":{"main":[[{"node":"Summarization Chain","type":"main","index":0}]]},"OpenAI":{"ai_languageModel":[[{"node":"Qualifications","type":"ai_languageModel","index":0},{"node":"Summarization Chain","type":"ai_languageModel","index":0},{"node":"HR Expert","type":"ai_languageModel","index":0},{"node":"Personal Data","type":"ai_languageModel","index":0}]]},"HR Expert":{"main":[[{"node":"Google Sheets","type":"main","index":0}]]},"Upload CV":{"main":[[]]},"Personal Data":{"main":[[{"node":"Merge","type":"main","index":0}]]},"Profile Wanted":{"main":[[{"node":"HR Expert","type":"main","index":0}]]},"Qualifications":{"main":[[{"node":"Merge","type":"main","index":1}]]},"Extract from File":{"main":[[{"node":"Qualifications","type":"main","index":0},{"node":"Personal Data","type":"main","index":0}]]},"On form submission":{"main":[[{"node":"Extract from File","type":"main","index":0},{"node":"Upload CV","type":"main","index":0}]]},"Summarization Chain":{"main":[[{"node":"Profile Wanted","type":"main","index":0}]]},"Structured Output Parser":{"ai_outputParser":[[{"node":"HR Expert","type":"ai_outputParser","index":0}]]}}}
  • CSV
  • Sheet
  • Spreadsheet
  • GS
  • LangChain
  • json
  • zod
  • NER
  • parse
  • parsing
  • JSON
  • data extraction
  • structured
Planeta AI 2025 
magic-wandmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram