Track job applications from Gmail automatically with n8n and AI

说明与用途

使用 n8n 和 Gemini 自动将 Gmail 中的求职邮件状态追踪到 Google 表格，每小时更新一次。

问题

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

来源