Validate email font families from Gmail with Google Sheets

How it works

• Load Expected Content + Expected Font Family from Google Sheets.
• Parse the email HTML to locate the matching content block.
• Use a JavaScript/HTML extraction node to read the actual font-family applied to that content.
• Merge expected and actual values.
  Compare Expected Font vs Actual Font to produce a Result (Match / Mismatch).
• Log Actual Font + Result back into Google Sheets as part of the QA output.

Setup steps

• Google Sheets
  Create a sheet with columns:SectionId, Content, ExpectedFontFamily, ActualFontFamily, Result. Populate SectionId + ExpectedContent for each content block you want to verify.
• Email HTML Source
  Use a Gmail node to pull message HTML or use HTTP Request/Read Binary File + HTML/JS to supply the HTML.
• Extraction Logic (JS/HTML)
  Use HTML parsing or a JS Function node to locate the HTML element containing the content string. From the matched element, extract the computed font-family. Clean, normalize, and standardize font names for accurate comparison. Return the extracted value as ActualFontFamily.
• Merge & Compare
  Merge the Google Sheets expected records with the extracted actual font data using SectionId as the key. In the Code (JS) node, compare ExpectedFontFamily vs ActualFontFamily and set Result to Match if equal (or meets your rule), otherwise Mismatch.
• Write back
  Use Google Sheets to update ActualFontFamily and Result for each row.

Requirements

• n8n with access to: Google Sheets, Code/HTML, and (optionally) Gmail nodes.
• A Google Sheets document with at least these columns:

SectionId (or Key)
Content
ExpectedFontFamily
ActualFontFamily (output)
Result (output: Match / Mismatch)