Extract structured candidate data from resumes with GPT AI
Needs changesWhat this workflow does
This AI workflow has 20 nodes and runs when a chat message arrives. Along the way it connects OpenAI Chat Model and Google Sheets.
How it runs
Trigger: When a chat message arrives.
- Switch: routes items into 8 branches
- Extract from CSV (Extract from File): extracts data from a file
- Extract from HTML (Extract from File): extracts data from a file (html)
- Extract from ODS (Extract from File): extracts data from a file (ods)
- Extract from PDF (Extract from File): extracts data from a file (pdf)
- Extract from RTF (Extract from File): extracts data from a file (rtf)
- Extract from TXT (Extract from File): extracts data from a file (text)
- Extract from XML (Extract from File): extracts data from a file (xml)
- Extract from XLS (Extract from File): extracts data from a file (xls)
- Edit Fields (Edit Fields (Set)): sets 1 field: output
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent1 (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent1 (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Extract from File
n8n-nodes-base.extractFromFile - Aggregate
n8n-nodes-base.aggregate
From the author
Who is this for? This workflow is perfect for HR teams, recruiters, and hiring platforms that need to automate the extraction of key candidate details—like name, email, skills, and education—from resume files submitted in various formats. What problem does…