← All buildouts

Marketing & Lead Generation · Make.com, Zapier, Google Apps Script, GoHighLevel, Shape CRM

Lead Data Pipelines

Built once — Deployed twice — clean leads, right CRM

Two teams had the same problem: expensive-to-generate leads leaking or arriving as junk between their tools and their CRM. A marketing company's visitor-identification pixel produced contact records with piles of possible emails/phones in inconsistent formats; a lending team's four website forms had field names that didn't match the CRM, mixed verified and unverified prospects, and lost paid-search leads in transit. We built reusable lead-data pipelines (Make.com + Zapier + Google Apps Script) that clean the data (split and rank multiple emails — verified first, business next, personal last — and normalize phones for SMS), route by quality (verified vs unverified into separate CRM sources), map every field against the live CRM (GoHighLevel for marketing, Shape CRM for lending), and apply geo filters. Built once for the marketing team and cloned for the lending team with minimal changes. The Apps Script cleaning job runs ~141 executions in 7 days. Runs in each client's own accounts; identities anonymized.

Built with: Make.com, Zapier, Google Apps Script, GoHighLevel, Shape CRM