← Back to Skills Marketplace
tomgranot

Merge Duplicate Companies

by TomGranot · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
109
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install merge-duplicate-companies
Description
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...
Usage Guidance
This skill appears to do what it says (enumerate HubSpot companies and produce CSVs), but the registry metadata incorrectly omits that it requires a HubSpot access token and a Python runtime. Before installing or running: 1) Verify the author/source and prefer a trusted origin. 2) Confirm you need to provide HUBSPOT_ACCESS_TOKEN; only grant the minimal scope required (crm.objects.companies.read) to a private app and avoid using a high-privilege token. 3) Run the script in a safe environment (local or ephemeral container) and inspect the generated CSVs before performing any merges. 4) Because merging is manual and irreversible, back up data or test in a sandbox. 5) Ask the publisher to update registry metadata to declare required env vars and runtime dependencies so the permission surface is clear. If you cannot verify these items, treat the skill with caution.
Capability Analysis
Type: OpenClaw Skill Name: merge-duplicate-companies Version: 1.0.0 The skill is designed to identify duplicate HubSpot company records by domain and name, providing an audit trail via local CSV files. The Python code in SKILL.md and scripts/before.py performs standard API pagination to fetch company data and groups them locally; it does not attempt to exfiltrate data to external endpoints or perform unauthorized modifications. The instructions emphasize manual merging due to HubSpot API limitations, ensuring human oversight for irreversible actions.
Capability Assessment
Purpose & Capability
The name/description match the actual behavior: the script calls the HubSpot API to enumerate companies, finds duplicates by domain/name, and writes CSV audit logs. That functionality is coherent with the stated purpose.
Instruction Scope
The SKILL.md and scripts confine actions to discovery and local CSV export. They only read a .env for HUBSPOT_ACCESS_TOKEN, call api.hubapi.com, and write CSVs under ./data — they do not access unrelated system files or external endpoints beyond HubSpot.
Install Mechanism
There is no install spec in the registry; the script has a comment listing Python dependencies (requests, python-dotenv) and requires Python 3.10+. This is not automatically installed by the platform, so a user must install packages manually. No downloads from unknown URLs or archive extraction are present.
Credentials
The code and SKILL.md require a HubSpot access token (HUBSPOT_ACCESS_TOKEN) and a .env file, but the skill metadata/registry declares no required env vars or primary credential. This mismatch is a red flag: the skill will fail without the token, and the registry understates the level of sensitive access required.
Persistence & Privilege
The skill does not request permanent inclusion (always: false) and does not modify other skills or system settings. It writes only CSV audit files under a local data directory. Autonomous invocation is allowed by default but is not independently suspicious here.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install merge-duplicate-companies
  3. After installation, invoke the skill by name or use /merge-duplicate-companies
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
- Initial release of the "merge-duplicate-companies" skill. - Identifies duplicate company records in HubSpot by both domain and name. - Exports prioritized audit CSVs for thorough review before merging. - Provides a staged workflow: planning, duplicate discovery, audit export, and manual merging guidance. - Clarifies HubSpot’s lack of a bulk merge API, requiring third-party tools or manual UI for merges. - Includes detailed guidance and Python sample code for audit and discovery stages.
Metadata
Slug merge-duplicate-companies
Version 1.0.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is 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... It is an AI Agent Skill for Claude Code / OpenClaw, with 109 downloads so far.

How do I install Merge Duplicate Companies?

Run "/install merge-duplicate-companies" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Merge Duplicate Companies free?

Yes, Merge Duplicate Companies is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Merge Duplicate Companies support?

Merge Duplicate Companies is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Merge Duplicate Companies?

It is built and maintained by TomGranot (@tomgranot); the current version is v1.0.0.

💬 Comments