See llms.txt for all machine-readable content.

Back to Templates

Track new Workday job postings in Google Sheets using Apify

Created by

Created by: glitchbound || glitchbound
glitchbound

Last update

Last update 8 hours ago

Categories

Quick overview

This workflow runs every morning, uses Apify’s Workday Jobs Scraper to collect job postings for selected companies and keywords, and appends only newly discovered postings to a Google Sheets spreadsheet.

How it works

  1. Runs every morning on a schedule.
  2. Defines the target companies or Workday boards plus title/location keyword filters and a per-company result limit.
  3. Calls Apify (Workday Jobs Scraper actor) to fetch matching Workday job postings.
  4. Stops the workflow with an error message if the scraper returns an error record.
  5. Deduplicates postings across executions using the board URL and job ID (or the job URL) so only newly seen jobs continue.
  6. Formats each new posting into spreadsheet columns (title, company, location, country, work arrangement, posted date, job URL and the date it was found).
  7. Appends the formatted rows to Google Sheets, trying up to three times if the sheet step fails.

Setup

  1. Install the community node @apify/n8n-nodes-apify and add an Apify connection using your Apify API token.
  2. Add Google Sheets OAuth credentials and select the target spreadsheet and sheet tab in the Google Sheets append step.
  3. Set Google Sheets column mapping to "Map Automatically" so the incoming fields are appended correctly. n8n resets it to manual when you pick a sheet. Headers are written on the first run.
  4. Update the companies/boards and optional keyword filters and max results values to match what you want to track.
  5. Adjust the schedule time if needed, then run once to verify the output before activating the workflow.

Requirements

  • An Apify account (the free plan works) and the Apify community node
  • A Google account for Google Sheets

Customization

  • Change the schedule, add columns in Format rows, or send new rows to Slack or email.

Additional info

Every run returns and bills all matching open jobs, including ones already in the sheet (about $0.002 each on the Apify free plan; filtered-out rows are free), so keep the keywords and limit tight. Closed jobs stay in the sheet.