{ "edges": [ { "to": "51141783-e4e7-4420-8813-d134818a0867", "from": "67fbbead-8ebd-48f6-9925-a907d7cd638f", "toPort": "0", "fromPort": "0" }, { "to": "605c61d4-dff4-4e9e-a667-857cabbd6da7", "from": "67fbbead-8ebd-48f6-9925-a907d7cd638f", "toPort": "0", "fromPort": "0" }, { "to": "ff78c01e-fea3-4033-92fd-cd2af602e652", "from": "38c84d7c-a939-4723-aebd-c2d77a1d1c53", "toPort": "0", "fromPort": "0" }, { "to": "67fbbead-8ebd-48f6-9925-a907d7cd638f", "from": "950eaf09-ac30-4530-99f0-c37384e2339f", "toPort": "0", "fromPort": "0" }, { "to": "38c84d7c-a939-4723-aebd-c2d77a1d1c53", "from": "51141783-e4e7-4420-8813-d134818a0867", "toPort": "1", "fromPort": "0" }, { "to": "38c84d7c-a939-4723-aebd-c2d77a1d1c53", "from": "605c61d4-dff4-4e9e-a667-857cabbd6da7", "toPort": "0", "fromPort": "0" }, { "to": "771fae7e-0349-4bc3-91fe-c3b3cc84b460", "from": "ff78c01e-fea3-4033-92fd-cd2af602e652", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "950eaf09-ac30-4530-99f0-c37384e2339f", "name": "When clicking ‘Execute workflow’", "type": "manualTrigger", "params": {}, "position": [ -464, 144 ] }, { "id": "67fbbead-8ebd-48f6-9925-a907d7cd638f", "name": "Get many messages", "type": "integration", "params": { "simple": false, "filters": { "sender": "user@example.com", "readStatus": "unread", "includeSpamTrash": true }, "options": {}, "service": "gmail", "operation": "getAll" }, "position": [ -224, 144 ] }, { "id": "51141783-e4e7-4420-8813-d134818a0867", "name": "Extract Content Font Family from HTML", "type": "code", "params": { "jsCode": "/**\n * n8n Function node (ES5-friendly)\n * Extracts font-family for each requested content string from Gmail HTML.\n *\n * Input:\n * - $json.html : full Gmail HTML body (string) — escaped or real\n *\n * Output (array of items):\n * [{ json: { \n * Content, \n * \"Actual font family\", \n * \"Tag name\", \n * \"Tag snippet (escaped)\", \n * \"Anchor href\" \n * } \n * }, ...]\n */\n\n// -------------------- Utilities --------------------\nfunction unescapeHtmlEntities(s) {\n if (!s) return \"\";\n return s\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/&/g, \"&\")\n .replace(/"/g, \"\\\"\")\n .replace(/'/g, \"'\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/&/g, \"&\")\n .replace(/"/g, \"\\\"\")\n .replace(/'/g, \"'\");\n}\n\nfunction escapeHtml(s) {\n if (!s) return \"\";\n return s.replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\nfunction innerText(htmlFrag) {\n if (!htmlFrag) return \"\";\n var noTags = htmlFrag.replace(/<[^>]*>/g, \" \");\n return unescapeHtmlEntities(noTags)\n .replace(/\\s+/g, \" \")\n .trim();\n}\n\nfunction parseAttributes(openingTag) {\n var attrs = {};\n var attrRegex = /([a-zA-Z_:][-a-zA-Z0-9_:.]*)\\s*=\\s*(\"([^\"]*)\"|'([^']*)')/g;\n var m;\n while ((m = attrRegex.exec(openingTag)) !== null) {\n attrs[m[1]] = (m[3] || m[4] || \"\").trim();\n }\n return attrs;\n}\n\nfunction normalizeFontFamily(ff) {\n if (!ff) return null;\n return ff.toLowerCase()\n .replace(/[\"']/g, \"\")\n .replace(/\\s*,\\s*/g, \",\")\n .replace(/\\s+/g, \" \")\n .trim();\n}\n\nfunction extractFontFamilyFromStyle(style) {\n if (!style || typeof style !== \"string\") return null;\n var low = style.toLowerCase();\n var idx = low.indexOf(\"font-family\");\n if (idx === -1) return null;\n var s = style.slice(idx);\n var colonIdx = s.indexOf(\":\");\n if (colonIdx === -1) return null;\n s = s.slice(colonIdx + 1);\n var semiIdx = s.indexOf(\";\");\n if (semiIdx !== -1) s = s.slice(0, semiIdx);\n return normalizeFontFamily(s);\n}\n\n// -------------------- Core logic (unchanged) --------------------\n// ... [functions: escRe, makeFlexibleRegex, findTextIndex, findEnclosingTag, \n// findAncestorWithFont, scanTagsForText, getTagAndFont, getFontForMultiline] ...\n\n// -------------------- Read inputs --------------------\nvar htmlRaw = ($json && typeof $json.html === \"string\") ? $json.html : \"\";\nvar htmlReal = unescapeHtmlEntities(htmlRaw);\n\n// -------------------- Build content list --------------------\nvar contentList = [];\n\nif ($json && Array.isArray($json.searchItems) && $json.searchItems.length) {\n for (var si = 0; si < $json.searchItems.length; si++) {\n var v = $json.searchItems[si];\n if (typeof v === \"string\" && v.trim().length) contentList.push(v.trim());\n }\n} else if ($json && typeof $json.Content === \"string\" && $json.Content.trim().length) {\n var parts = $json.Content.split(/\\r?\\n/);\n for (var p = 0; p < parts.length; p++) {\n var s = parts[p].trim();\n if (s) contentList.push(s);\n }\n} else {\n // Default: generic placeholders for validation\n contentList = [\n \"Sample Heading Text\",\n \"Sample body copy paragraph with multiple lines.\\n\\nWhy attend?\\n\\nLearn how to validate fonts in email content\\nUnderstand how font-family impacts branding\\nDiscover effective QA strategies\\nExplore accessibility considerations\\nGet answers in a live Q&A\",\n \"For immediate support, please contact us\",\n \"Let's Connect\",\n \"Privacy Policy\",\n \"You received this email because you are subscribed to updates.\",\n \"Company Name | Address Line | City, State ZIP\",\n \"Unsubscribe\"\n ];\n}\n\n// -------------------- Produce outputs --------------------\nvar items = [];\n\nfor (var ci = 0; ci < contentList.length; ci++) {\n var content = String(contentList[ci]);\n\n var result;\n if (/\\\\n|\\r?\\n/.test(content)) {\n result = getFontForMultiline(htmlReal, content);\n } else {\n var variants = [content];\n if (/\\s\\|\\s/.test(content)) variants.push(content.replace(/\\s*\\|\\s*/g, \" \"));\n result = null;\n for (var vi = 0; vi < variants.length; vi++) {\n var res = getTagAndFont(htmlReal, variants[vi]);\n if (res && (res.fontFamily || res.tagStructureReal)) { result = res; break; }\n }\n if (!result) result = { tagName: null, fontFamily: \"\", attrs: {}, tagStructureReal: null, anchorHref: null };\n }\n\n var tagStructureEsc = result.tagStructureReal ? escapeHtml(result.tagStructureReal) : \"Not Found\";\n\n items.push({\n json: {\n Content: content,\n \"Actual font family\": result.fontFamily || \"\",\n \"Tag name\": result.tagName || null,\n \"Tag snippet (escaped)\": tagStructureEsc,\n \"Anchor href\": result.anchorHref || null\n }\n });\n}\n\nreturn items;" }, "position": [ 304, 240 ] }, { "id": "38c84d7c-a939-4723-aebd-c2d77a1d1c53", "name": "Combine Font Inputs", "type": "merge", "params": {}, "position": [ 560, 160 ] }, { "id": "ff78c01e-fea3-4033-92fd-cd2af602e652", "name": "Extract Actual Font Family and Results", "type": "code", "params": { "jsCode": "/**\n * n8n Function node (ES5-friendly)\n * Validates Excel \"Expected font family\" against Actual font family parsed from Gmail HTML.\n * Falls back to parser-derived \"Actual font family\" when HTML parsing doesn't find a styled tag.\n *\n * Input: merged items (Excel rows + parser rows + Gmail HTML item)\n * Output: array of items in Excel template shape:\n * [{ json: { Content, \"Expected font family\", \"Actual font family\", Result } }, ...]\n */\n\n// -------------------- Collect items --------------------\nvar allItems = $items();\n\n// -------------------- Partition items; capture HTML --------------------\nvar excelRows = [];\nvar parserRows = [];\nvar htmlRaw = \"\";\n\nfor (var i = 0; i < allItems.length; i++) {\n var j = allItems[i].json || {};\n var keys = Object.keys(j);\n\n if (keys.indexOf(\"Content\") !== -1 && keys.indexOf(\"Expected font family\") !== -1) {\n excelRows.push(j);\n }\n\n if (keys.indexOf(\"Content\") !== -1 && keys.indexOf(\"Actual font family\") !== -1) {\n parserRows.push(j);\n }\n\n if (!htmlRaw && typeof j.html === \"string\" && j.html.indexOf(\"\");\n if (s !== -1 && e !== -1) {\n htmlRaw = mergedString.slice(s, e + \"\".length);\n }\n}\n\n// -------------------- Utilities --------------------\nfunction unescapeHtmlEntities(s) {\n if (!s) return \"\";\n return s\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/&/g, \"&\")\n .replace(/"/g, \"\\\"\")\n .replace(/'/g, \"'\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/&/g, \"&\")\n .replace(/"/g, \"\\\"\")\n .replace(/'/g, \"'\");\n}\nvar html = unescapeHtmlEntities(htmlRaw || \"\");\n\nfunction normalizeFontFamily(ff) {\n if (!ff) return null;\n return ff.toLowerCase()\n .replace(/[\"']/g, \"\")\n .replace(/\\s*,\\s*/g, \",\")\n .replace(/\\s+/g, \" \")\n .trim();\n}\n\nfunction compareFamilies(expectedRaw, actualRaw) {\n var expected = normalizeFontFamily(expectedRaw);\n var actual = normalizeFontFamily(actualRaw);\n if (!expected || !actual) return false;\n return actual.indexOf(expected) !== -1 || expected.indexOf(actual) !== -1;\n}\n\nfunction parseAttributes(openingTag) {\n var attrs = {};\n var attrRegex = /([a-zA-Z_:][-a-zA-Z0-9_:.]*)\\s*=\\s*(\"([^\"]*)\"|'([^']*)')/g;\n var m;\n while ((m = attrRegex.exec(openingTag)) !== null) {\n attrs[m[1]] = (m[3] || m[4] || \"\").trim();\n }\n return attrs;\n}\n\nfunction extractFontFamilyFromStyle(style) {\n if (!style || typeof style !== \"string\") return null;\n var low = style.toLowerCase();\n var idx = low.indexOf(\"font-family\");\n if (idx === -1) return null;\n var s = style.slice(idx);\n var colonIdx = s.indexOf(\":\");\n if (colonIdx === -1) return null;\n s = s.slice(colonIdx + 1);\n var semiIdx = s.indexOf(\";\");\n if (semiIdx !== -1) s = s.slice(0, semiIdx);\n return normalizeFontFamily(s);\n}\n\nfunction innerText(htmlFrag) {\n if (!htmlFrag) return \"\";\n var noTags = htmlFrag.replace(/<[^>]*>/g, \" \");\n return unescapeHtmlEntities(noTags).replace(/\\s+/g, \" \").trim();\n}\n\nfunction escRe(s) { return s.replace(/[-/\\\\^$*+?.()|[\\]{}]/g, \"\\\\$&\"); }\n\nfunction makeFlexibleRegex(text) {\n var t = String(text).replace(/&/g, \"&\").replace(/\\s+/g, \" \").trim();\n t = escRe(t);\n t = t.replace(/\\s+/g, \"\\\\s+\");\n t = t.replace(/\\\\\\|/g, \"(?:\\\\s*\\\\|\\\\s*|\\\\s+)\");\n return t;\n}\n\nfunction findTextIndex(htmlStr, text) {\n var pattern = makeFlexibleRegex(text);\n var re = new RegExp(pattern, \"i\");\n var m = re.exec(htmlStr);\n return m ? m.index : -1;\n}\n\nfunction findEnclosingTag(htmlStr, idx) {\n var openAngleIdx = htmlStr.lastIndexOf(\"<\", idx);\n if (openAngleIdx === -1) return null;\n var closeAngleIdx = htmlStr.indexOf(\">\", openAngleIdx);\n if (closeAngleIdx === -1) return null;\n\n var openingTag = htmlStr.slice(openAngleIdx, closeAngleIdx + 1);\n var tagMatch = openingTag.match(/^<\\s*([a-zA-Z0-9]+)\\b/);\n var tagName = tagMatch ? tagMatch[1].toLowerCase() : null;\n var attrs = parseAttributes(openingTag);\n\n var closingTag = tagName ? (\"\") : null;\n var endIdx = closingTag ? htmlStr.indexOf(closingTag, idx) : -1;\n var snippet = (endIdx !== -1) ? htmlStr.slice(openAngleIdx, endIdx + closingTag.length) : openingTag;\n\n return { tagName: tagName, attrs: attrs, tagStructureReal: snippet };\n}\n\nfunction findAncestorWithFont(htmlStr, idx) {\n var preferred = [\"h1\",\"h2\",\"h3\",\"p\",\"li\",\"td\",\"div\"];\n for (var k = 0; k < preferred.length; k++) {\n var t = preferred[k];\n var openIdx = htmlStr.lastIndexOf(\"<\" + t, idx);\n if (openIdx === -1) continue;\n var closeOpen = htmlStr.indexOf(\">\", openIdx);\n if (closeOpen === -1) continue;\n\n var closingTag = \"\";\n var endIdx = htmlStr.indexOf(closingTag, idx);\n if (endIdx === -1) continue;\n\n if (closeOpen < idx && idx < endIdx) {\n var openingTag = htmlStr.slice(openIdx, closeOpen + 1);\n var attrs = parseAttributes(openingTag);\n var ff = extractFontFamilyFromStyle(attrs.style || \"\");\n if (ff) return ff;\n }\n }\n return null;\n}\n\nfunction scanTagsForText(htmlStr, targetText, tagNames) {\n for (var ti = 0; ti < tagNames.length; ti++) {\n var t = tagNames[ti];\n var re = new RegExp(\"<\" + t + \"[^>]*>([\\\\s\\\\S]*?)\", \"gi\");\n var m;\n while ((m = re.exec(htmlStr)) !== null) {\n var snippet = m[0];\n var open = snippet.match(new RegExp(\"^<\" + t + \"[^>]*>\", \"i\"));\n var openingTag = open ? open[0] : \"\";\n var attrs = parseAttributes(openingTag);\n var ff = extractFontFamilyFromStyle(attrs.style || \"\");\n var inner = innerText(snippet);\n\n var pattern = new RegExp(makeFlexibleRegex(targetText), \"i\");\n if (pattern.test(inner)) {\n return ff || \"\";\n }\n }\n }\n return \"\";\n}\n\nfunction getActualFontFromHtml(htmlStr, content) {\n var isMultiLine = /\\\\n|\\r?\\n/.test(content);\n if (isMultiLine) {\n var raw = String(content).replace(/\\\\n/g, \"\\n\");\n var lines = raw.split(/\\r?\\n/).map(function(s){return s.trim();}).filter(function(s){return !!s;});\n for (var j = 0; j < lines.length; j++) {\n var ff1 = getActualFontFromHtml(htmlStr, lines[j]);\n if (ff1) return ff1;\n }\n return \"\";\n }\n\n var variants = [content];\n if (/\\s\\|\\s/.test(content)) variants.push(content.replace(/\\s*\\|\\s*/g, \" \"));\n\n for (var vi = 0; vi < variants.length; vi++) {\n var t = variants[vi];\n var idx = findTextIndex(htmlStr" }, "position": [ 832, 160 ] }, { "id": "605c61d4-dff4-4e9e-a667-857cabbd6da7", "name": "Load Expected Content and Font Family", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "id", "value": "=// Parameters provided by user in node config\nconst sheetId = this.getNodeParameter(\"sheetId\", 0) || \"YOUR_SPREADSHEET_ID\";\nconst sheetName = this.getNodeParameter(\"sheetName\", 0) || \"Sheet1\";\n\nconst { google } = require(\"googleapis\");\nconst sheets = google.sheets({ version: \"v4\", auth });\n\nconst response = await sheets.spreadsheets.values.get({\n spreadsheetId: sheetId,\n range: sheetName,\n});\n\nreturn response.data.values.map(row => ({ json: { row } }));" }, "documentId": { "__rl": true, "mode": "url", "value": "=https://docs.google.com/spreadsheets/d//edit" } }, "position": [ 176, 112 ] }, { "id": "771fae7e-0349-4bc3-91fe-c3b3cc84b460", "name": "Log Font Checks to Excel", "type": "integration", "params": { "columns": { "value": { "Result": "={{ $json.Result }}", "Content": "={{ $json.Content }}", "Actual font family": "={{ $json['Actual font family'] }}", "Expected font family": "={{ $json['Expected font family'] }}" }, "schema": [ { "id": "Content", "type": "string", "display": true, "required": false, "displayName": "Content", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Expected font family", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Expected font family", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Actual font family", "type": "string", "display": true, "required": false, "displayName": "Actual font family", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Result", "type": "string", "display": true, "required": false, "displayName": "Result", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [ "Expected font family" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "appendOrUpdate", "sheetName": { "__rl": true, "mode": "id", "value": "=// Parameters provided by user in node config\nconst sheetId = this.getNodeParameter(\"sheetId\", 0) || \"YOUR_SPREADSHEET_ID\";\nconst sheetName = this.getNodeParameter(\"sheetName\", 0) || \"Sheet1\";\n\nconst { google } = require(\"googleapis\");\nconst sheets = google.sheets({ version: \"v4\", auth });\n\nconst response = await sheets.spreadsheets.values.get({\n spreadsheetId: sheetId,\n range: sheetName,\n});\n\nreturn response.data.values.map(row => ({ json: { row } }));" }, "documentId": { "__rl": true, "mode": "url", "value": "=https://docs.google.com/spreadsheets/d//edit" } }, "position": [ 1088, 160 ] } ] }

Validate email font families from Gmail with Google Sheets