Screen and route AI-scored job applications with Airtable, Google Drive and OpenRouter
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs when someone submits an n8n form (“Job Application”). Along the way it connects Airtable, Google Drive, OpenRouter Chat Model and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Job Application”).
- Normalize Phone (Edit Fields (Set)): sets 1 field: phoneE164
- Check Existing Applicant (Airtable): search
- Is Duplicate? (If): checks a condition and branches into true / false
- Already Applied (n8n Form): shows the next form page
- Attach CV File (Edit Fields (Set)): sets 1 field: data
- Upload CV to Drive (Google Drive): uses Google Drive
- Make CV Link Viewable (Google Drive): share
- Log Application (Airtable): create
- Application Received (n8n Form): shows the next form page
- Attach CV for Screening (Edit Fields (Set)): sets 1 field: data
…plus 7 more steps. See the full node list below.
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 (12)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Airtable
n8n-nodes-base.airtable - If
n8n-nodes-base.if - n8n Form
n8n-nodes-base.form - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow collects job applications via an n8n Form, checks duplicates in Airtable, stores CV files in Google Drive, and uses OpenRouter to score and summarize each CV for an n8n Automation Expert role, updating Airtable status and emailing…