Scrape LinkedIn job listings with Phantombuster & save to Google Sheets

How it works This workflow automatically scrapes LinkedIn job postings for a list of target companies and organizes the results in Google Sheets. Every Monday morning, it checks your company list, runs a LinkedIn job scrape using Phantombuster, waits for the data to be ready, and then fetches the results. Finally, it formats the job postings into a clean structure and saves them into a results sheet for easy analysis.

Step-by-step

Start with Scheduled Trigger - The workflow runs automatically at 9:00 AM every Monday. - It reads your “Companies Sheet” in Google Sheets and filters only those marked with Status = Pending.

Scrape LinkedIn Jobs - The workflow launches your Phantombuster agent with the LinkedIn profile URLs from the sheet. - It waits 3 minutes to let the scraper finish running. - Then it fetches the output CSV link containing the job posting results.

Format the Data - The scraped data is cleaned and structured into fields like:

- Company Name

- Job Title

- Job Description