Crm Data Quality

If you've ever inherited a HubSpot CRM with duplicate contacts, half-empty fields, and "Acme Inc" spelled six different ways, this is your cleanup toolkit. It wraps the HubSpot CLI to find incomplete records with property filters, normalize values in bulk through JSONL pipes, and merge duplicates with the native merge API. The deduplication logic is straightforward but requires pagination to catch duplicates that span API pages, which the docs walk through clearly. Everything routes through a dry run, digest, and confirm flow borrowed from the bulk-operations skill, so you won't accidentally merge 500 contact pairs without a preview. Merges are irreversible, but the history command gives you an audit trail.

skills.sh installs: 1.9K
GitHub stars: 29
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add hubspot/agent-cli-skills --skill crm-data-quality --agent claude-code

Installs into .claude/skills of the current project.

Files

Read bulk-operations/SKILL.md first — JSONL piping, batch read, pagination, and dry-run/digest/confirm gating apply to every command below.

Property discovery

Don't guess property names. List them:

hubspot properties list --type contacts --format table
hubspot properties list --type contacts | jq -c 'select(.type=="enumeration") | {name, label}'

Same for --type companies, deals, or any custom type (hubspot objects types).

1. Find incomplete records

!name = NOT_HAS_PROPERTY (missing or empty). Bare name = HAS_PROPERTY. Within one --filter, chain with AND; multiple --filter flags are OR'd.

hubspot objects search --type contacts --filter "!email" --properties firstname,lastname,company
hubspot objects search --type contacts --filter "!phone AND !mobilephone" --properties email
hubspot objects search --type contacts --filter "!hubspot_owner_id" --properties email,lifecyclestage

For >100 results, use the pagination loop from bulk-operations.