LinkedIn Job Alert Automation

The problem

Recruiters were searching LinkedIn every morning, copying job posts into a spreadsheet by hand, and sending them to candidates. Slow, repetitive, and easy to get wrong.

What I built

An n8n workflow triggered by a webhook. A request like this starts it:

{ "jobTitle": "Python Developer", "location": "Remote", "limit": 20 }

Steps

1. Trigger Apify actor — an HTTP POST starts the LinkedIn Jobs Scraper with the keyword, location, “last 24 hours” filter, and company enrichment.
2. Check run status — an HTTP GET reads the run. An If node checks for FAILED and returns a clear error message. Another If node checks for SUCCEEDED; if not yet, a Wait 30 seconds node loops back.
3. Retrieve dataset — once finished, the results are fetched with the requested limit.
4. Process job data — a Set node maps title, company, location, posted time, job URL, and company URL. A small JavaScript expression scans the description for remote, hybrid, or on-site and labels the row.
5. Append to Google Sheets — one row per job.
6. AI summary — a Code node counts top companies, locations, and work types. An AI Agent turns that into a short JSON summary (common hiring companies, common locations, hiring trends). A second Code node parses the JSON safely and appends it to a Summary sheet.

Result

One HTTP call replaces the whole morning routine. The sheet contains fresh listings with clean columns, and the summary tab gives a two-line picture of the market for that search.