job-tracker

Scan Gmail for job application updates and sync Google Sheets rows.

Updated Feb 2, 2026

Search Tags:#automation #gmail #workflows #google-sheets #job-tracker #email-classification

Ready to run

npx skills add https://github.com/luqmannurhakimbazman/ashford --skill job-tracker

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: job-tracker
Source: https://github.com/luqmannurhakimbazman/ashford/tree/main/aerion/skills/job-tracker
Command: npx skills add https://github.com/luqmannurhakimbazman/ashford --skill job-tracker

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Track job applications automatically by scanning Gmail for updates and syncing them into a central Google Sheet, reducing manual tracking overhead and missed statuses.

Core Features & Use Cases

Email classification into stages using signals from subject, body, and sender per references/email-patterns.md
Entity extraction for Company, Role, Stage, Date, and Notes from each email
Enforces forward-only Stage progression with terminal constraints for Rejected and Ghosted
Update logic: create new rows for new applications; update existing rows; append notes with timestamps
Works with a defined sheet schema: Company, Role, Stage, Last Contact Date, Notes; matches emails to existing rows by Company + Role; creates new rows for new applications
Quick data hygiene and traceability through an audit-friendly notes column

Quick Start

Start monitoring your Gmail for new job emails and update the Job Tracker sheet automatically.

Frequently Asked Questions about job-tracker

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I automate tracking job applications from Gmail to Google Sheets?▼

Automating job application tracking from Gmail to Google Sheets requires scanning emails for updates and syncing rows accordingly. This reduces manual tracking overhead by automatically classifying stages and appending notes for interviews, rejections, and offers.

How does email classification work for job application status updates?▼

Email classification for job application status updates works by extracting signals from subject, body, and sender. The system identifies stages like interview invitations or rejections, enforces forward-only stage progression, and matches entities to existing rows by Company and Role.

Can I use Gmail filters to update job application stages in Google Sheets?▼

Yes, you can use Gmail to update job application stages in Google Sheets. The system scans incoming emails, extracts company and role entities, and automatically updates corresponding sheet rows with new stages and timestamped notes.

What is the Google Sheets schema for tracking job applications?▼

The Google Sheets schema for tracking job applications includes columns for Company, Role, Stage, Last Contact Date, and Notes. The system matches incoming emails to existing rows using Company and Role fields, creating new rows for new applications.

Does job application tracking support terminal stages like Rejected or Ghosted?▼

Yes, job application tracking supports terminal stages like Rejected and Ghosted through terminal constraints. Once an application reaches a terminal stage, the forward-only stage progression logic prevents it from moving backwards, ensuring accurate status history.