Guides › Careers

Keep every job application organised in one place

A job search tracker that's updated from your emails, showing where you've applied, what stage you're at and who to follow up with.

CareersIntermediate25 minGmailGoogle SheetsAI assistant

When to use it

Weekly during a job search

Create your tracker
Make a Google Sheet with columns: Date applied, Company, Role, Where found, Stage (Applied, Interview, Offer, Rejected), Contact, Next step, Follow-up date.
Label job emails
In Gmail's settings, under Filters, create a filter for words like 'application', 'interview' and 'your candidacy' and apply a Job search label. In Outlook, a rule can move them to a folder.
Update the tracker weekly
Once a week, copy new emails from the label into your AI assistant with this prompt.
Prompt to copyHere are this week's job search emails. For each one, extract: company, role, what the email is (confirmation, interview invite, rejection, request for info), any date or deadline, contact name, and the next step for me. Return a table with columns: Company, Role, Stage, Contact, Next step, Follow-up date. If an email needs a reply, say so in Next step. [paste emails]
Paste and follow up
Update your sheet with the new rows. Set a follow-up date about a week after applying if you've heard nothing.

A tracker stops good leads slipping through the cracks when you're applying to lots of roles.
If your plan includes Gemini in Gmail, you can ask it to summarise the Job search label instead of pasting emails.