{ "edges": [ { "to": "bdcf3fce-7872-4776-b41b-7bc7ff37e7db", "from": "ebf24d14-429d-4dd3-b92f-587929c411d2", "toPort": "0", "fromPort": "0" }, { "to": "3d561a6f-3b1b-481b-a50c-416a25092b6d", "from": "8b53cb51-5e11-4583-8564-f96771149446", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "ebf24d14-429d-4dd3-b92f-587929c411d2", "from": "01bb0573-68c1-4fb9-bada-5cd757be4097", "toPort": "0", "fromPort": "1" }, { "to": "1e82b9a5-ddc6-4b4e-84df-0dc201ebdd00", "from": "a53ecfff-8e78-4ee0-8b76-6fe32ec92e71", "toPort": "0", "fromPort": "0" }, { "to": "01bb0573-68c1-4fb9-bada-5cd757be4097", "from": "47b3a83e-ec11-47b7-9eaa-6ed5b2057ccb", "toPort": "0", "fromPort": "0" }, { "to": "3d561a6f-3b1b-481b-a50c-416a25092b6d", "from": "bdcf3fce-7872-4776-b41b-7bc7ff37e7db", "toPort": "0", "fromPort": "0" }, { "to": "a53ecfff-8e78-4ee0-8b76-6fe32ec92e71", "from": "7ee090c1-de05-4a8e-a501-69854521d0ce", "toPort": "0", "fromPort": "0" }, { "to": "7ee090c1-de05-4a8e-a501-69854521d0ce", "from": "3d561a6f-3b1b-481b-a50c-416a25092b6d", "toPort": "0", "fromPort": "0" }, { "to": "01bb0573-68c1-4fb9-bada-5cd757be4097", "from": "1e82b9a5-ddc6-4b4e-84df-0dc201ebdd00", "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, 496 ] }, { "id": "8b53cb51-5e11-4583-8564-f96771149446", "name": "OpenAI Chat Model", "type": "llm", "params": { "model": "gpt-4.1-mini", "options": {}, "provider": "openai", "builtInTools": {} }, "position": [ 1840, 592 ] }, { "id": "ebf24d14-429d-4dd3-b92f-587929c411d2", "name": "Decodo", "type": "integration", "params": { "url": "={{ $('Fetch URLs from Google Sheet').item.json.urls }}", "service": "decodo", "operation": "run", "__originalType": "@decodo/n8n-nodes-decodo.decodo" }, "position": [ 1312, 368 ] }, { "id": "01bb0573-68c1-4fb9-bada-5cd757be4097", "name": "Process URLs one by one", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 1088, 496 ] }, { "id": "bdcf3fce-7872-4776-b41b-7bc7ff37e7db", "name": "Extract SEO Elements from HTML", "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 ] }, { "id": "3d561a6f-3b1b-481b-a50c-416a25092b6d", "name": "Generate AI SEO Executive Summary", "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": "7ee090c1-de05-4a8e-a501-69854521d0ce", "name": "Parse & Validate AI JSON Output", "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": "1e82b9a5-ddc6-4b4e-84df-0dc201ebdd00", "name": "Save SEO Report to Google Sheets1", "type": "integration", "params": { "columns": { "value": { "notes": "={{ $('Parse & Validate AI JSON Output').item.json.notes }}", "status": "={{ $('Parse & Validate AI JSON Output').item.json.overall_status }}", "brand_url": "={{ $('Fetch URLs from Google Sheet').item.json.urls }}", "quick_wins": "={{ $('Parse & Validate AI JSON Output').item.json.quick_wins }}", "top_issues": "={{ $('Parse & Validate AI JSON Output').item.json.top_issues }}", "meta_description": "={{ $('Parse & Validate AI JSON Output').item.json.meta_description_recommendation }}", "title_recommendation": "={{ $('Parse & Validate AI JSON Output').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, 496 ] }, { "id": "a53ecfff-8e78-4ee0-8b76-6fe32ec92e71", "name": "Send SEO Report by Email", "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": "47b3a83e-ec11-47b7-9eaa-6ed5b2057ccb", "name": "Fetch URLs from Google 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, 496 ] } ] }

Audit web pages for SEO issues with Decodo, GPT-4 and Google Sheets