# Track job applications from your inbox

> Researched. Work · Beginner · Research. Updated 2026-11-02.

Canonical page: https://www.aisetupsthatwork.com/setups/track-job-applications-from-your-inbox/

## What it does
Keep one tracker of every job application, filled from your inbox, with a flag and a follow-up draft for anything silent after 7 days.

## Who it's for
Job seekers with dozens of applications out who lose track of who replied and when to follow up.

## Tools
- Claude or ChatGPT
- Excel or Google Sheets
- Your inbox, through a connector or by pasting confirmation emails

## Steps
1. Ask the AI to build the tracker with the prompt below. Anthropic says Claude can create Excel files with working formulas.
2. Fill it from application confirmation emails. With a Gmail connector the AI can search them; otherwise paste them in.
3. Check each row against the email; fix company names and dates.
4. Each morning, filter for FOLLOW UP. Draft a two-line follow-up for each and send it yourself.
5. Update status as replies arrive: Replied, Interview, Rejected, Offer.
6. Each Friday, ask for the digest: sent, replies, interviews, and which resume version got replies.

## Copy-paste prompt
Adapt bracketed fields to your situation.
```text
Build a job application tracker (Excel) with one row per application:
Company | Role | Date applied | Contact | Resume version | Status (Applied, Replied, Interview, Rejected, Offer) | Last contact | Action

Rules:
- Action shows FOLLOW UP when Status is Applied and Last contact is 7 or more days ago.
- A summary at the top: applied this week, replies, interviews, reply rate by resume version.
- Then fill rows only from these emails, and leave a cell blank if the email does not say: [PASTE CONFIRMATION EMAILS]
Do not invent companies, dates or contacts.
```

## Guardrails
- What it touches: Chat input you provide (Claude or ChatGPT; Excel or Google Sheets).
- Needs your OK: Send, pay, publish, and account changes stay with you. Treat agent output as drafts first.
- Safety level: Adds sheet rows
- Applying from several sites and missing confirmation emails.
- Following up more than once on the same application.
- Letting the AI mark rows as replied without seeing the reply.

## Tips
- Log the resume version; after 20 applications it shows which one works.
- Three replies is luck, not a pattern. Wait for more data before changing everything.
- Keep follow-ups to one, then move on.

## Estimates (labeled, not measured)
- Time saved: About 20 minutes to set up, then 5 minutes a day.
- Money saved: Not stated in sources.
- Tool cost: Gmail connectors depend on your plan. Prices: Not stated in sources.

## Sources
Summaries use the public sources below, not independent verification.
- Anthropic: https://support.claude.com/en/articles/12111783-create-and-edit-files-with-claude (Create and edit files with Claude: Excel spreadsheets with working formulas; upload CSV and other files for analysis (read 2026-11-02 from a search result excerpt of the page))
- Anthropic: https://support.claude.com/en/articles/10166901-use-google-workspace-connectors (Use Google Workspace connectors: approval before send, reply or forward by default (read 2026-10-31 through a page fetch tool, not a direct browser open))

## Get the free starter pack
Five beginner copy-paste AI setups, free by email: https://www.aisetupsthatwork.com/starter-pack/?utm_source=ai-agent&utm_medium=markdown&utm_campaign=setup-track-job-applications-from-your-inbox

Related:
- [Write a short note to the hiring manager](https://www.aisetupsthatwork.com/setups/write-a-short-note-to-the-hiring-manager/index.md)
- [Get a daily job shortlist with AI](https://www.aisetupsthatwork.com/setups/get-a-daily-job-shortlist-with-ai/index.md)
- [Mock behavioral interview with AI](https://www.aisetupsthatwork.com/setups/mock-behavioral-interview-with-ai/index.md)