← ClaudeAtlas

new-joblisted

This skill should be used when the user wants to add a new company or job to their Excel tracker (List.xlsx). Triggers on phrases like "add [company] to tracker", "I applied to [company]", "track [company]", "save [company] for later", "add [company] [role]", "new application at [company]".
Mahashwetha/Job-search-email-system-claude · ★ 5 · Data & Documents · score 75
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.