Opportunity Pipeline Tracker
Automation & Analytics Dashboard
The Problem
Job seeker was managing 50+ job applications across multiple platforms (LinkedIn, Wellfound, Built-In, Welcome to the Jungle) while tracking stages, compensation ranges, and company details were creating cognitive overhead and risking missed follow-ups.
Built an end-to-end job application tracking system combining workflow automation with a real-time analytics dashboard.
Email arrives → Zapier triggers → AI parses content → Notion row created → Dashboard update
Automation Pipeline (Zapier)
Gmail trigger captures application confirmation emails automatically
AI parsing layer extracts role, company, compensation range, and location from unstructured email content
Data flows directly into a Notion database with no manual entry required
Analytics Dashboard (React/Antigravity)
Real-time metrics: Total applications, pending responses, rejections, interviews
Application velocity tracking (submissions per week)
Pipeline visualization by stage
Source performance analysis (which platforms yield results)
Role distribution breakdown
Individual application detail views with company research links
The Solution
The Impact
Eliminated manual data entry for new applications
Created single source of truth across 5+ job platforms
Enabled data-driven job search strategy through analytics
Reduced time spent on application tracking by ~80%
Tools & Skills
Zapier with AI by Zapier (GPT-4o mini) for email parsing
Notion as the central database
React dashboard with data visualization
Gmail API integration via label-based triggers