Omer Fayyaz This workflow corresponds to n8n.io template #11224 — 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 →
{
"id": "WhZiGSdO9IICm2Y5",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Multi-Site Web Scraper with Source Routing",
"tags": [],
"nodes": [
{
"id": "0bbe2f45-e7a6-485c-8fea-1df1d31239c7",
"name": "Sticky Note - Introduction",
"type": "n8n-nodes-base.stickyNote",
"position": [
-416,
368
],
"parameters": {
"width": 504,
"height": 904,
"content": "## Multi-Site Web Scraper with Source Routing\n\nIntelligent web scraper that routes URLs to different extraction logic based on source domain.\n\n### How it works \n- **Trigger**: Starts manually, on a schedule (every 4 hours), or from another workflow. \n- **Read URLs**: Fetches URLs from Google Sheets (\"URLs to Process\") with source identifiers. \n- **Rate Limiting**: Adds a 3-second delay between requests to avoid overwhelming servers. \n- **Source Routing**: Routes each URL to a specific extraction logic based on the source (e.g., Site A, Site B). \n- **Extraction**: Extracts content using site-specific CSS selectors or fallback logic. \n- **Freshness Filter**: Validates article age (defaults to 45 days), marks outdated articles as \"Outdated\". \n- **Normalization**: Cleans and standardizes the extracted data. \n- **Save & Log**: Saves extracted data to the \"Article Feed\" and updates URL status in Google Sheets. \n- **Status Updates**: Tracks success or failure per URL and updates the status accordingly.\n\n### Setup steps \n1. **Google Sheets Integration**: Connect your Google Sheets account. \n2. **Configure Sheets**: Set sheet names for \"URLs to Process\" and \"Article Feed\". \n3. **Customize Extraction**: Define CSS selectors for each site's extractor. \n4. **Configure Freshness Filter**: Set the article age threshold (default: 45 days). \n5. **Run Workflow**: Trigger manually or set a schedule to scrape data regularly.\n\n### Adding New Sources:\n1. Add a new output to the Switch node\n2. Create an HTML or Code node with site-specific selectors\n3. Connect to the Freshness Filter"
},
"typeVersion": 1
},
{
"id": "41d85cb2-a70f-4f83-8e84-4e56467c554c",
"name": "Sticky Note - Input",
"type": "n8n-nodes-base.stickyNote",
"position": [
384,
640
],
"parameters": {
"color": 7,
"width": 228,
"height": 648,
"content": "## Reads URLs with source identifiers."
},
"typeVersion": 1
},
{
"id": "24d476ac-54cf-4271-9464-3d4196a33b24",
"name": "Sticky Note - Router",
"type": "n8n-nodes-base.stickyNote",
"position": [
1408,
640
],
"parameters": {
"color": 7,
"width": 296,
"height": 644,
"content": "## Source Router (Switch)"
},
"typeVersion": 1
},
{
"id": "63470f2c-d372-46ca-b2f7-3a944e02bddf",
"name": "Sticky Note - Extractors",
"type": "n8n-nodes-base.stickyNote",
"position": [
1856,
448
],
"parameters": {
"color": 7,
"width": 616,
"height": 832,
"content": "## Site-Specific Extractors\nCustom CSS selectors per publisher."
},
"typeVersion": 1
},
{
"id": "3d735620-b4c4-4ab8-85a7-4921a4d80a52",
"name": "Sticky Note - Freshness",
"type": "n8n-nodes-base.stickyNote",
"position": [
2640,
640
],
"parameters": {
"color": 7,
"width": 280,
"height": 640,
"content": "## Freshness Filter\nFilters articles by publication date."
},
"typeVersion": 1
},
{
"id": "7fa04235-06b1-474b-bfa6-9d8fbbdb323d",
"name": "Sticky Note - Output",
"type": "n8n-nodes-base.stickyNote",
"position": [
3280,
640
],
"parameters": {
"color": 7,
"width": 488,
"height": 640,
"content": "## Output & Status Tracking\nSaves extracted data and updates source status."
},
"typeVersion": 1
},
{
"id": "894dc531-b7d0-44ca-b031-7c22c925adf1",
"name": "Manual Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
144,
928
],
"parameters": {},
"typeVersion": 1
},
{
"id": "df99475b-e36e-4d8b-b8e8-6e252ced9f42",
"name": "Schedule (Every 4 Hours)",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
144,
1120
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 4
}
]
}
},
"typeVersion": 1.2
},
{
"id": "a0b9999e-860a-4d1a-8f52-c942aa3fcc81",
"name": "Read Pending URLs",
"type": "n8n-nodes-base.googleSheets",
"position": [
448,
1024
],
"parameters": {
"sheetName": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "URLs to Process"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "YOUR_SPREADSHEET"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "7219c3b5-785c-4ee9-bc72-20c382d8f6d2",
"name": "Loop Over URLs",
"type": "n8n-nodes-base.splitInBatches",
"position": [
720,
1024
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "72bdf7e2-bb39-4de3-bb71-634c7163d5be",
"name": "Rate Limit (3s)",
"type": "n8n-nodes-base.wait",
"position": [
944,
800
],
"parameters": {
"amount": 3
},
"typeVersion": 1.1
},
{
"id": "896b1bb9-4d3c-4ea5-93fd-d3a1e019c029",
"name": "Fetch HTML",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
1184,
800
],
"parameters": {
"url": "={{ $json.URL }}",
"options": {
"timeout": 30000,
"response": {
"response": {
"fullResponse": true,
"responseFormat": "text"
}
}
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "User-Agent",
"value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/0.0.0.0 Safari/537.36"
},
{
"name": "Accept",
"value": "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8"
},
{
"name": "Accept-Language",
"value": "en-US,en;q=0.5"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "aa9fac82-5076-45ac-90d1-da65faf5c206",
"name": "Source Router",
"type": "n8n-nodes-base.switch",
"position": [
1504,
752
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Site A",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "dd700c7f-06c4-4a76-93ba-adaa51b1814e",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Loop Over URLs').item.json.Source }}",
"rightValue": "Site A"
}
]
},
"renameOutput": true
},
{
"outputKey": "Site B",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6da5c75a-2057-414e-ac16-cee607861b83",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Loop Over URLs').item.json.Source }}",
"rightValue": "Site B"
}
]
},
"renameOutput": true
},
{
"outputKey": "Site C",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7d437ee9-fb8a-48be-8d00-2ae46934a8eb",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Loop Over URLs').item.json.Source }}",
"rightValue": "Site C"
}
]
},
"renameOutput": true
},
{
"outputKey": "Site D",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "a2abaacb-55c7-4304-b92c-ef2714d10557",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Loop Over URLs').item.json.Source }}",
"rightValue": "Site D"
}
]
},
"renameOutput": true
},
{
"outputKey": "fallback",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "14362d61-d2e8-4d40-8edf-12eccbea7b00",
"operator": {
"type": "string",
"operation": "exists"
},
"leftValue": "={{ $('Loop Over URLs').item.json.Source }}",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {
"allMatchingOutputs": false
}
},
"typeVersion": 3.2
},
{
"id": "4bbec03a-1f1f-4e1a-9b1d-2d14ae6620c3",
"name": "Extract: Fallback (Universal)",
"type": "n8n-nodes-base.code",
"position": [
2064,
1136
],
"parameters": {
"jsCode": "// Universal fallback extractor for unknown sources\nconst results = [];\n\nfor (const item of items) {\n const html = item.json.data || item.json.body || \"\";\n const requestUrl = item.json.URL || item.json.url || \"\";\n const source = item.json.Source || \"unknown\";\n \n let title = null;\n let description = null;\n let author = null;\n let datePublished = null;\n let imageUrl = null;\n let canonicalUrl = null;\n\n // --- TITLE ---\n const titlePatterns = [\n /<h1[^>]*>([\\s\\S]*?)<\\/h1>/i,\n /<meta[^>]+property=[\"']og:title[\"'][^>]+content=[\"']([^\"']+)[\"']/i,\n /<title[^>]*>([\\s\\S]*?)<\\/title>/i\n ];\n for (const pattern of titlePatterns) {\n const match = html.match(pattern);\n if (match) {\n title = match[1].replace(/<[^>]+>/g, \"\").trim();\n if (title) break;\n }\n }\n\n // --- DESCRIPTION ---\n const descPatterns = [\n /<meta[^>]+name=[\"']description[\"'][^>]+content=[\"']([^\"']+)[\"']/i,\n /<meta[^>]+property=[\"']og:description[\"'][^>]+content=[\"']([^\"']+)[\"']/i\n ];\n for (const pattern of descPatterns) {\n const match = html.match(pattern);\n if (match) {\n description = match[1].trim();\n if (description) break;\n }\n }\n \n if (!description) {\n const paragraphs = [...html.matchAll(/<p[^>]*>([\\s\\S]*?)<\\/p>/gi)]\n .map(m => m[1].replace(/<[^>]+>/g, \"\").trim())\n .filter(t => t && t.length > 50);\n if (paragraphs.length) {\n description = paragraphs.slice(0, 2).join(\" \").substring(0, 500);\n }\n }\n\n // --- AUTHOR ---\n const authorPatterns = [\n /<meta[^>]+name=[\"']author[\"'][^>]+content=[\"']([^\"']+)[\"']/i,\n /by\\s+([A-Z][a-z]+\\s+[A-Z][a-z]+)/i,\n /<a[^>]+rel=[\"']author[\"'][^>]*>([^<]+)<\\/a>/i\n ];\n for (const pattern of authorPatterns) {\n const match = html.match(pattern);\n if (match) {\n author = match[1].trim();\n if (author) break;\n }\n }\n \n if (!author) {\n const ldMatch = html.match(/<script[^>]+application\\/ld\\+json[^>]*>([\\s\\S]*?)<\\/script>/i);\n if (ldMatch) {\n try {\n const ld = JSON.parse(ldMatch[1]);\n const a = ld.author;\n if (a) {\n author = typeof a === \"string\" ? a : (a.name || (Array.isArray(a) ? a[0].name : null));\n }\n } catch (e) {}\n }\n }\n\n // --- DATE PUBLISHED ---\n const datePatterns = [\n /<time[^>]+datetime=[\"']([^\"']+)[\"']/i,\n /<meta[^>]+property=[\"']article:published_time[\"'][^>]+content=[\"']([^\"']+)[\"']/i,\n /(\\d{4}-\\d{2}-\\d{2})/\n ];\n for (const pattern of datePatterns) {\n const match = html.match(pattern);\n if (match) {\n datePublished = match[1].trim();\n if (datePublished) break;\n }\n }\n \n if (!datePublished) {\n const ldMatch = html.match(/<script[^>]+application\\/ld\\+json[^>]*>([\\s\\S]*?)<\\/script>/i);\n if (ldMatch) {\n try {\n const ld = JSON.parse(ldMatch[1]);\n datePublished = ld.datePublished || ld.dateCreated || null;\n } catch (e) {}\n }\n }\n\n // --- IMAGE URL ---\n const imgPatterns = [\n /<meta[^>]+property=[\"']og:image[\"'][^>]+content=[\"']([^\"']+)[\"']/i,\n /<meta[^>]+name=[\"']twitter:image[\"'][^>]+content=[\"']([^\"']+)[\"']/i\n ];\n for (const pattern of imgPatterns) {\n const match = html.match(pattern);\n if (match) {\n imageUrl = match[1].trim();\n if (imageUrl) break;\n }\n }\n\n // --- CANONICAL URL ---\n const canonicalMatch = html.match(/<link[^>]+rel=[\"']canonical[\"'][^>]+href=[\"']([^\"']+)[\"']/i);\n if (canonicalMatch) {\n canonicalUrl = canonicalMatch[1].trim();\n } else {\n const ogUrlMatch = html.match(/<meta[^>]+property=[\"']og:url[\"'][^>]+content=[\"']([^\"']+)[\"']/i);\n if (ogUrlMatch) canonicalUrl = ogUrlMatch[1].trim();\n }\n\n results.push({\n json: {\n title,\n description,\n author,\n datePublished,\n imageUrl,\n canonicalUrl: canonicalUrl || requestUrl,\n source,\n sourceUrl: requestUrl\n }\n });\n}\n\nreturn results;"
},
"typeVersion": 2
},
{
"id": "63b8461f-a33a-4b58-8c67-6eea1f4ef492",
"name": "Normalize Extracted Data",
"type": "n8n-nodes-base.code",
"position": [
2336,
784
],
"parameters": {
"jsCode": "// Normalize extracted data from site-specific extractors\nconst results = [];\n\nfor (const item of items) {\n const input = item.json;\n const loopData = $('Loop Over URLs').item.json;\n \n results.push({\n json: {\n title: (input.title && input.title.trim()) ? input.title.trim() : null,\n description: (input.description && input.description.trim()) ? input.description.trim().substring(0, 1000) : null,\n author: (input.author && input.author.trim()) ? input.author.trim() : null,\n datePublished: (input.datePublished && input.datePublished.trim()) ? input.datePublished.trim() : null,\n imageUrl: (input.imageUrl && input.imageUrl.trim()) ? input.imageUrl.trim() : null,\n canonicalUrl: (input.canonicalUrl && input.canonicalUrl.trim()) ? input.canonicalUrl.trim() : loopData.URL,\n source: loopData.Source || \"unknown\",\n sourceUrl: loopData.URL\n }\n });\n}\n\nreturn results;"
},
"typeVersion": 2
},
{
"id": "6e67b344-df32-47c5-b04e-a626b607ee30",
"name": "Freshness Filter (45 days)",
"type": "n8n-nodes-base.if",
"position": [
2736,
912
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "freshness-check",
"operator": {
"type": "boolean",
"operation": "equals"
},
"leftValue": "={{ (function() {\n var dateStr = $json.datePublished;\n if (!dateStr) return true;\n \n var date;\n if (dateStr.match(/^\\d{4}-\\d{2}-\\d{2}/)) {\n date = new Date(dateStr);\n } else {\n var cleaned = dateStr.replace(/(\\d+)(st|nd|rd|th)/, '$1');\n date = new Date(cleaned);\n }\n \n if (isNaN(date.getTime())) return true;\n \n var cutoffDate = new Date();\n cutoffDate.setDate(cutoffDate.getDate() - 45);\n return date >= cutoffDate;\n})() }}",
"rightValue": true
}
]
}
},
"typeVersion": 2.2
},
{
"id": "24a813c5-0431-4151-ae17-fd81d4854b44",
"name": "Calculate Tier & Status",
"type": "n8n-nodes-base.code",
"position": [
3040,
832
],
"parameters": {
"jsCode": "// Calculate tier based on article age\nconst results = [];\n\nfor (const item of items) {\n const input = item.json;\n let tier = \"Unknown\";\n let freshnessStatus = \"Fresh\";\n \n if (input.datePublished) {\n const dateStr = input.datePublished;\n let articleDate;\n \n if (dateStr.match(/^\\d{4}-\\d{2}-\\d{2}/)) {\n articleDate = new Date(dateStr);\n } else {\n const cleaned = dateStr.replace(/(\\d+)(st|nd|rd|th)/, '$1');\n articleDate = new Date(cleaned);\n }\n \n if (!isNaN(articleDate.getTime())) {\n const now = new Date();\n const daysDiff = Math.floor((now - articleDate) / (1000 * 60 * 60 * 24));\n \n if (daysDiff <= 7) {\n tier = \"Tier 1\";\n freshnessStatus = \"Fresh\";\n } else if (daysDiff <= 14) {\n tier = \"Tier 2\";\n freshnessStatus = \"Fresh\";\n } else if (daysDiff <= 30) {\n tier = \"Tier 3\";\n freshnessStatus = \"Fresh\";\n } else {\n tier = \"Archive\";\n freshnessStatus = \"Fresh\";\n }\n }\n }\n \n results.push({\n json: {\n ...input,\n tier,\n freshnessStatus,\n extractedAt: new Date().toISOString()\n }\n });\n}\n\nreturn results;"
},
"typeVersion": 2
},
{
"id": "6641b358-6d38-4a9a-8bb3-1e00c83b12f7",
"name": "Mark as Outdated",
"type": "n8n-nodes-base.set",
"position": [
3392,
1120
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "status-outdated",
"name": "freshnessStatus",
"type": "string",
"value": "Outdated"
},
{
"id": "reason",
"name": "reason",
"type": "string",
"value": "Article older than 45 days"
},
{
"id": "sourceUrl",
"name": "sourceUrl",
"type": "string",
"value": "={{ $json.sourceUrl }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e43b32e6-0b16-4b0c-a51f-8684d6509817",
"name": "Save to Article Feed",
"type": "n8n-nodes-base.googleSheets",
"position": [
3392,
832
],
"parameters": {
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "Article Feed"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "YOUR_SPREADSHEET"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "9e0a7cac-7b50-4c9e-a1fb-7ce47a9b1355",
"name": "Update URL Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
3600,
1120
],
"parameters": {
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "URLs to Process"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "YOUR_SPREADSHEET"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "af00d978-f194-4a53-a5ec-49861ea66452",
"name": "Completion Summary",
"type": "n8n-nodes-base.set",
"position": [
944,
1104
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "count",
"name": "articlesProcessed",
"type": "number",
"value": "={{ $items().length }}"
},
{
"id": "timestamp",
"name": "completedAt",
"type": "string",
"value": "={{ $now.toISO() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ec75d39d-4457-4e09-9163-9e4169b0dfdc",
"name": "Extract: Site B",
"type": "n8n-nodes-base.html",
"onError": "continueRegularOutput",
"position": [
2064,
704
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "title",
"cssSelector": "h1, article h1"
},
{
"key": "description",
"attribute": "content",
"cssSelector": "meta[name='description']",
"returnValue": "attribute"
},
{
"key": "author",
"cssSelector": "a[data-testid='authorName'], .author-info a, a[rel='author']"
},
{
"key": "datePublished",
"cssSelector": "span[data-testid='storyPublishDate'], time[datetime]"
},
{
"key": "imageUrl",
"attribute": "content",
"cssSelector": "meta[property='og:image']",
"returnValue": "attribute"
},
{
"key": "canonicalUrl",
"attribute": "href",
"cssSelector": "link[rel='canonical']",
"returnValue": "attribute"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "91ad55da-5b9d-4f47-b622-2cc674247b47",
"name": "Extract: Site C",
"type": "n8n-nodes-base.html",
"onError": "continueRegularOutput",
"position": [
2064,
848
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "title",
"cssSelector": "h1.entry-title, .post-title, h1.wp-block-post-title"
},
{
"key": "description",
"attribute": "content",
"cssSelector": "meta[name='description']",
"returnValue": "attribute"
},
{
"key": "author",
"cssSelector": ".author-name, .byline a, span.author a, .entry-author a"
},
{
"key": "datePublished",
"attribute": "datetime",
"cssSelector": "time.entry-date, .post-date time, time[datetime]",
"returnValue": "attribute"
},
{
"key": "imageUrl",
"attribute": "content",
"cssSelector": "meta[property='og:image']",
"returnValue": "attribute"
},
{
"key": "canonicalUrl",
"attribute": "href",
"cssSelector": "link[rel='canonical']",
"returnValue": "attribute"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "5e9d8787-971b-45b1-8b4d-450c59e4e5c3",
"name": "Extract: Site D",
"type": "n8n-nodes-base.html",
"onError": "continueRegularOutput",
"position": [
2064,
992
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "title",
"cssSelector": "#hs_cos_wrapper_name, h1.blog-post__title, .post-header h1"
},
{
"key": "description",
"cssSelector": "#hs_cos_wrapper_post_body p:first-of-type, meta[name='description']"
},
{
"key": "author",
"cssSelector": "p[data-hubspot-name='Blog Author'] a, .author-info a, .blog-author__name"
},
{
"key": "datePublished",
"cssSelector": "span.blog--single--meta--date, time[datetime], .post-date"
},
{
"key": "imageUrl",
"attribute": "content",
"cssSelector": "meta[property='og:image']",
"returnValue": "attribute"
},
{
"key": "canonicalUrl",
"attribute": "href",
"cssSelector": "link[rel='canonical']",
"returnValue": "attribute"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "cdd20c9c-cd91-4ccf-8e6e-7ea95e4289ab",
"name": "Sticky Note - Input1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1120,
640
],
"parameters": {
"color": 7,
"width": 246,
"height": 648,
"content": "## Fetch the HTML content"
},
"typeVersion": 1
},
{
"id": "bd580a4c-9c60-4b1c-8f55-f2d11973fc79",
"name": "Extract: Site A",
"type": "n8n-nodes-base.html",
"onError": "continueRegularOutput",
"position": [
2064,
560
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "title",
"cssSelector": "h1.article__title, h1[data-testid='ContentHeader'], .post-title h1"
},
{
"key": "description",
"attribute": "content",
"cssSelector": "meta[name='description']",
"returnValue": "attribute"
},
{
"key": "author",
"cssSelector": ".article__byline a, a[rel='author'], .author-card__name"
},
{
"key": "datePublished",
"attribute": "datetime",
"cssSelector": "time[datetime]",
"returnValue": "attribute"
},
{
"key": "imageUrl",
"attribute": "content",
"cssSelector": "meta[property='og:image']",
"returnValue": "attribute"
},
{
"key": "canonicalUrl",
"attribute": "href",
"cssSelector": "link[rel='canonical']",
"returnValue": "attribute"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "bb20578e-1c3d-4848-b857-3082264298c7",
"name": "Sticky Note - Freshness1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2944,
640
],
"parameters": {
"color": 7,
"width": 280,
"height": 640,
"content": "## Tier Status\nCalculate Tier Status based on content "
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "87886f32-8c5a-4dcd-93aa-2e2109b99cee",
"connections": {
"Fetch HTML": {
"main": [
[
{
"node": "Source Router",
"type": "main",
"index": 0
}
]
]
},
"Source Router": {
"main": [
[
{
"node": "Extract: Site A",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract: Site B",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract: Site C",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract: Site D",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract: Fallback (Universal)",
"type": "main",
"index": 0
}
]
]
},
"Loop Over URLs": {
"main": [
[
{
"node": "Completion Summary",
"type": "main",
"index": 0
}
],
[
{
"node": "Rate Limit (3s)",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Read Pending URLs",
"type": "main",
"index": 0
}
]
]
},
"Extract: Site A": {
"main": [
[
{
"node": "Normalize Extracted Data",
"type": "main",
"index": 0
}
]
]
},
"Extract: Site B": {
"main": [
[
{
"node": "Normalize Extracted Data",
"type": "main",
"index": 0
}
]
]
},
"Extract: Site C": {
"main": [
[
{
"node": "Normalize Extracted Data",
"type": "main",
"index": 0
}
]
]
},
"Extract: Site D": {
"main": [
[
{
"node": "Normalize Extracted Data",
"type": "main",
"index": 0
}
]
]
},
"Rate Limit (3s)": {
"main": [
[
{
"node": "Fetch HTML",
"type": "main",
"index": 0
}
]
]
},
"Mark as Outdated": {
"main": [
[
{
"node": "Update URL Status",
"type": "main",
"index": 0
}
]
]
},
"Read Pending URLs": {
"main": [
[
{
"node": "Loop Over URLs",
"type": "main",
"index": 0
}
]
]
},
"Update URL Status": {
"main": [
[
{
"node": "Loop Over URLs",
"type": "main",
"index": 0
}
]
]
},
"Save to Article Feed": {
"main": [
[
{
"node": "Update URL Status",
"type": "main",
"index": 0
}
]
]
},
"Calculate Tier & Status": {
"main": [
[
{
"node": "Save to Article Feed",
"type": "main",
"index": 0
}
]
]
},
"Normalize Extracted Data": {
"main": [
[
{
"node": "Freshness Filter (45 days)",
"type": "main",
"index": 0
}
]
]
},
"Schedule (Every 4 Hours)": {
"main": [
[
{
"node": "Read Pending URLs",
"type": "main",
"index": 0
}
]
]
},
"Freshness Filter (45 days)": {
"main": [
[
{
"node": "Calculate Tier & Status",
"type": "main",
"index": 0
}
],
[
{
"node": "Mark as Outdated",
"type": "main",
"index": 0
}
]
]
},
"Extract: Fallback (Universal)": {
"main": [
[
{
"node": "Freshness Filter (45 days)",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Intelligent Source Routing - Uses a Switch node to route URLs to specialized extractors based on source identifier, enabling custom CSS selectors per publisher for maximum accuracy Universal Fallback Parser - Advanced regex-based extractor handles unknown sources automatically,…
Source: https://n8n.io/workflows/11224/ — 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.
TrackCollect_deeper. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 80 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +1
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
HTTP Request, Gmail, Twilio +3
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
Product Ad Machine. Uses googleDrive, googleSheets, httpRequest, @ffmpeg-micro/n8n-nodes-ffmpeg-micro. Event-driven trigger; 60 nodes.
Google Drive, Google Sheets, HTTP Request +2
The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet
Google Sheets, Google Drive, HTTP Request