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

standardize-geo-values

Standardize country and state values to canonical names in HubSpot CRM.

58|16|Updated Mar 26, 2026
Search Tags:#hubspot#data-quality#state#standardize#data-cleanup#country#geo-values
One-click install
npx skills add https://github.com/TomGranot/hubspot-admin-skills --skill standardize-geo-values
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: standardize-geo-values
Source: https://github.com/TomGranot/hubspot-admin-skills/tree/main/skills/standardize-geo-values
Command: npx skills add https://github.com/TomGranot/hubspot-admin-skills --skill standardize-geo-values

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Converts inconsistent country and state/region values into a single, standardized set across HubSpot Contacts and Companies to improve geographic segmentation and reporting accuracy.

Core Features & Use Cases

  • Audit and identify non-standard geo values across Contacts and Companies.
  • Build and maintain a mapping table from variants to canonical values (e.g., "US"/"USA"/"U.S." -> "United States"; "NY" -> "New York").
  • Perform batch updates via HubSpot API or bulk UI workflows with safeguards and retry logic.
  • Enforce standardization going forward by validating form dropdowns and preventing free-text deviations.
  • Verify results with before/after checks and export audit trails for compliance and traceability.

Quick Start

Audit your HubSpot data for non-standard country and state values, run the Included Before/Execute/After workflow to apply the mappings, and verify that all records reflect standardized geographic values.

Frequently Asked Questions about standardize-geo-values

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

FAQPage Schema
How do I standardize country and state values in HubSpot CRM contacts and companies?▼

This skill standardizes inconsistent geographic data by mapping non-standard country and state variants like "USA" or "NY" to canonical full names across HubSpot contacts and companies through API-driven batch updates with before/after validation checks.

What is the best way to normalize free-text geography data in HubSpot for accurate reporting?▼

Normalizing free-text geography data involves building a mapping table to convert variants into a single standardized set, enforcing form dropdown validations to prevent deviations, and exporting audit trails for compliance and traceability.

Can I run a bulk data cleanup for non-standard geo values using the HubSpot API?▼

Yes, bulk data cleanup for non-standard geo values is possible using the HubSpot API by applying mapping tables to contacts and companies with built-in safeguards and retry logic for reliable batch updates.

How do I audit HubSpot contacts and companies for inconsistent country and region formats?▼

You audit HubSpot records for inconsistent country and region formats by scanning contacts and companies to identify non-standard geo values, then generating before and after checks to verify overall data hygiene compliance.

Does this data hygiene approach require Python and API credentials to update HubSpot records?▼

Yes, standardizing HubSpot records requires Python with the requests library and python-dotenv for environment management to authenticate and execute API-driven batch updates safely.

Related Skills

Explore More Data & Analytics Skills→
TomGranotTomGranot
58

backfill-geo-data

Enrich missing country, state, and city fields for HubSpot contacts and companies.

Community
Advanced
hheydaroffhheydaroff

geopolitical-analysis

Analyze country history, geography, economy, and alliances for geopolitical insights.

Community
Advanced
aura-farmingaura-farming
3

crm-hygiene

Validate HubSpot CRM data for required fields, duplicates, and activity logging.

Community
Advanced
guia-matthieuguia-matthieu
145

crm-hygiene

Audit CRM data for missing fields, inconsistent values, duplicates, and stale records.

Community
Intermediate