Once you pass a dozen applications, memory stops working. You forget which version of your résumé went where, miss a follow-up window, or get a call from a recruiter and can't remember the role. A tracker fixes that in ten minutes a week. Below is the structure we recommend and a five-minute Google Sheets setup.
The columns that actually matter
| Column | Why it matters |
|---|---|
| Date applied | Drives your follow-up schedule |
| Company | Group by employer to spot patterns |
| Role & job ID | Recruiters ask for the ID; large employers have dozens of similar titles |
| Source | Where you found it (job board, referral, careers site). Tells you what's working |
| Status | Applied → Assessment → Interview → Offer → Rejected/Withdrawn |
| Next action & date | The only column that creates momentum |
| Contact | Recruiter name, email, phone |
| Pay / schedule | So you can compare offers quickly |
| Notes | Interview questions asked, impressions, red flags |
Set up the sheet in five minutes
- Open Google Sheets and create a blank sheet named Job Tracker.
- Add the nine column headers above in row 1 and freeze the row (View → Freeze → 1 row).
- Select the Status column, then Data → Data validation → Dropdown, and add: Applied, Assessment, Interview, Offer, Rejected, Withdrawn.
- Add conditional formatting on Status: green for Offer, blue for Interview, grey for Rejected.
- In the Next action date column, use Format → Conditional formatting → "Date is before today" in red so overdue follow-ups jump out.
Formula worth adding: in a summary cell, =COUNTIF(E:E,"Interview") shows how many live interviews you have. Tracking your application-to-interview ratio tells you whether to fix your résumé (low ratio) or your interviewing (high ratio, few offers).
A weekly routine
- Monday: review every row with a next-action date this week. Send follow-ups for applications older than 7–10 days with no response.
- Daily: log new applications immediately. Paste the job description into the Notes column; postings often disappear.
- Friday: count applications, assessments and interviews. If applications are up but interviews are flat, change your approach rather than your volume.
Follow-up templates
7 days after applying
Subject: Application for Warehouse Associate (ID 4471) — quick follow-up
Hi [Name], I applied for the Warehouse Associate role on [date] and wanted to confirm my application was received. I'm available for any shift and could start within a week. Thank you for your time.
After an interview
Thank you for speaking with me today about the [role]. I enjoyed learning about [specific detail], and I'm confident I can [one concrete contribution]. Please let me know if you need anything else from me.
For high-volume applications
If you're applying to large employers with online assessments and hiring events, add two columns: Assessment completed (Y/N) and Hiring event date. These employers move fast; the candidates who complete the assessment the same day are usually the ones who get scheduled. Pair the sheet with our weekly job search plan.
