Scrape LinkedIn job listings with ScrapeUnblocker and Google Sheets

Quick Overview

This workflow runs every 8 hours to scrape LinkedIn job search results for a chosen keyword and location using ScrapeUnblocker, then parses job details and appends them to a Google Sheets spreadsheet.

How it works

1. Runs every 8 hours on a schedule.
2. Sets the job search keyword and location, then builds encoded search URLs for LinkedIn and Indeed.
3. Filters the generated URLs to continue only with the LinkedIn search.
4. Fetches the LinkedIn job search results HTML using ScrapeUnblocker.
5. Extracts job postings from the HTML (job ID, title, company, location, post date, and URL), deduplicates by job ID, and stamps each item with the scrape time.
6. Appends each parsed job listing as a new row in Google Sheets.

Setup

1. Add ScrapeUnblocker credentials (or configure the ScrapeUnblocker node authentication required by your account).
2. Connect Google Sheets OAuth credentials and select the target spreadsheet and sheet tab used for output.
3. Ensure the sheet has columns for Job ID, Title, Company, Location, Post Date, Source, URL, and Date Scraped, and update the keyword and location values to match your search.