See llms.txt for all machine-readable content.

Back to Templates

Track target company job postings with Apify and Google Sheets

Created by

Created by: rafi siddiq || rsiddiq
rafi siddiq

Last update

Last update 6 hours ago

Categories

Quick overview

This workflow runs every Monday and uses Apify to scrape open roles from Workday, Greenhouse, Lever, Ashby, and similar career pages for a list of target companies, then appends or updates matching rows in Google Sheets to keep a job tracker current.

How it works

  1. Runs every Monday at 9:00 based on the schedule trigger.
  2. Defines the target company career-page URLs (or slugs), plus optional title keywords and location filters.
  3. Calls the Apify “career-pages-jobs-scraper” actor to fetch matching open job postings from the configured sources.
  4. Filters the Apify results to keep only items that represent actual job postings.
  5. Maps each job into the target Google Sheets columns (company, title, department, location, remote, salary, posted date, job URL, and a “last seen” date).
  6. Appends new rows or updates existing rows in Google Sheets by matching on the “Job link” value.

Setup

  1. Create an Apify account, generate an API token, and add an HTTP Header Auth credential with Authorization: Bearer <your Apify token> for the Apify request.
  2. Connect your Google Sheets account in n8n and set the target spreadsheet URL/ID and sheet tab in the Google Sheets node.
  3. Create a sheet with headers: Company, Title, Department, Location, Remote, Salary, Posted, Job link, Last seen. After picking the tab, n8n resets the mapping: set Mapping Column Mode back to Map Automatically and Column to match on to “Job link”.
  4. Edit the company list and the keywords/locations arrays to match the roles and geographies you want to track.

Requirements

  • An Apify account (the free plan's monthly credit covers small company lists; the jobs Actor costs about $5 per 1,000 jobs) and a Google account with Google Sheets.

Customization

  • Swap Google Sheets for Slack, email, Airtable or a CRM, change the schedule, or add filters the Actor supports (departments, exclude keywords, remote only, posted since).

Additional info

One run must finish within 5 minutes (Apify's limit for a synchronous call), which covers a few hundred matching jobs; keep keywords specific or split large company lists across workflows. Tested on n8n 2.46.6. Disclosure: I built the Apify Actor this template uses.