Built this workflow because job hunting across several different platforms was genuinely exhausting. Every platform has its own filters, its own layout, and no easy way to compare roles side by side.

What it does:

I feed the workflow a job title or set of keywords. It then pulls active listings from LinkedIn, Indeed, Upwork, and Wellfound. Each job gets written to a structured Google Sheet with 9 fields: title, company, platform, direct link, salary, location, rating, description, and a custom cover letter.

The cover letter piece is where Google Gemini API comes in. Every scraped job triggers an LLM step that reads the job description and generates a role-specific cover letter tailored to my background. So instead of writing a fresh letter for every application, I get one pre-drafted per job that I can then tweak in under 2 minutes.

Impact on my own workflow:

Per-application prep time dropped from around 20 minutes to under 2 minutes. Central Google Sheet became my single source of truth across all platforms. Made it possible to actually apply to 30+ roles a week without burning out.

Why I built it this way:

I could have hardcoded a template for the cover letter. I chose the LLM path because generic cover letters get ignored, and I wanted something that actually referenced each job description. Small tradeoff on cost per run, big tradeoff on response rate. Turned out to be the right call.

Tech: n8n, Google Gemini API, Apify APIs, LLM integration, Google Sheets