Standardize Geo Values
Skill ActiveConvert inconsistent country and state/region formats to standardized values across contacts and companies. Ensures geographic segmentation works reliably.
To ensure reliable geographic segmentation and reporting in HubSpot by converting all country and state/region values to standardized formats.
Features
- Standardize country values (e.g., US, USA to United States)
- Standardize state/region values (e.g., NY to New York)
- API-driven batch updates for large datasets
- Before and after audit scripts for verification
- Guidance on preventing future inconsistencies
Use Cases
- When inconsistent country abbreviations are breaking HubSpot list filters
- Before running region-specific marketing campaigns or reports
- To clean up imported data with varying geographic formats
- As part of a broader CRM data hygiene initiative
Non-Goals
- Filling in missing country or state data (enrichment)
- Validating address accuracy beyond format standardization
- Handling international address components beyond country and state/region
Workflow
- Gather requirements on desired standard formats and integration constraints
- Run 'before' script to audit current non-standard values
- Execute 'execute' script or manually update records via HubSpot UI
- Run 'after' script to verify all non-standard values have been cleared
- Configure HubSpot forms and import templates to prevent future inconsistencies
Practices
- Data Quality
- CRM Administration
- Automation
Prerequisites
- HubSpot CRM access with API token
- Python 3.10+
- `hubspot-api-client` and `python-dotenv` installed
Documentation
- info:Configuration & parameter referenceThe SKILL.md outlines required information and decision points but does not explicitly document all parameters or default precedence for configuration settings beyond the initial interview questions.
Maintenance
- warning:Dependency ManagementThe skill uses Python dependencies but lacks a lockfile for precise versioning and vulnerability management.
Security
- warning:Secret ManagementThe HubSpot API token is loaded via `.env` and `python-dotenv`, but there is a risk of accidental leakage if not handled carefully, and no specific checks are in place to prevent this.
Code Execution
- warning:ValidationThe Python scripts perform API requests but lack explicit schema validation for inputs and outputs, relying on the HubSpot API's implicit validation.
- warning:Error HandlingThe Python scripts have basic retry logic for rate limiting but lack comprehensive error categorization, user-friendly reporting, and structured error handling for API responses.
Compliance
- info:GDPRThe skill operates on contact and company data, which may include personal information, but it does not submit this data to third parties or perform extra sanitization beyond what the HubSpot API provides.
Errors
- warning:Actionable error messagesThe Python scripts have basic error handling for API requests but do not provide detailed, user-friendly error messages with remediation steps for all failure scenarios.
Execution
- warning:Pinned dependenciesThe Python scripts declare minimum dependency versions but do not pin exact versions or use a lockfile, which can lead to inconsistencies.
Scope
- info:Dry-run previewWhile the script performs batch updates, there is no explicit dry-run mode to preview changes before execution; however, the 'before' and 'after' scripts provide a manual review mechanism.
Protocol
- warning:Idempotent retry & timeoutsThe script includes retry logic for API rate limits but lacks hard timeouts for individual API calls and does not guarantee idempotency for batch updates beyond what the API provides.
Installation
First, add the marketplace
/plugin marketplace add TomGranot/hubspot-admin-skills/plugin install hubspot-admin-skills@hubspot-admin-skillsQuality Score
Trust Signals
Similar Extensions
Project Session Manager
100Worktree-first dev environment manager for issues, PRs, and features with optional tmux sessions
Public Google Drive
100Create public Google Docs or Google Sheet files without requiring OAuth. Use this skill to create and edit Google Docs and Sheets, no Google sign-in required. Documents are viewable at shareable links. Registration is automatic on first use.
Oh My Claudecode
100Process-first advisor routing for Claude, Codex, or Gemini via `omc ask`, with artifact capture and no raw CLI assembly
Use My Browser
100Use when work depends on the user's live browser session or visible rendered state rather than static fetches, especially for browser debugging contexts or DevTools-selected elements or requests, logged-in dashboards or CMS flows, localhost apps, forms, uploads, downloads, media inspection, DOM or iframe inspection, Shadow DOM, or browser failures that look like soft 404s, auth walls, anti-bot checks, or rate limits.
X Twitter Scraper
100Use when the user needs X (Twitter) data or confirmation-gated X actions through Xquik: tweet search, user lookup, follower extraction, media download, monitoring, webhooks, MCP, SDKs, posting, likes, DMs, and profile updates. Requires a Xquik API key. Never ask for X login material.
Slack
100Use the Slack tool to react, pin/unpin, send, edit, delete messages, or fetch Slack member info.