Panth1823 This workflow corresponds to n8n.io template #14807 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "25f66b57-e6ca-46d0-b266-6fda14c4da79",
"name": "Main Sticky",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1008,
928
],
"parameters": {
"color": 2,
"width": 500,
"height": 600,
"content": "## Automate Job Link Validation and Deactivation\nMaintain data hygiene by automatically scanning job application URLs and disabling broken links.\n\n### How it works\n1. Schedule scan every three days.\n2. Fetch active jobs from Postgres.\n3. Validate application URLs using HTTP HEAD requests.\n4. Detect 404s and soft-404 redirects.\n5. Update status in Postgres and Google Sheets.\n\n### Setup\n1. Configure Postgres credentials for your job database.\n2. Authenticate the Google Sheets node.\n3. Update the Google Sheets Resource ID and Sheet Name.\n\n### Customization\nAdjust the URL validation logic in the 'Find Dead Jobs' code node to fit specific site behaviors. Consolidate user-specific values in a Set node at the workflow start for easy configuration."
},
"typeVersion": 1
},
{
"id": "bdb3a9c0-5c06-41f8-addf-d30652c2a1cf",
"name": "\u23f0 Every 3 Days",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-400,
1024
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 72
}
]
}
},
"typeVersion": 1.1
},
{
"id": "ccdf01ce-6573-4900-8a8c-e18a29d9caf0",
"name": "\ud83d\udce5 Fetch Active Jobs",
"type": "n8n-nodes-base.postgres",
"position": [
-176,
1024
],
"parameters": {
"query": "SELECT job_hash, apply_url, company, job_title\nFROM jobs\nWHERE status = 'active'\nORDER BY created_at ASC;",
"options": {},
"operation": "executeQuery"
},
"typeVersion": 2.5
},
{
"id": "231bbefa-8309-4c88-9972-9eb18e7a8699",
"name": "\ud83d\udd27 Prepare URLs",
"type": "n8n-nodes-base.code",
"position": [
48,
1024
],
"parameters": {
"jsCode": "// Filter out jobs with empty or invalid URLs\nconst jobs = $input.all();\nconst valid = [];\nconst skipped = [];\n\nfor (const item of jobs) {\n const url = (item.json.apply_url || '').trim();\n if (!url || url.length < 10 || !url.startsWith('http')) {\n skipped.push(item.json.job_title || 'unknown');\n continue;\n }\n valid.push({ json: { ...item.json } });\n}\n\nif (skipped.length > 0) {\n console.log(`\u26a0 Skipped ${skipped.length} jobs with invalid URLs`);\n}\nconsole.log(`\ud83d\udccb Checking ${valid.length} job URLs`);\n\nif (valid.length === 0) {\n return [{ json: { _no_jobs: true } }];\n}\nreturn valid;"
},
"typeVersion": 2
},
{
"id": "dfa1f2cf-de4e-47a6-b53e-3032529f44f3",
"name": "\ud83d\udd17 Check URLs",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
336,
1024
],
"parameters": {
"url": "={{ $json.apply_url }}",
"method": "HEAD",
"options": {
"timeout": 5000,
"batching": {
"batch": {
"batchSize": 5
}
},
"redirect": {
"redirect": {
"maxRedirects": 5
}
},
"response": {
"response": {
"neverError": true,
"fullResponse": true
}
}
}
},
"typeVersion": 4.2
},
{
"id": "da0af420-5cf9-4987-a41f-5a6273e062b3",
"name": "\ud83e\udde0 Find Dead Jobs",
"type": "n8n-nodes-base.code",
"position": [
560,
1024
],
"parameters": {
"jsCode": "const httpItems = $input.all();\nconst cfgItems = $('\ud83d\udd27 Prepare URLs').all();\n\nif (cfgItems.length === 1 && cfgItems[0].json._no_jobs) {\n return [{ json: { _no_dead_jobs: true } }];\n}\n\nconst deadJobs = [];\nlet aliveCount = 0, errorCount = 0;\n\nfor (let i = 0; i < httpItems.length; i++) {\n const http = httpItems[i].json;\n const job = cfgItems[i]?.json || {};\n if (!job.job_hash) continue;\n\n const statusCode = http.statusCode || http.status || null;\n \n // FIX 1: Properly stringify error objects\n const errMsg = JSON.stringify(http.error || http.message || '').toLowerCase();\n\n let isDead = false;\n let reason = '';\n\n if (errMsg.includes('enotfound') || errMsg.includes('getaddrinfo')) {\n isDead = true; reason = 'DNS_FAIL';\n } else if (errMsg.includes('econnrefused')) {\n isDead = true; reason = 'CONN_REFUSED';\n } else if (statusCode === 404 || statusCode === 410) {\n isDead = true; reason = `HTTP_${statusCode}`;\n } \n // FIX 2: Detect soft-404s \u2014 redirect to a DIFFERENT path = job removed\n else if ((statusCode === 301 || statusCode === 302 || statusCode === 307) && http.headers?.location) {\n const originalPath = new URL(job.apply_url).pathname;\n const redirectPath = new URL(http.headers.location, job.apply_url).pathname;\n // If redirected away from the job-specific path (e.g. to /jobs), it's dead\n if (!redirectPath.includes(originalPath) && (\n redirectPath.endsWith('/jobs') || \n redirectPath.endsWith('/careers') ||\n redirectPath === '/'\n )) {\n isDead = true; reason = `SOFT_404_REDIRECT`;\n } else {\n aliveCount++;\n }\n } else if (http.error) {\n errorCount++; // transient error, keep alive\n } else {\n aliveCount++;\n }\n\n if (isDead) {\n console.log(`\ud83d\udc80 DEAD [${reason}]: ${job.company} | ${job.job_title}`);\n deadJobs.push(job);\n }\n}\n\nconsole.log(`\u2705 Alive: ${aliveCount} | \ud83d\udc80 Dead: ${deadJobs.length} | \u26a0 Errors: ${errorCount}`);\n\nif (deadJobs.length === 0) {\n return [{ json: { _no_dead_jobs: true, alive: aliveCount, errors: errorCount } }];\n}\nreturn deadJobs.map(j => ({ json: j }));"
},
"typeVersion": 2
},
{
"id": "4d8a38a1-3997-4d64-833b-5cdc4fcc4201",
"name": "\ud83d\udd00 Has Dead Jobs?",
"type": "n8n-nodes-base.if",
"position": [
784,
1024
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "has-dead",
"operator": {
"type": "boolean",
"operation": "notEquals"
},
"leftValue": "={{ $json._no_dead_jobs }}",
"rightValue": true
}
]
}
},
"typeVersion": 2
},
{
"id": "66889612-c524-4449-a53a-b38610721464",
"name": "\u274c Mark Inactive (Supabase)",
"type": "n8n-nodes-base.postgres",
"onError": "continueRegularOutput",
"position": [
1136,
1008
],
"parameters": {
"query": "UPDATE jobs SET status = 'inactive' WHERE job_hash = '{{ $json.job_hash }}';",
"options": {},
"operation": "executeQuery"
},
"typeVersion": 2.5
},
{
"id": "46febd75-2c67-49af-8cd4-fd94e05702e4",
"name": "\ud83d\udcca Mark Inactive (Google Sheet)",
"type": "n8n-nodes-base.googleSheets",
"position": [
1344,
1008
],
"parameters": {
"columns": {
"value": {
"job_hash": "={{json.job_hash }}"
},
"schema": [
{
"id": "job_hash",
"type": "string",
"display": true,
"required": false,
"displayName": "job_hash",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Job Title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Job Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Work Mode",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Work Mode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Employment Type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Employment Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Apply URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Apply URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ATS",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ATS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Salary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Salary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "success",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "success",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"job_hash"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "YOUR_RESOURCE_ID_HERE"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_RESOURCE_ID_HERE"
}
},
"typeVersion": 4
},
{
"id": "6edee8a0-b285-4b4a-a00f-14b3c0ebffb9",
"name": "Section 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-448,
928
],
"parameters": {
"color": 7,
"width": 668,
"height": 280,
"content": "## 1. Trigger & Extraction\nSchedule the automated run and retrieve active job records from your PostgreSQL database."
},
"typeVersion": 1
},
{
"id": "5a302e63-b98f-46b6-bc74-03cb43f4fb0e",
"name": "Section 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
288,
928
],
"parameters": {
"color": 7,
"width": 668,
"height": 280,
"content": "## 2. Validation & Processing\nFilter invalid URLs, perform connectivity checks, and identify dead links using custom JavaScript logic."
},
"typeVersion": 1
},
{
"id": "4cdeee6d-e149-41a1-9bb6-cea773db9311",
"name": "Section 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1024,
928
],
"parameters": {
"color": 7,
"width": 600,
"height": 280,
"content": "## 3. Reporting & Sync\nUpdate the status of verified dead jobs in both the source database and the reporting spreadsheet."
},
"typeVersion": 1
}
],
"connections": {
"\ud83d\udd17 Check URLs": {
"main": [
[
{
"node": "\ud83e\udde0 Find Dead Jobs",
"type": "main",
"index": 0
}
]
]
},
"\u23f0 Every 3 Days": {
"main": [
[
{
"node": "\ud83d\udce5 Fetch Active Jobs",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udd27 Prepare URLs": {
"main": [
[
{
"node": "\ud83d\udd17 Check URLs",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udd00 Has Dead Jobs?": {
"main": [
[
{
"node": "\u274c Mark Inactive (Supabase)",
"type": "main",
"index": 0
}
]
]
},
"\ud83e\udde0 Find Dead Jobs": {
"main": [
[
{
"node": "\ud83d\udd00 Has Dead Jobs?",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udce5 Fetch Active Jobs": {
"main": [
[
{
"node": "\ud83d\udd27 Prepare URLs",
"type": "main",
"index": 0
}
]
]
},
"\u274c Mark Inactive (Supabase)": {
"main": [
[
{
"node": "\ud83d\udcca Mark Inactive (Google Sheet)",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Keep your job listings database clean without manual checks. Every three days, this workflow fetches all active jobs from your Postgres database, runs each application URL through a validation check, identifies dead links via HTTP status codes and soft-404 redirect detection,…
Source: https://n8n.io/workflows/14807/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow monitors customer health by combining payment behavior, complaint signals, and AI-driven feedback analysis. It runs on daily and weekly schedules to evaluate risk levels, escalate high-r
Google Sheets, HTTP Request, Gmail +2
Code Postgres. Uses httpRequest, splitInBatches, postgres, hubspot. Scheduled trigger; 23 nodes.
HTTP Request, Postgres, HubSpot +1
Continuous monitoring: Real-time surveillance of supplier performance, financial health, and operational status Risk scoring: AI-powered assessment of supplier risks across multiple dimensions (financ
Postgres, HTTP Request, Gmail +1
Regulatory monitoring: Continuously tracks changes in laws, regulations, and compliance requirements across multiple jurisdictions Contract analysis: AI-powered review of existing contracts to identif
HTTP Request, Postgres, Gmail +1
Stop manually checking dozens of career pages. This workflow runs every morning, hits the public APIs of 8+ ATS platforms and job boards, normalizes every listing into a single clean schema, and syncs
HTTP Request, Postgres, Google Sheets