n8n ATS Job Feed Workflow: Greenhouse & Workday to Slack
Copy or download the complete n8n workflow JSON below and paste it directly onto your n8n canvas (Cmd/Ctrl+V). Polls GET /v1/feeds/new every hour across 434 ATS connectors, filters out staffing agencies, and routes Engineering & Sales hiring triggers to Slack and PostgreSQL.
Ready-to-Import n8n v1 Workflow JSON (SSR Verified)
Schedule Trigger → /v1/feeds/new → Filter Roles → Slack + Postgres
Paste directly onto any n8n canvas (Cmd+V / Ctrl+V) or import via Workflows → Import from File. Requires JOBPOSTINGS_API_KEY (claim 1,500 Free Credits) and SLACK_INCOMING_WEBHOOK_URL.
{
"name": "JobPostings API — Hourly ATS Job Feed (Greenhouse & Workday) to Slack + Postgres",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 1
}
]
}
},
"id": "b1f20c10-1001-4a20-9c01-000000000001",
"name": "Hourly Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
220,
320
]
},
{
"parameters": {
"method": "GET",
"url": "https://api.jobpostingsapi.com/v1/feeds/new",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "since",
"value": "1h"
},
{
"name": "country",
"value": "US"
},
{
"name": "limit",
"value": "50"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-api-key",
"value": "={{ $env.JOBPOSTINGS_API_KEY }}"
}
]
},
"options": {
"timeout": 20000
}
},
"id": "b1f20c10-1002-4a20-9c01-000000000002",
"name": "Fetch New ATS Jobs (/v1/feeds/new)",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
460,
320
]
},
{
"parameters": {
"jsCode": "const events = $input.first()?.json?.data ?? [];\nconst targetPattern = /engineer|platform|security|data|ai|machine learning|sales|account executive|revops/i;\nconst matched = [];\n\nfor (const ev of events) {\n const job = ev.job || ev;\n if (!job || !job.id) continue;\n // Exclude external staffing/recruiting agencies so alerts reflect direct employer headcount\n if (job.company?.is_staffing_agency === true) continue;\n const haystack = `${job.title || ''} ${job.department || ''} ${job.job_function || ''}`;\n if (!targetPattern.test(haystack)) continue;\n\n const sal = job.salary;\n const salaryLabel = sal?.annual_usd_min && sal?.annual_usd_max\n ? `$${Math.round(sal.annual_usd_min / 1000)}k–$${Math.round(sal.annual_usd_max / 1000)}k USD`\n : 'Undisclosed';\n\n matched.push({\n json: {\n job_id: job.id,\n event_at: ev.at || job.posted_at,\n title: job.title,\n company_name: job.company?.name || 'Unknown',\n company_domain: job.company?.domain || null,\n department: job.department || job.job_function || 'General',\n ats_source: job.source?.name || 'ats',\n ats_board: job.source?.board || null,\n work_arrangement: job.work_arrangement || 'unspecified',\n location_raw: job.location?.raw || job.location?.country || 'US',\n salary_label: salaryLabel,\n skills_csv: Array.isArray(job.skills) ? job.skills.slice(0, 8).join(', ') : '',\n apply_url: job.apply_url || job.url,\n },\n });\n}\n\nreturn matched;"
},
"id": "b1f20c10-1003-4a20-9c01-000000000003",
"name": "Filter Engineering & Sales Roles",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
700,
320
]
},
{
"parameters": {
"method": "POST",
"url": "={{ $env.SLACK_INCOMING_WEBHOOK_URL }}",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"text\": \"New ATS Hiring Signal: *\" + $json.company_name + \"* (\" + ($json.company_domain || $json.ats_source) + \") opened *\" + $json.title + \"*\\n• Team: \" + $json.department + \" | ATS: `\" + $json.ats_source + \"` | Mode: \" + $json.work_arrangement + \" | Pay: \" + $json.salary_label + \"\\n• Skills: \" + ($json.skills_csv || \"n/a\") + \"\\n• Direct Apply: \" + $json.apply_url\n}",
"options": {}
},
"id": "b1f20c10-1004-4a20-9c01-000000000004",
"name": "Post Hiring Signal to Slack",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
960,
220
]
},
{
"parameters": {
"operation": "executeQuery",
"query": "INSERT INTO ats_hiring_signals (job_id, company_name, company_domain, title, department, ats_source, work_arrangement, salary_label, apply_url, discovered_at)\nVALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)\nON CONFLICT (job_id) DO UPDATE SET\n title = EXCLUDED.title,\n department = EXCLUDED.department,\n salary_label = EXCLUDED.salary_label;",
"options": {
"queryReplacement": "={{ [$json.job_id, $json.company_name, $json.company_domain, $json.title, $json.department, $json.ats_source, $json.work_arrangement, $json.salary_label, $json.apply_url, $json.event_at] }}"
}
},
"id": "b1f20c10-1005-4a20-9c01-000000000005",
"name": "Upsert Requisition to Postgres",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.5,
"position": [
960,
420
]
}
],
"connections": {
"Hourly Schedule Trigger": {
"main": [
[
{
"node": "Fetch New ATS Jobs (/v1/feeds/new)",
"type": "main",
"index": 0
}
]
]
},
"Fetch New ATS Jobs (/v1/feeds/new)": {
"main": [
[
{
"node": "Filter Engineering & Sales Roles",
"type": "main",
"index": 0
}
]
]
},
"Filter Engineering & Sales Roles": {
"main": [
[
{
"node": "Post Hiring Signal to Slack",
"type": "main",
"index": 0
},
{
"node": "Upsert Requisition to Postgres",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
}
}Engineering Highlights & Credit Safeguards
- →1-paste n8n canvas import: copy the SSR-rendered n8n workflow JSON below and press Cmd+V / Ctrl+V inside any self-hosted or n8n Cloud workspace.
- →Zero browser scrapers or per-board webhooks: a single HTTP Request node against GET /v1/feeds/new streams newly discovered Greenhouse, Workday, Lever, Ashby, iCIMS, and SmartRecruiters postings.
- →Built-in signal hygiene: the included n8n JavaScript Code node strips external staffing agencies (company.is_staffing_agency === true) and formats annualized USD salary ranges.
- →Idempotent storage: parallel branches post instant rich alerts to Slack while upserting job_id into PostgreSQL with ON CONFLICT DO UPDATE.
1. Node-by-Node n8n Pipeline Architecture & Environment Variables
This 5-node workflow is engineered for unattended 24/7 RevOps and recruiting operations with deterministic deduplication and sub-50ms cached feed polling:
| Step / Node Name | n8n Node Type | Configuration & Endpoint | Credit & Error Behavior |
|---|---|---|---|
| 1. Hourly Schedule Trigger | n8n-nodes-base.scheduleTrigger | Runs every 1 hour (configurable to 15m for high-velocity SDR pods) | 0 Credits (local n8n scheduler) |
| 2. Fetch New ATS Jobs | n8n-nodes-base.httpRequest | GET https://api.jobpostingsapi.com/v1/feeds/new?since=1h&country=US&limit=50 | 1 Credit/event ($0.0002–$0.00076); 0 Credits if 0 new jobs |
| 3. Filter Engineering & Sales | n8n-nodes-base.code (JS v2) | Unpacks ev.job, drops is_staffing_agency=true, matches target departments/titles | Normalizes annual_usd_min/max & top 8 skills |
| 4. Post Hiring Signal to Slack | n8n-nodes-base.httpRequest | POST $env.SLACK_INCOMING_WEBHOOK_URL with company, department, ATS & apply_url | Instant channel alert with direct ATS link |
| 5. Upsert Requisition to Postgres | n8n-nodes-base.postgres | INSERT ... ON CONFLICT (job_id) DO UPDATE into ats_hiring_signals | Guarantees zero duplicate rows across overlapping windows |
2. PostgreSQL Destination Table DDL & Required n8n Variables
Set JOBPOSTINGS_API_KEY and SLACK_INCOMING_WEBHOOK_URL in your n8n environment (or Credentials store), and create the target Postgres table once:
PostgreSQL Target Table Schema (ats_hiring_signals)
CREATE TABLE IF NOT EXISTS ats_hiring_signals (
job_id TEXT PRIMARY KEY,
company_name TEXT NOT NULL,
company_domain TEXT,
title TEXT NOT NULL,
department TEXT,
ats_source TEXT NOT NULL,
work_arrangement TEXT,
salary_label TEXT,
apply_url TEXT,
discovered_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE INDEX IF NOT EXISTS idx_ats_hiring_signals_domain
ON ats_hiring_signals (company_domain, discovered_at DESC);- Filter by Specific ATS Connectors (Greenhouse, Workday, Lever, Ashby): Want only enterprise Workday or high-growth Ashby/Greenhouse openings? Add query parameter source=workday or source=greenhouse inside Node 2 ('Fetch New ATS Jobs').
- Track Closed or Modified Requisitions in Parallel: Clone Node 2 to poll GET /v1/feeds/updated (salary/location revisions) or GET /v1/feeds/closed (verified delisted jobs) to keep downstream job boards and CRM stages accurate.
- Forward Matched Domains into Clay Account Tables: Replace or supplement the Slack webhook URL with a Clay Table Webhook URL, or enrich existing account lists directly with our Clay HTTP API Column Builder (/integrations/clay-job-postings-hiring-signals).
Frequently Asked Questions
- How do I import this JSON workflow into n8n Cloud or self-hosted n8n?
- Click 'Copy Workflow JSON' at the top of this page, open any workflow canvas in n8n (v1.20+), and press Cmd+V (macOS) or Ctrl+V (Windows/Linux)—or click the workflow menu '...' -> 'Import from File' and select the downloaded .json file.
- Which plans unlock GET /v1/feeds/new for 24/7 n8n polling?
- You can test GET /v1/feeds/new immediately with your 1,500 Free Credits ($1.50) upon signup. For continuous production polling, /v1/feeds/* streams are unlocked on Growth ($49/mo, 180 RPM), Pro ($99/mo, 300 RPM), Scale ($199/mo, 600 RPM), and non-expiring PAYG packs ($25+). Starter ($19/mo) users can also poll GET /v1/jobs/search?posted_after=1h.
- What happens if an hourly n8n run finds 0 new matching jobs?
- When GET /v1/feeds/new returns an empty data: [] array, 0 Credits are deducted, and the downstream Filter Code node outputs 0 items so Slack and Postgres are not triggered.
Related Endpoints & Workflow Connectors
Other Connector · Clay HTTP API
Clay Hiring Intent Signals: Enrich Open ATS Jobs by Domain
From $0.20/1K ($0.0002~$0.00076/call) · 0 Clay credits · $0 on empty →
Other Connector · LangChain & CrewAI
LangChain & CrewAI Job Search Tool for Real-Time ATS Data
1 Credit / job ($0.20–$0.76/1K) · 0 Credits on 0 matches →
Instant API Key · Zero Credit Card Required
Test this n8n Workflow JSON connector free with 1,500 Credits ($1.50).
Includes 60 RPM / 5 RPS throughput, +2,000 Sandbox Streak bonus credits ($3.50 total free testing), and automatic 0-credit protection whenever a search returns 0 jobs.