Track daily job applications from Gmail to Google Sheets via GPT-4o-mini with approval
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs on a schedule (every day at 09:00). Along the way it connects OpenAI Chat Model, Google Sheets and Gmail.
How it runs
Trigger: On a schedule (every day at 09:00).
- Fetch Job Application Emails (Gmail): get many
- Process Email Data (Edit Fields (Set)): sets or maps fields
- Extract Key Information (Basic LLM Chain): sends a prompt to an LLM, with model: Open AI
- Format Data (Edit Fields (Set)): sets 6 fields: receivedDate, Company, Position…
- Filter Valid Job Updates (If): checks a condition and branches into true / false
- Branch Valid Application Status (If): checks a condition and branches into true / false
- Track Invalid Application Status (Google Sheets): append
- Track New Application (Google Sheets): append
- Aggregate: combines items into one
- Email Updates & Wait for Approval (Gmail): send and wait for a reply
…plus 3 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 (10)
- Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail - Split Out
n8n-nodes-base.splitOut
From the author
Who's it for Active job-seekers who apply to 10–30 roles a week and lose track of which application is at what stage. Built for anyone tired of manually updating a spreadsheet every time a recruiter replies — or worse, realizing their tracker has been lying…