crm-data-cleaner
luigi08001 제작
Git & GitHub요약
Deduplicate, normalize, and enrich CRM contacts and companies.
설명
이 스킬이 하는 일
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.
사용 시점
- 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
예시 워크플로
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
요구 사항
- 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)
설치
clawhub install luigi08001/crm-data-cleanerCLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.