Skip to content
TakoAPI
Back to skills

crm-data-cleaner

by luigi08001

Git & GitHub
—Not yet rated
Your rating

Brief

Deduplicate, normalize, and enrich CRM contacts and companies.

Description

What This Skill Does

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.

When to Use It

  • 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

Example Workflow

INPUT

User asks: We just imported 5,000 contacts from a trade show CSV into HubSpot and need to find duplicates and standardize phone numbers.

AGENT
  1. 1

    Export contacts from HubSpot with email, phone, first name, last name, and company fields

  2. 2

    Identify duplicate candidates using email-based exact matching and fuzzy name plus company matching

  3. 3

    Present merge recommendations grouped by confidence level: high, medium, and low

  4. 4

    Normalize phone numbers to E.164 format using the HubSpot batch update API

  5. 5

    Trigger HubSpot native duplicate merge for confirmed high-confidence pairs

OUTPUT

Cleaned contact list with duplicates merged, phone numbers standardized, and a summary of remaining medium and low-confidence duplicates for manual review

Requirements

  • 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)

Installation

clawhub install luigi08001/crm-data-cleaner

Run the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.

Links