skills.rest
TomGranot
TomGranotCOMMUNITY
Explore all skills by this author →
𝕏@TomGranotGitHub

merge-duplicate-companies

Identify duplicate HubSpot company records by domain and name, exporting audit CSVs.

58|16|Updated Mar 26, 2026
Search Tags:#audit#csv#deduplication#hubspot#merging#domain#companies
One-click install
npx skills add https://github.com/TomGranot/hubspot-admin-skills --skill merge-duplicate-companies
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: merge-duplicate-companies
Source: https://github.com/TomGranot/hubspot-admin-skills/tree/main/skills/merge-duplicate-companies
Command: npx skills add https://github.com/TomGranot/hubspot-admin-skills --skill merge-duplicate-companies

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires requests, python-dotenv, and includes scripts (resource) components.

What problem does it solve?

Duplicate company records across HubSpot degrade reporting accuracy, create inconsistent data, and slow down cleanup projects. This skill identifies duplicates by domain and by name, exports audit CSVs for review, and guides users through the merging process in a controlled, auditable way.

Core Features & Use Cases

  • Identify duplicate companies by domain and by name.
  • Export CSV audit logs for review, including domain- and name-based duplicate groups with relevant fields.
  • Provide a structured, four-stage workflow (Plan -> Before State -> Execute -> After State) and clear guidance for manual merges since HubSpot has no bulk merge API.
  • Use case: during quarterly data hygiene cycles or portal migrations, consolidate multiple records representing the same real-world company.

Quick Start

Run the Before State workflow to fetch all companies, generate duplicate-domain and duplicate-name CSVs, and review results before merging.

Frequently Asked Questions about merge-duplicate-companies

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I identify duplicate companies in HubSpot for a data cleanup project?▼

To identify duplicate HubSpot companies, this skill fetches records and audits them by domain and name, exporting structured CSV audit logs for review. It guides manual merges using a four-stage workflow since HubSpot lacks a bulk merge API.

Can I bulk merge duplicate HubSpot company records automatically?▼

You cannot bulk merge HubSpot companies automatically because HubSpot has no bulk merge API for company records. This skill works around the limitation by exporting duplicate groups to CSVs and guiding controlled, manual merges.

How do I deduplicate HubSpot companies by domain during a portal migration?▼

Deduplicating HubSpot companies by domain involves fetching all company records, grouping duplicates based on matching domains, and exporting the results to CSV files. This skill automates the audit and documents duplicates before manual merging.

What is the best way to audit duplicate company records before merging in HubSpot?▼

The best way to audit duplicate companies is using a structured four-stage workflow: Plan, Before State, Execute, and After State. This skill generates domain- and name-based duplicate CSVs to review before performing any manual merges.

Do I need Python to export duplicate HubSpot companies to a CSV?▼

Yes, you need Python to run this skill's scripts, which require the requests and python-dotenv libraries. It uses these dependencies to fetch HubSpot company data and generate CSV audit logs for duplicate review.

Related Skills

Explore More Data & Analytics Skills→
abdullahbeamabdullahbeam
2

hubspot-create-company

Create company records in HubSpot CRM with required name and optional fields.

Community
Intermediate
1479089714790897
7

kwp-small-business-crm-cleanup

Audit HubSpot CRM data for stale deals, duplicate contacts, and missing fields.

Community
Advanced
getaero-iogetaero-io
23

deepline-crm-hygiene

Automate CRM duplicate detection, field validation, and data cleanup via HubSpot API.

Official
Intermediate
wyre-technologywyre-technology
39

HubSpot Companies

Search, create, and update company records in HubSpot CRM.

Official
Intermediate