Merge Duplicate Companies

Identify duplicate company records by domain and name, export audit CSVs for review, and guide merging. API for discovery, third-party tools or manual UI for merging (HubSpot has no bulk merge API).

81 stars 19 forksSoftware Development Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add TomGranot/hubspot-admin-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add TomGranot/hubspot-admin-skills --skill merge-duplicate-companies
Manual install
git clone --depth 1 https://github.com/TomGranot/hubspot-admin-skills.git /tmp/hubspot-admin-skills
mkdir -p ~/.claude/skills
cp -r /tmp/hubspot-admin-skills/skills/merge-duplicate-companies ~/.claude/skills/merge-duplicate-companies

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Merge Duplicate Companies

## Purpose

Duplicate company records fragment contacts, deals, and engagement history across multiple records for the same real-world company. This leads to inaccurate reporting, broken associations, sales confusion, and workflow failures. This skill identifies duplicates by domain and by name, exports prioritized audit CSVs, and guides the user through merging.

## Prerequisites

- A HubSpot service key (`HUBSPOT_ACCESS_TOKEN` in `.env`; an existing legacy private app token also works) with `crm.objects.companies.read` scope
- Python 3.10+ with `uv` for package management
- A `.env` file containing `HUBSPOT_ACCESS_TOKEN`
- Super Admin permissions for merging in the HubSpot UI

## Scripts

Script paths are relative to this skill's directory. Run them from your project directory so `.env`, `data/`, and `reports/` resolve there: prefix each path with wherever this skill is installed (`skills/merge-duplicate-companies/` in a clone of the repo).

| Stage | Script | Run with |
|-------|--------|----------|
| Before | [`scripts/before.py`](./scripts/before.py) | `uv run scripts/before.py` |

Only the detection stage is scripted: `before.py` inventories companies and flags duplicate candidates by domain and normalized name. Merging itself happens one pair at a time in the UI (see Key Constraint).

## Key Constraint
Read the full skill on GitHub

Details

Skill name
merge-duplicate-companies
Path
skills/merge-duplicate-companies/SKILL.md
License
MIT
Repo updated
10 November 2026

FAQ

What does the Merge Duplicate Companies skill do?

Identify duplicate company records by domain and name, export audit CSVs for review, and guide merging. API for discovery, third-party tools or manual UI for merging (HubSpot has no bulk merge API).

How do I install the Merge Duplicate Companies skill?

Claude Code plugin: /plugin marketplace add TomGranot/hubspot-admin-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Merge Duplicate Companies popular?

It lives in TomGranot/hubspot-admin-skills, which has 81 GitHub stars and 19 forks, and is included in 1 curated skill list.

Related skills

Assign Unowned Contacts

81

TomGranot/hubspot-admin-skills

Assign an owner to marketing contacts that have no owner. Ensures every marketable contact has accountability for follow-up, proper lead routing, and accurate owner-based reporting.

Marketing, Sales & BusinessIn 1 list19

Audit API Usage

81

TomGranot/hubspot-admin-skills

Inventory the integrations, service keys, legacy private apps, and internal tooling that call HubSpot APIs, and flag anything on legacy v1-v4 endpoints or legacy app architecture ahead of HubSpot's 2027 cutoffs. Produces a migration checklist to date-based API versions and service keys.

Software DevelopmentIn 1 list19

Backfill Geo Data

81

TomGranot/hubspot-admin-skills

Enrich missing geographic data (country, state, city) on contacts and companies using HubSpot workflows, external data providers, or IP-based geolocation.

Productivity & NotesIn 1 list19

Reassign Deactivated Owners

81

TomGranot/hubspot-admin-skills

Reassign contacts and companies from deactivated team members to active owners. Fully automated via the HubSpot Owners API and Batch Update API. Includes territory analysis for informed reassignment decisions.

Software DevelopmentIn 1 list19

Suppress Hard Bounced

81

TomGranot/hubspot-admin-skills

Identify and suppress hard-bounced contacts to protect email sender reputation. Hybrid approach: API for discovery and audit, manual UI for suppression (hs_marketable_status is read-only via API).

Software DevelopmentIn 1 list19

Ponytail Review

121

theguysudo/ENZO

Code review focused exclusively on over-engineering. Finds what to delete: reinvented standard library, unneeded dependencies, speculative abstractions, dead flexibility. One line per finding: location, what to cut, what replaces it. Use when the user says "review for over-engineering", "what can we delete", "is this over-engineered", "simplify review", or invokes /ponytail-review. Complements correctness-focused review, this one only hunts complexity.

Software Development29

Browse the most popular Claude skills, all software development skills, or write your own with the skills generator.