new-joblisted
Install: claude install-skill Mahashwetha/Job-search-email-system-claude
# Add New Job to Tracker
Add a new row to `List.xlsx` (the job application tracker at the path in `config.py → TRACKER_FILE`).
## Column layout
- A: Company name
- B: Role title
- C: Role link (job posting URL)
- D: Status
- E: HR contact (leave empty)
- F: Comments (leave empty)
## Status values
- Default (applied): `done`
- Save for later / not yet applied: `In progress`
If the user doesn't specify, use `done`.
## Steps
1. Ask the user for any missing info: company name (required), role title, job URL. If they provided it already, skip asking.
2. Open `List.xlsx` using openpyxl. Handle `PermissionError` by working from a temp copy.
3. Use the first sheet (`wb.active` at load time — read it before any writes to avoid sheet-shift bugs).
4. Append the new row at the bottom: Company, Role, URL, Status, empty, empty.
5. Save the file.
6. Confirm to the user: company name, role, status, and which row it was added to.
## Things to check
- If the company already exists in the tracker, mention it and ask if they still want to add a new row (they may have a different role).
- Leave columns E and F empty — HR contacts are managed separately via the update-hr workflow.