Recruitment Tracker — Medha Ojha

Problem & Solution

Before · 2+ hours/day

✕Manual company research per role — 20 minutes each

✕Rewriting CV for every JD from scratch — 45 minutes

✕No centralised tracking — roles lost across browser tabs

✕No salary benchmark before entering conversations

✕Generic CV sent regardless of role or company context

→

After Recruitment Tracker · 10 min/day

✓AI company brief auto-generated on shortlist — 30 seconds

✓JD-tailored CV saved to Google Drive — 60 seconds

✓Pipeline view — New → Shortlisted → Applied → Interview

✓Salary estimate surfaced before the first conversation

✓CV rewritten around top 3 JD themes by Claude API

The Solution — 3 Layers

1

Discovery

Automated Job Sourcing

LinkedIn alert emails parsed twice daily via Google Apps Script. Extracts title, company, location, and alumni count — deduplicated across 8 searches. 15–21 roles sourced daily, zero manual effort.

2

Intelligence

AI Research Assistant

On shortlist, Claude API generates a 4-point company brief: product overview, funding stage, recent news, culture signal and salary estimate. Replaces 20 minutes of manual research per role.

3

Application

CV Modifier

Claude reads the JD, identifies its top 3 themes, and rewrites CV bullets to foreground the most relevant experience — without fabrication. Formatted Google Doc delivered in 60 seconds.

Workflow

📧 1

Alert Email
Arrives

LinkedIn
job alert

⚙️ 2

Auto-Parsed
& Stored

Apps Script
+ Sheets

📊 3

Review in
Dashboard

Lovable
web app

⭐ 4

Shortlist
a Role

One click
triggers AI

🤖 5

Company Intel
Generated

Claude API
30 seconds

📄 6

CV Tailored
to Drive

Google Docs
60 seconds

Automated steps — no user input required

User decision point — human in the loop

AI-powered output — Claude API

How It Was Built

Layer	Tool	Rationale
Backend	Google Apps Script	Free, serverless, runs on Google's infrastructure
Data source	LinkedIn Email Alerts	Safe — no scraping, zero account risk
Database	Google Sheets	Free, auditable, API-accessible
Intelligence	Claude API (Sonnet)	Company intel + CV tailoring via prompts
Frontend	Lovable	No-code React, built via conversational prompting
CV output	Google Drive Docs	Formatted, downloadable as Word instantly

Results

15–21

roles sourced
per day

30s

company intel
generated

60s

tailored CV
to Drive

~$10

cost
per month

Key Product Decisions

Decision 01

Email parsing over direct scraping

LinkedIn blocks scrapers and risks account bans. Parsing alert emails is safe, legal, and reliable — with an accepted tradeoff of 6 roles per email vs 30+ in the full search.

Decision 02

Human-in-the-loop shortlisting

System surfaces roles but never auto-applies. Every shortlist decision stays with the user — quality of application matters more than volume at MBA recruiting level.

Decision 03

On-demand intel, not batch enrichment

Claude API fires only on shortlisted roles (~$0.02/company) vs all 21 daily roles (~$0.42/day). Cost and analytical attention aligned to actual intent.

Decision 04

Google Docs over spreadsheet cells

Initial CVs stored as text in Sheets — unusable in practice. Switched to formatted Google Docs per tailored CV, downloadable as Word instantly. Small change, significant UX lift.

Honest Tradeoffs & V2 Plan

V1 — Current Limitations

⚠Gmail dependency — fragile if LinkedIn changes email format

⚠Google Sheets — 10MB cap, limited query capability

⚠6 roles per email vs 30+ in full LinkedIn search results

⚠CV formatting requires minor manual cleanup post-generation

V2 — Proper Engineering Stack

→Puppeteer scraper — direct LinkedIn access, no email dependency

→Supabase (PostgreSQL) — real database with indexed queries

→Full search result ingestion, not just email previews

→Automated PDF generation with precise, consistent formatting