Track job applications from Gmail automatically with n8n and AI

Описание и применение

Автоматический сбор статусов заявок на работу из Gmail в Google‑Sheet с помощью n8n и Gemini, обновляющийся каждый час.

Задача

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

Результат

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

Рабочий процесс

• 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

Доказательства

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.

Источник

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.

Источник

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

Источник