{ "edges": [ { "to": "bdcf3fce-7872-4776-b41b-7bc7ff37e7db", "from": "ebf24d14-429d-4dd3-b92f-587929c411d2", "toPort": "0", "fromPort": "0" }, { "to": "7ee090c1-de05-4a8e-a501-69854521d0ce", "from": "3d561a6f-3b1b-481b-a50c-416a25092b6d", "toPort": "0", "fromPort": "0" }, { "to": "1e82b9a5-ddc6-4b4e-84df-0dc201ebdd00", "from": "a53ecfff-8e78-4ee0-8b76-6fe32ec92e71", "toPort": "0", "fromPort": "0" }, { "to": "ebf24d14-429d-4dd3-b92f-587929c411d2", "from": "01bb0573-68c1-4fb9-bada-5cd757be4097", "toPort": "0", "fromPort": "1" }, { "to": "3d561a6f-3b1b-481b-a50c-416a25092b6d", "from": "8b53cb51-5e11-4583-8564-f96771149446", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "a53ecfff-8e78-4ee0-8b76-6fe32ec92e71", "from": "7ee090c1-de05-4a8e-a501-69854521d0ce", "toPort": "0", "fromPort": "0" }, { "to": "01bb0573-68c1-4fb9-bada-5cd757be4097", "from": "1e82b9a5-ddc6-4b4e-84df-0dc201ebdd00", "toPort": "0", "fromPort": "0" }, { "to": "3d561a6f-3b1b-481b-a50c-416a25092b6d", "from": "bdcf3fce-7872-4776-b41b-7bc7ff37e7db", "toPort": "0", "fromPort": "0" }, { "to": "01bb0573-68c1-4fb9-bada-5cd757be4097", "from": "47b3a83e-ec11-47b7-9eaa-6ed5b2057ccb", "toPort": "0", "fromPort": "0" }, { "to": "47b3a83e-ec11-47b7-9eaa-6ed5b2057ccb", "from": "a03e179c-c098-4509-87bb-666963a91c63", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "a03e179c-c098-4509-87bb-666963a91c63", "name": "When clicking ‘Execute workflow’", "type": "manualTrigger", "params": {}, "position": [ 640, 492 ] }, { "id": "7ee090c1-de05-4a8e-a501-69854521d0ce", "name": "Code in JavaScript", "type": "code", "params": { "jsCode": "// Input esperado: items[0].json.output (string con ```json ... ```)\n// Output: 1 item con el JSON ya parseado en items[0].json\n\nfunction stripCodeFences(s) {\n if (!s || typeof s !== 'string') return s;\n // Quita ```json ... ``` o ``` ... ```\n return s.replace(/^```(?:json)?\\s*/i, '').replace(/\\s*```$/i, '').trim();\n}\n\nfunction extractFirstJSONObject(s) {\n // Extrae el primer bloque {...} válido\n const start = s.indexOf('{');\n const end = s.lastIndexOf('}');\n if (start === -1 || end === -1 || end <= start) throw new Error('No JSON object braces found');\n return s.slice(start, end + 1);\n}\n\nconst out = [];\nfor (const item of items) {\n let raw = item.json.output ?? item.json ?? '';\n if (typeof raw !== 'string') raw = JSON.stringify(raw);\n\n // Si viene envuelto en array tipo [ { output: \"...\" } ], deshazlo\n // (por si te llega el array entero aquí)\n if (Array.isArray(item.json) && item.json.length && item.json[0].output) {\n raw = item.json[0].output;\n }\n\n raw = stripCodeFences(raw);\n const jsonStr = extractFirstJSONObject(raw);\n\n let parsed;\n try {\n parsed = JSON.parse(jsonStr);\n } catch (e) {\n // Intento de “repair” sencillo: elimina BOM y comas colgantes comunes\n const repaired = jsonStr\n .replace(/^\\uFEFF/, '')\n .replace(/,\\s*}/g, '}')\n .replace(/,\\s*]/g, ']');\n parsed = JSON.parse(repaired);\n }\n\n out.push({ json: parsed });\n}\nreturn out;\n" }, "position": [ 2112, 368 ] }, { "id": "47b3a83e-ec11-47b7-9eaa-6ed5b2057ccb", "name": "Get row(s) in sheet", "type": "integration", "params": { "options": { "dataLocationOnSheet": { "values": { "rangeDefinition": "specifyRange" } } }, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1mIVyGQXXVR92IhlvaQfdlGqJEU0lsJHHmlZONyMzU9c/edit#gid=0", "cachedResultName": "Hoja 1" }, "documentId": { "__rl": true, "mode": "list", "value": "1mIVyGQXXVR92IhlvaQfdlGqJEU0lsJHHmlZONyMzU9c", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1mIVyGQXXVR92IhlvaQfdlGqJEU0lsJHHmlZONyMzU9c/edit?usp=drivesdk", "cachedResultName": "urls_to_scrape" } }, "position": [ 864, 492 ] }, { "id": "01bb0573-68c1-4fb9-bada-5cd757be4097", "name": "Loop Over Items", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 1088, 492 ] }, { "id": "8b53cb51-5e11-4583-8564-f96771149446", "name": "OpenAI Chat Model", "type": "llm", "params": { "model": "gpt-4.1-mini", "options": {}, "provider": "openai", "builtInTools": {} }, "position": [ 1832, 592 ] }, { "id": "ebf24d14-429d-4dd3-b92f-587929c411d2", "name": "Decodo", "type": "integration", "params": { "url": "={{ $('Get row(s) in sheet').item.json.urls }}", "service": "decodo", "operation": "run", "__originalType": "@decodo/n8n-nodes-decodo.decodo" }, "position": [ 1312, 368 ] }, { "id": "3d561a6f-3b1b-481b-a50c-416a25092b6d", "name": "AI Agent", "type": "llm", "params": { "text": "={{ $json.seo_compact_text }}", "prompt": "={{ $json.seo_compact_text }}", "options": { "systemMessage": "You are an SEO auditor producing an executive summary for non-technical stakeholders.\n\nInput is a compact SEO extract:\nTITLE, META_DESCRIPTION, CANONICAL, H1/H2, and a short visible-text excerpt.\n\nReturn ONLY valid JSON:\n{\n \"overall_status\": \"good\"|\"needs_attention\"|\"critical\",\n \"top_issues\": [string], // max 5 bullets, short\n \"quick_wins\": [string], // max 5 bullets, actionable\n \"title_recommendation\": string|null,\n \"meta_description_recommendation\": string|null,\n \"notes\": string|null // 1–2 lines\n}\n\nRules:\n- Keep it short and executive-friendly.\n- No markdown, no emojis.\n- If info is missing, explain briefly in notes.\n" }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "You are an SEO auditor producing an executive summary for non-technical stakeholders.\n\nInput is a compact SEO extract:\nTITLE, META_DESCRIPTION, CANONICAL, H1/H2, and a short visible-text excerpt.\n\nReturn ONLY valid JSON:\n{\n \"overall_status\": \"good\"|\"needs_attention\"|\"critical\",\n \"top_issues\": [string], // max 5 bullets, short\n \"quick_wins\": [string], // max 5 bullets, actionable\n \"title_recommendation\": string|null,\n \"meta_description_recommendation\": string|null,\n \"notes\": string|null // 1–2 lines\n}\n\nRules:\n- Keep it short and executive-friendly.\n- No markdown, no emojis.\n- If info is missing, explain briefly in notes.\n" }, "position": [ 1760, 368 ] }, { "id": "1e82b9a5-ddc6-4b4e-84df-0dc201ebdd00", "name": "Append row in sheet", "type": "integration", "params": { "columns": { "value": { "notes": "={{ $('Code in JavaScript').item.json.notes }}", "status": "={{ $('Code in JavaScript').item.json.overall_status }}", "brand_url": "={{ $('Get row(s) in sheet').item.json.urls }}", "quick_wins": "={{ $('Code in JavaScript').item.json.quick_wins }}", "top_issues": "={{ $('Code in JavaScript').item.json.top_issues }}", "meta_description": "={{ $('Code in JavaScript').item.json.meta_description_recommendation }}", "title_recommendation": "={{ $('Code in JavaScript').item.json.title_recommendation }}" }, "schema": [ { "id": "brand_url", "type": "string", "display": true, "removed": false, "required": false, "displayName": "brand_url", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "status", "type": "string", "display": true, "removed": false, "required": false, "displayName": "status", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "top_issues", "type": "string", "display": true, "removed": false, "required": false, "displayName": "top_issues", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "quick_wins", "type": "string", "display": true, "removed": false, "required": false, "displayName": "quick_wins", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "title_recommendation", "type": "string", "display": true, "removed": false, "required": false, "displayName": "title_recommendation", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "meta_description", "type": "string", "display": true, "removed": false, "required": false, "displayName": "meta_description", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "notes", "type": "string", "display": true, "removed": false, "required": false, "displayName": "notes", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LPYN31Dtt5ZFF39yB4mJDvRG40Ga2sow_MlLcNx_DOg/edit#gid=0", "cachedResultName": "Hoja 1" }, "documentId": { "__rl": true, "mode": "list", "value": "1LPYN31Dtt5ZFF39yB4mJDvRG40Ga2sow_MlLcNx_DOg", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1LPYN31Dtt5ZFF39yB4mJDvRG40Ga2sow_MlLcNx_DOg/edit?usp=drivesdk", "cachedResultName": "SEO Analyzer" } }, "position": [ 2560, 492 ] }, { "id": "a53ecfff-8e78-4ee0-8b76-6fe32ec92e71", "name": "Send a message", "type": "integration", "params": { "sendTo": "user@example.com", "message": "=

Hi,

\n\n

\nHere is the latest SEO Watchdog executive summary for:\n
\nthis page\n

\n\n

\nStatus:\nNeeds attention\n

\n\n

🔎 Top issues

Title is too long and may be truncated in search results
Meta description is lengthy and lacks clear calls-to-action
H1 is generic and does not strongly reflect primary keywords
Canonical URL points only to homepage, no specific page URL provided
H2 headings are numerous and unfocused, reducing clarity

\n\n

⚡ Quick wins

Shorten the title to under 60 characters focusing on the main keyword
Rewrite the meta description to under 160 characters with clear benefits and CTAs
Refine the H1 to better reflect primary keywords and user intent
Ensure the canonical URL matches the specific page URL
Consolidate H2 tags to emphasize main offerings and keywords

\n\n

🏷️ Recommended title

\nBest API for Historical Stock Market Prices & Financial Data | Free Trial\n

\n\n

📝 Recommended meta description

\nAccess historical and real-time stock prices for 150,000+ tickers with flexible plans.\nStart your free trial today.\n

\n\n

📌 Notes

\nSEO elements are present but need refinement for optimal search visibility and user engagement.\nVisible text content is comprehensive but dense.\n

\n\n

\n— Sent automatically by n8n SEO Watchdog
\nhttps://n8n.io\n

", "options": {}, "service": "gmail", "subject": "=SEO Watchdog Report — {{$now}}", "operation": "read" }, "position": [ 2336, 368 ] }, { "id": "bdcf3fce-7872-4776-b41b-7bc7ff37e7db", "name": "Code in JavaScript1", "type": "code", "params": { "jsCode": "/**\n * PRE-EXTRACT SEO (HTML -> compact payload)\n * Reads: $json.results[0].content\n * Returns: seo_compact_text + seo_fields\n */\n\nfunction decodeHtml(s) {\n if (!s || typeof s !== \"string\") return s;\n return s\n .replace(/&/g, \"&\")\n .replace(/"/g, '\"')\n .replace(/'/g, \"'\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/>/g, \">\")\n .replace(/&#(\\d+);/g, (_, code) => String.fromCharCode(Number(code)));\n}\n\nfunction cleanSpaces(s) {\n return (s || \"\")\n .replace(/\\s+/g, \" \")\n .trim();\n}\n\nfunction stripTags(html) {\n return cleanSpaces(\n (html || \"\")\n .replace(//gi, \" \")\n .replace(//gi, \" \")\n .replace(//g, \" \")\n .replace(/<[^>]*>/g, \" \")\n );\n}\n\nfunction getFirstMatch(html, regex) {\n const m = html.match(regex);\n return m ? decodeHtml(m[1]).trim() : null;\n}\n\nfunction getAllMatches(html, regex, limit = 20) {\n const out = [];\n let m;\n while ((m = regex.exec(html)) !== null) {\n out.push(decodeHtml(m[1]).trim());\n if (out.length >= limit) break;\n }\n return out;\n}\n\nfunction truncate(s, maxChars) {\n if (!s) return \"\";\n return s.length > maxChars ? s.slice(0, maxChars) + \"…\" : s;\n}\n\nconst html = $json?.results?.[0]?.content;\nif (!html || typeof html !== \"string\") {\n return [{\n json: {\n seo_compact_text: \"NO_HTML_INPUT\",\n seo_fields: { title: null, meta_description: null, h1: null, h2: [], canonical: null, og_title: null, og_description: null, text_excerpt: \"\" }\n }\n }];\n}\n\n// Basic head elements\nconst title = getFirstMatch(html, /]*>([\\s\\S]*?)<\\/title>/i);\nconst meta_description =\n getFirstMatch(html, /]*name=[\"']description[\"'][^>]*content=[\"']([^\"']*)[\"']/i) ||\n getFirstMatch(html, /]*content=[\"']([^\"']*)[\"'][^>]*name=[\"']description[\"']/i);\n\nconst canonical =\n getFirstMatch(html, /]*rel=[\"']canonical[\"'][^>]*href=[\"']([^\"']+)[\"']/i) ||\n getFirstMatch(html, /]*href=[\"']([^\"']+)[\"'][^>]*rel=[\"']canonical[\"']/i);\n\n// OG tags\nconst og_title =\n getFirstMatch(html, /]*property=[\"']og:title[\"'][^>]*content=[\"']([^\"']*)[\"']/i) ||\n getFirstMatch(html, /]*content=[\"']([^\"']*)[\"'][^>]*property=[\"']og:title[\"']/i);\n\nconst og_description =\n getFirstMatch(html, /]*property=[\"']og:description[\"'][^>]*content=[\"']([^\"']*)[\"']/i) ||\n getFirstMatch(html, /]*content=[\"']([^\"']*)[\"'][^>]*property=[\"']og:description[\"']/i);\n\n// H1/H2 (simple regex extraction)\nconst h1 = getFirstMatch(html, /]*>([\\s\\S]*?)<\\/h1>/i);\nconst h2 = getAllMatches(html, /]*>([\\s\\S]*?)<\\/h2>/gi, 15).map(x => cleanSpaces(stripTags(x))).filter(Boolean);\n\n// Visible text excerpt (limited)\nconst visibleText = stripTags(html);\nconst text_excerpt = truncate(visibleText, 6000);\n\n// Build compact text for LLM\nconst lines = [];\nlines.push(\"SEO_PAGE_EXTRACT\");\nlines.push(\"---\");\nlines.push(`TITLE: ${title || \"null\"}`);\nlines.push(`META_DESCRIPTION: ${meta_description || \"null\"}`);\nlines.push(`CANONICAL: ${canonical || \"null\"}`);\nlines.push(`H1: ${h1 ? cleanSpaces(stripTags(h1)) : \"null\"}`);\nlines.push(`H2: ${h2.length ? h2.join(\" | \") : \"null\"}`);\nlines.push(`OG_TITLE: ${og_title || \"null\"}`);\nlines.push(`OG_DESCRIPTION: ${og_description || \"null\"}`);\nlines.push(\"---\");\nlines.push(\"VISIBLE_TEXT_EXCERPT:\");\nlines.push(text_excerpt || \"\");\n\nreturn [{\n json: {\n seo_compact_text: lines.join(\"\\n\"),\n seo_fields: {\n title,\n meta_description,\n canonical,\n h1: h1 ? cleanSpaces(stripTags(h1)) : null,\n h2,\n og_title,\n og_description,\n text_excerpt\n }\n }\n}];\n" }, "position": [ 1536, 368 ] } ] }

Extract high-intent SEO keywords with Decodo from web pages with AI + SERP data