Pain Point

Job hunting is intense and stressful due to how highly competitive it is.
Even getting past the ATS (Applicant Tracking System) is a major hurdle.

Solution

One of the best ways to increase your chances:

Apply as soon as a job is posted — be among the first applicants
Focus on quality over quantity
Tailor your resume to match each job post, using the right keywords to beat the ATS and get seen

Tools Used

Apify – to scrape job posts from LinkedIn
Zapier – to send scraped jobs into Google Sheets automatically
Google Sheets – to review, track applications, and store insights
ChatGPT – to extract 5–10 relevant keywords per job post (based on the job description) to help tailor the resume

AI in action!

How I built and automated my Job Tracker with AI

Scrape Jobs from LinkedIn in Real-Time
To avoid missing new opportunities, I used the LinkedIn Jobs Scraper on Apify.
It lets me define filters such as job title, location, job type, and posting time (for e.g., last 24 hours).
Once configured, the scraper pulled in targeted roles like “Project Manager Internships in France.”
Auto-Populate into Google Sheets with Zapier
To streamline the review process, I connected Apify to Zapier, which automatically transferred the scraped jobs into a Google Sheet.
Each row includes key info like:
Job title, location, post date, company name, description, and direct LinkedIn URL.
Enrich with AI-Powered Keyword Insights
To improve resume targeting, I used ChatGPT to analyze job descriptions and extract 5–10 high-impact keywords.
These keywords were added to a dedicated column in the spreadsheet to guide resume customization and boost ATS performance.
Manage Everything in One Place
The final tracker served as an all-in-one dashboard to:
- Track application status
- Monitor job categories, industries, and seniority levels
- Prioritize roles based on relevance and timing
- Tailor resumes using extracted keywords

Impact

Saved at least 3–4 hours/day on manual job searching
Increased personalization of applications without added efforts
Helped stay consistent, organized, and apply earlier
Boosted chances of getting through the ATS system

AI-Powered Internship Application Tracker