crm-data-cleaner
oleh luigi08001
Git & GitHubRingkasan
Deduplicate, normalize, and enrich CRM contacts and companies.
Deskripsi
Apa yang Dilakukan Skill Ini
Cleans CRM contact and company records through deduplication, format normalization, and external data enrichment. Works with HubSpot, Salesforce, and Pipedrive via their APIs or CSV export/import workflows. Instruction-only, no code execution.
Covers deduplication, normalization, and enrichment in one workflow rather than requiring separate tools for each step.
Kapan Menggunakannya
- Merging duplicate contacts after a bulk HubSpot import
- Standardizing phone numbers and email formats across a Salesforce org
- Filling in missing job titles using Apollo or Clearbit enrichment
- Running a data quality audit before launching an email campaign
- Normalizing company names in a Pipedrive export to match standard legal entities
Contoh Alur Kerja
User asks: We just imported 5,000 contacts from a trade show CSV into HubSpot and need to find duplicates and standardize phone numbers.
- 1
Export contacts from HubSpot with email, phone, first name, last name, and company fields
- 2
Identify duplicate candidates using email-based exact matching and fuzzy name plus company matching
- 3
Present merge recommendations grouped by confidence level: high, medium, and low
- 4
Normalize phone numbers to E.164 format using the HubSpot batch update API
- 5
Trigger HubSpot native duplicate merge for confirmed high-confidence pairs
Cleaned contact list with duplicates merged, phone numbers standardized, and a summary of remaining medium and low-confidence duplicates for manual review
Persyaratan
- HUBSPOT_ACCESS_TOKEN environment variable
- SALESFORCE_ACCESS_TOKEN environment variable (if using Salesforce)
- CLEARBIT_API_KEY environment variable (if using Clearbit enrichment)
- APOLLO_API_KEY environment variable (if using Apollo enrichment)
Instalasi
clawhub install luigi08001/crm-data-cleanerJalankan perintah CLI-nya, atau tempel prompt ke Claude Code, Cursor, Codex, atau coding agent apa pun yang Anda pakai.