Track job applications from Gmail automatically with n8n and AI

Description and use

Automatically track job‑application emails from Gmail into a Google Sheet using n8n and Gemini, updating hourly.

Problem

Keeping track of job‑application status emails in a spreadsheet becomes a second job after dozens of applications.

Outcome

Automated hourly tracking of job‑application emails in a single Google Sheet, reducing manual effort and preventing missed deadlines.

Workflow

• Gmail Trigger (hourly, filtered search)
• Code node trims email to 3000 chars
• LLM Chain with Gemini parses email and outputs structured data
• If is_job_application true, build application_key and Gmail link
• Google Sheets node appends or updates row by application_key

Evidence

After the twentieth job application, nobody remembers which company replied, which one sent a coding test with a Friday deadline, and which one quietly rejected you three weeks ago.

Source

This post walks through an n8n workflow that watches Gmail, uses Google Gemini (free tier) to recognise emails about your applications, and keeps one row per application in Google Sheets with the latest status, next step and deadline.

Source

Gmail Trigger (every hour, filtered search) -> Code: keep sender, subject, date, first 3,000 chars -> Basic LLM Chain + Gemini + Structured Output Parser -> IF is_job_application -> Set: build application_key + Gmail link -> Google Sheets: append or update by application_key

Source