Validate email hero images with Gmail, Dropbox, OCR.Space and Google Sheets

How it works

Expected Image Download The expected image’s Dropbox URL is passed directly into an HTTP Request node, which downloads the image as binary data.

Actual Image Extraction The HTML node extracts the src of the image from the email (e.g., hero image or other targeted image sections). This src is passed into another HTTP node to download the actual email image in binary format.

OCR Processing Both binary images are sent separately to OCR.Space API via POST requests. OCR returns extracted text for each image.

Comparison A JS node compares the Expected Image Text vs Actual Image Text. If the texts match, the result is marked Match; otherwise Mismatch.

Write Back to Google Sheets The workflow writes ExpectedText, ActualText, and Result back into the Google Sheet, creating a clear audit trail for validation.

Setup steps 1. Google Sheets Create a sheet with the following columns:

SectionId ExpectedImageURL ExpectedText ActualText (output) Result (output)