Auto-Update job application status from Gmail to Google Sheets

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