Score and triage job applicants with Airtable, Google Drive and OpenAI
Needs changesWhat this workflow does
This AI workflow has 30 nodes and runs when someone submits an n8n form (“Job Application”). Along the way it connects Airtable, Google Drive, OpenAI Chat Model and OpenAI and 1 more.
How it runs
Trigger: When someone submits an n8n form (“Job Application”).
- Upload CV to Google Drive (Google Drive): uses Google Drive
- Set Applicant Details (Edit Fields (Set)): sets 6 fields: Name, Phone, email…
- Store in Airtable (Airtable): create
- Download CV from Drive (Google Drive): download
- Extract CV Data (Extract from File): extracts data from a file (pdf)
- AI Evaluation Agent (AI Agent): runs an AI agent, with model: OpenAI GPT-4 Chat Model; 1 tool (Fetch Airtable Data); output parser: Parse Structured Output
- If: checks a condition and branches into true / false
- Log Potential Hire (Airtable): update
- Log Rejected Candidate (Airtable): update
- Generate Questionnaires (OpenAI): uses OpenAI, with 1 tool (Additional Airtable Data)
…plus 10 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 Evaluation Agent (v1.7): 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 Evaluation Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (14)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Airtable
n8n-nodes-base.airtable - Google Drive
n8n-nodes-base.googleDrive - Edit Fields (Set)
n8n-nodes-base.set - Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Airtable Tool
n8n-nodes-base.airtableTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - OpenAI
@n8n/n8n-nodes-langchain.openAi - n8n Form
n8n-nodes-base.form - Send Email
n8n-nodes-base.emailSend - Google Calendar Tool
n8n-nodes-base.googleCalendarTool
From the author
Quick overview This workflow collects job applications via an n8n form, stores applicant details and CVs in Google Drive and Airtable, uses OpenAI to score CV fit, branches candidates into rejected or interviewing stages, then generates followup…