CleanStack
DashboardNew PipelineTemplates
TemplatesHubSpot CRM Cleaner
CRM143 uses

HubSpot CRM Cleaner

Standardizes contact exports from HubSpot: deduplicates by email, strips whitespace, coerces phone to string, fills missing country.

Expected Input Schema

email·str
phone·str
company·str
country·str
last_name·str
first_name·str
lifecycle_stage·str

Transform Rules (5)

1
trim whitespaceemail

Email fields from form inputs often carry leading/trailing spaces that break matching.

2
drop nullsemail

Contacts without email are unusable for CRM outreach and skew deliverability metrics.

3
deduplicateemail

Duplicate emails create redundant contacts and inflate list size.

4
type castphone
target_type: str

Phone numbers must be strings to preserve leading zeros and formatting.

5
fill nullscountryvalue: US

Default missing country to US for domestic campaign segmentation.