Auto-Update job application status from Gmail to Google Sheets
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.
Worth a look
- Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Gmail Trigger)
Nodes used (6)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - If
n8n-nodes-base.if
What it does
How this works Every time you receive an email, and if that email is about your job application, then the status of your job application will be updated in the Google Sheet (No more manual tracking) How to set it up 1 : Create API keys for Google sheet/Gmail Link, and OpenRouter link - If you do not know how to create and add an API key, then search on Google, and you will find a solution, or contact me (you will find that in my n8n profile) 2 : Create a Google sheet (JobApplicationStatus) (with three column headings "Company", "JobRole", and "Status") in your Google Drive and link it in this workflow in the Google Sheet node Constomization Replace with a better free/paid AI model you like (you don't need to, free also works) Edit the prompt to get better results if you find any problem with the AI output Feel free to change the workflow for other similar usecase