Production lead-cleaning pipeline in Google Sheets: turns raw leads from web forms, Meta ads and purchased lists into scored, deduplicated HubSpot contacts.
Includes JSON extraction (4 formats), contact normalization (200+ country phone codes), 0–100 quality scoring, duplicate fingerprinting, human review queue, and HubSpot sync with retry + full audit logs.
Built for big data: batched I/O, chunked processing, re-run-safe stages within Apps Script's 6-minute limit. Ships self-installing setup, one-click menu, demo generator and GitHub docs.