Like many job seekers, I use a Google Sheet to track job applications: company, role, dates, and most importantly, the status (interview, rejection, ghosted, etc.).

But here’s the issue:

I often forgot to update the status after receiving follow-up emails. Over time, the tracker became inaccurate and unreliable.

So I built a lightweight automation using n8n and OpenAI to solve this.

🔁 How it works:

Trigger: A new email lands in my Gmail inbox

Classification: A GPT model analyzes the email and classifies it as:
✅ Proceeded to next round
❌ Rejected
📩 Not a job-related email

📌 If it's proceeded:
- The status in my Google Sheet is updated
- I receive an “Important” email update

📌 If it’s rejected:
- The sheet is silently updated (no email, less mental clutter)

🛠️ Tools Used:
- n8n for the automation workflow
- OpenAI’s GPT model for classification and info extraction
- Gmail + Google Sheets for integration