Smart job search: resume scoring & tailoring with OpenAI, Apify, and Airtable
Needs changesWhat this workflow does
This AI workflow has 16 nodes and runs on a schedule (legacy Cron node). Along the way it connects OpenAI Chat Model, Google Sheets, Airtable and OpenAI.
How it runs
Trigger: On a schedule (legacy Cron node).
- 📄 Fetch Job Preferences (Google Sheets) (Google Sheets): uses Google Sheets
- Split Job Preferences (Loop Over Items (Split in Batches)): loops over the items in batches
- 🔄 Loop: Search Jobs per Preference (Loop Over Items (Split in Batches)): loops over the items in batches
- 🧹 Clean & Extract Job Data (Code): runs custom JavaScript code
- 🔍 Apify: Scrape Jobs (HTTP Request): calls an HTTP API
- Filter: Recent Jobs (<48h) (If): checks a condition and branches into true / false
- 🔄 Loop: Score New Jobs (Loop Over Items (Split in Batches)): loops over the items in batches
- 🗂️ Archive: Old Jobs (Airtable) (Airtable): uses Airtable
- 🔄 Loop: Generate CV Suggestions (Loop Over Items (Split in Batches)): loops over the items in batches
- 🤖 AI: Score CV vs Job (AI Agent): runs an AI agent, with model: OpenAI Chat Model
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Cron in 🕒 Trigger: Daily Job Fetch: replace with Schedule Trigger.
- AI Agent v1 (old agent modes) in 🤖 AI: Score CV vs Job (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 |
|---|---|
| Cron 🕒 Trigger: Daily Job Fetch | Schedule Trigger |
| AI Agent v1 (old agent modes) 🤖 AI: Score CV vs Job (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Cron
n8n-nodes-base.cron - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Airtable
n8n-nodes-base.airtable - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Who is this for? This workflow is designed for job seekers who want to automate their job application research and resume optimization. It's ideal for professionals who want to match their CVs to new job postings daily, improving the chance of landing…