{"product_id":"automate-broken-job-link-checks-with-postgres-google-sheets","title":"Automate Broken Job Link Checks with Postgres \u0026 Google Sheets","description":"\u003ch3\u003eAutomate Broken Job Link Checks with Postgres \u0026amp; Google Sheets\u003c\/h3\u003e\n\n\u003cp\u003eStop manually checking hundreds of job application URLs for broken links. This n8n workflow automatically validates your job listings every three days, identifies dead or redirected apply links, and marks inactive jobs in both your Postgres database and Google Sheets—keeping your job board clean without user complaints.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eEvery 72 hours, the automated process fetches all active jobs from your Supabase (Postgres) database and systematically validates each application URL. The workflow sends HTTP HEAD requests to check link status, then uses intelligent detection to identify failed jobs through multiple signals:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eHTTP status codes (404, 410 errors)\u003c\/li\u003e\n\u003cli\u003eDNS resolution failures and connection refused errors\u003c\/li\u003e\n\u003cli\u003eSoft-404 detection via redirect analysis—catching when job URLs redirect to different paths, indicating removed positions\u003c\/li\u003e\n\u003cli\u003eMalformed or missing URL filtering before validation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eWhen dead links are discovered, the workflow simultaneously updates your Supabase database and Google Sheets, marking jobs as inactive through parallel processing for maximum efficiency.\u003c\/p\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eJob aggregators:\u003c\/strong\u003e Automatically clean scraped job listings from multiple ATS systems\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCareer platforms:\u003c\/strong\u003e Maintain high-quality job databases without manual link checking\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInternal hiring trackers:\u003c\/strong\u003e Keep recruitment dashboards accurate with working application links\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHR teams:\u003c\/strong\u003e Prevent candidate frustration from broken job application URLs\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cp\u003eBuilt with essential n8n nodes including Schedule Trigger for automated 3-day intervals, Postgres integration for Supabase database queries, HTTP Request nodes for link validation, custom Code node for dead link detection logic, conditional IF nodes for workflow routing, and Google Sheets integration for spreadsheet synchronization.\u003c\/p\u003e\n\n\u003cp\u003ePerfect for teams managing job listings in Postgres who need reliable broken link detection and dual-platform updates without waiting for user reports or performing manual audits.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45494797238451,"sku":"N8N-14995","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Mt-mu0w5vZkf0EA0wV0GO_5497c5fc077641f7a8452091c6598778.jpg?v=1778144930","url":"https:\/\/buyflowscripts.com\/products\/automate-broken-job-link-checks-with-postgres-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}