AI Agent & Workflow
A scheduled agentic workflow that maintains a personal job application tracker in Google Sheets.
Type
AI Agent & AI Workflow
Tools
Anthropic – Claude, Google Sheets, Google Drive API, Claude Chrome Extension
Year
2026
Description
An agentic workflow that maintains a personal job application tracker in Google Sheets on a weekly schedule, plus a couple of on-demand functions triggered by chat. It reads the sheet, checks live job postings against what’s recorded, updates previous entries, and reports back in plain language, largely without manual intervention.
Why
Job search spreadsheets are useful but tedious, time consuming, and not always great for one’s mental health (especially when having to mark sent applications as ghosted). Applications sit marked “Applied” long after a company goes quiet, and postings people bookmark to consider later can close, get filled, or change terms without anyone circling back to check. Doing this by hand means opening a dozen job links every week just to confirm nothing changed. This offloads that checking to something that runs on its own and only surfaces what actually needs a decision.
What the Task Does
- Ghosted sweep: every week, scans for applications still marked “Applied” more than 30 days out with no status change, and relabels them “Ghosted” directly in the sheet. Note: Interview and Rejected are changed manually, by request only, or manually by the user.
- Posting status check: for every application still live in the pipeline, Applied or Not Yet Applied, fetches the actual job posting and classifies it as “Open,” “Closed,” or “Unclear,” writing that directly into the sheet. Flags substantive changes too, a shifted salary range, a new location restriction, a different title.
- Fit scoring on new postings: when a link gets added in the Job Hunt Project, it reads the job description, compares it to experience (found in the project), and writes out what’s a strong match and what’s a gap, plus a hidden internal score used only to keep the “Not Yet Applied” list sorted by best fit first.
- Apply trigger: saying “I applied to X” in a chat moves that row into the applied section, sets the date, and finds the matching tailored resume in Google Drive by filename, without guessing if nothing confidently matches.
Task Setup
Runs automatically every Tuesday at 12:00AM Eastern via a scheduled task bound to a personal device, so it can drive the browser for the handful of edits as needed. Everything else, reading the sheet, fetching postings, matching resumes, runs through read-only connectors with no manual approval needed week to week. A few employer career pages are JavaScript-heavy enough that a plain fetch can’t confirm their status, those consistently come back “Unclear” rather than a guess.
