Templates / RevOps · Clean & dedupe
Standardize and normalize CRM fields
Normalize industry, country, and employee count across every HubSpot record.
01 Companies
One row per HubSpot company. Normalize Country + Normalize Industry produce canonical values, Find Missing Data fills empty cells via AI lookup, and Update HubSpot Company writes the standardized fields back to the CRM.
 HubSpot Companies | Company name | Country/Region | Industry |  Normalize Country | Country (Normalized) | Normalize Industry | Find Missing Data | Update HubSpot Company |
|---|---|---|---|---|---|---|---|---|
| HubSpot Co. | Voltio | USA | B2B SaaS | Normalized | US · United States | COMPUTER_SOFTWARE | Skipped | Updated |
| HubSpot Co. | Lenza | germany | saas | Normalized | DE · Germany | COMPUTER_SOFTWARE | Skipped | Updated |
| HubSpot Co. | Pulsenote | United Kingdom | Normalized | GB · United Kingdom | COMPUTER_SOFTWARE | Found | Updated | |
| HubSpot Co. | Trackbeam | us | Fintech | Normalized | US · United States | FINANCIAL_SERVICES | Skipped | Updated |
| HubSpot Co. | Cloud Pivot | B2B SaaS | Missing | ○ | COMPUTER_SOFTWARE | Found · CA | Updated | |
| HubSpot Co. | Mosaic Labs | USA | agency | Normalized | US · United States | MARKETING_AND_ADVERTISING | Skipped | Updated |
| HubSpot Co. | Northwind | USA | B2B SaaS | Normalized | US · United States | COMPUTER_SOFTWARE | Skipped | Updated |
02 Contacts
One row per HubSpot contact. The same normalization passes apply to job title and seniority so segments and routing can rely on a clean vocabulary across every contact in the CRM.
| HubSpot Contacts | Full Name | Job Title | Normalize Title | Title (Canonical) | Seniority | Update HubSpot Contact |
|---|---|---|---|---|---|---|
| HubSpot Co. | Mara Jensen | VP, Sales | Normalized | VP Sales | VP | Updated |
| HubSpot Co. | Diego Romero | Chief Revenue Officer | Normalized | CRO | C-level | Updated |
| HubSpot Co. | Anya Patel | CEO & Founder | Normalized | CEO | C-level | Updated |
| HubSpot Co. | Kai Müller | Senior Manager, Sales Ops | Normalized | Sales Ops Manager | Manager | Updated |
| HubSpot Co. | Sara Chen | Director Sales | Normalized | Sales Director | Director | Updated |
How the workflow runs
Each step is a Baseloop action chained on a table. Clone the template and the whole sequence runs on your data, no wiring, no glue code.
- 01
Pull every HubSpot company (or a target subset) into a Baseloop Companies table.
- 02
AI normalizes the country into ISO codes + canonical names so reporting groups every "USA / United States / us" together.
- 03
AI normalizes the industry into your canonical taxonomy (matches HubSpot enum or your custom list).
- 04
For records missing industry or country, AI does a one-shot lookup against the company name + domain to fill the gap.
- 05
Push the normalized industry, country, and any newly-found fields back to the HubSpot company record.
- 06
Repeat across the Contacts table for any contact-level normalization (job titles, seniority).
What this gets you
Reporting, segmentation, and routing finally work because every company in HubSpot uses the same vocabulary. No more "USA" vs "United States" vs "us"; no more 14 ways to say "B2B SaaS".
Integrations used
This workflow connects to 2 Baseloop integrations. Click any to see all its actions.
Build this on Baseloop today
Clone the template and the whole flow runs on your data in minutes. Free to start, no credit card.
Other clean & dedupe templates
Bulk-clean HubSpot legacy → Salesforce
Clean HubSpot legacy data, dedupe against Salesforce, forward only the survivors.
View templateFind broken records in your CRM
Audit every record for dead domains, bad emails, and missing data. Auto-route fixes.
View templateAlways-on re-verification of CRM contacts
Catch HubSpot contacts who moved jobs, route the new company for enrichment.
View template