crm-data-cleaner
di luigi08001
Git & GitHubSintesi
Deduplicate, normalize, and enrich CRM contacts and companies.
Descrizione
Cosa fa questa skill
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.
Quando usarla
- 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
Esempio di workflow
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
Requisiti
- 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)
Installazione
clawhub install luigi08001/crm-data-cleanerEsegui il comando CLI oppure incolla il prompt in Claude Code, Cursor, Codex o nell'agente di coding che usi.