Validate email font families from Gmail with Google Sheets Workflow Solution

Workflow overview

Why this workflow matters

Relevant for managed services and support workflows. Supports knowledge capture and document intelligence use cases.

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 AlekSystem 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)

Best fit

Need another direction?