Scrape LinkedIn Jobs with Phantombuster & Save to Google Sheets

This n8n workflow automates the extraction of LinkedIn job postings from a predefined list of target companies. Triggered every Monday at 9:00 AM, it reads a 'Companies Sheet' in Google Sheets, filters for pending statuses, and launches Phantombuster to scrape job data from LinkedIn profiles. After a 3-minute wait for completion, it retrieves the CSV output, cleans and structures the data into key fields like company name, job title, description, link, date posted, location, and employment type, then appends it to a 'Job Results' sheet with a scrape timestamp.

The step-by-step process ensures reliability: starting with a schedule trigger, it fetches company URLs, initiates the Phantombuster agent per company, polls for results, processes raw scraped data via formatting nodes, and finally updates the output sheet. This handles multiple companies efficiently without manual intervention.

Ideal for HR teams, recruiters, and market analysts, it enables competitive hiring intelligence, job market trend tracking, and structured data collection at scale. Benefits include time savings on manual scraping, organized results for sharing and reporting, and automated scheduling to stay ahead of competitors' hiring activities. No coding required beyond setup, making it accessible yet powerful for business automation.