Automate applicant tracking with GPT-4.1 CV parsing, Google Sheets and Gmail alerts
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs when someone submits an n8n form (“test”). Along the way it connects OpenAI, Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“test”).
- Code: runs custom JavaScript code
- 2. Extract Text from PDF CV (Extract from File): extracts data from a file (pdf)
- 3. Analyze & Structure CV with AI (OpenAI): uses OpenAI
- 4. Parse AI Output (Code): runs custom JavaScript code
- 5. Check for Duplicate Applicant (Google Sheets): uses Google Sheets
- 6. If Applicant is New... (If): checks a condition and branches into true / false
- 7. Save Applicant Data to Google Sheets (Google Sheets): append or update
- 8a. Send Confirmation Email to Applicant (Gmail): uses Gmail
- 8b. Send Notification Email to Recruiter (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Code
n8n-nodes-base.code - No Operation, do nothing
n8n-nodes-base.noOp - n8n Form Trigger
n8n-nodes-base.formTrigger - Extract from File
n8n-nodes-base.extractFromFile - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail
From the author
Template Description: > Stop manually reading every CV and copy-pasting data into a spreadsheet. This workflow acts as an AI recruiting assistant, automating your entire initial screening process. It captures applications from a public form, uses AI to…