Automated resume review system using OpenAI + Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs when someone submits an n8n form (“Submit your CV”). Along the way it connects Google Sheets, Google Drive and OpenAI Chat Model.
How it runs
Trigger: When someone submits an n8n form (“Submit your CV”).
- Upload to google drive (Google Drive): uses Google Drive
- Resume extraction (Extract from File): extracts data from a file (pdf)
- Personal Info (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Qualification (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Merge: merges the data from its input branches
- Summarizer (Summarization Chain): summarizes text with AI, with model: OpenAI Chat Model
- wanted profile (Edit Fields (Set)): sets 1 field: wanted-profile
- HR Expert (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Google Sheets: append
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 (11)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Merge
n8n-nodes-base.merge - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Edit Fields (Set)
n8n-nodes-base.set - Summarization Chain
@n8n/n8n-nodes-langchain.chainSummarization - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Who is this for? This workflow is ideal for: - HR teams and recruiters seeking to streamline resume screening. - Hiring managers who want quick, summarized candidate insights. - Recruitment agencies handling large volumes of applicant data. - Startups and…