Standardize Geo Values
Skill AktivConvert 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.
Funktionen
- 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
Anwendungsfälle
- 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
Nicht-Ziele
- 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
Praktiken
- Data Quality
- CRM Administration
- Automation
Voraussetzungen
- 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
Zuerst Marketplace hinzufügen
/plugin marketplace add TomGranot/hubspot-admin-skills/plugin install hubspot-admin-skills@hubspot-admin-skillsQualitätspunktzahl
Vertrauenssignale
Ähnliche Erweiterungen
Project Session Manager
100Worktree-first dev environment manager for issues, PRs, and features with optional tmux sessions
Public Google Drive
100Erstellen Sie öffentliche Google Docs- oder Google Sheet-Dateien, ohne OAuth zu benötigen. Verwenden Sie diese Fähigkeit, um Google Docs und Sheets zu erstellen und zu bearbeiten, keine Google-Anmeldung erforderlich. Dokumente sind unter teilbaren Links sichtbar. Die Registrierung erfolgt automatisch bei der ersten Verwendung.
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
100Verwenden Sie dies, wenn die Arbeit von den Live-Browsersitzungs- oder gerenderten Zustand des Benutzers abhängt und nicht von statischen Abrufen, insbesondere für Browser-Debugging-Kontexte oder von DevTools ausgewählte Elemente oder Anfragen, angemeldeten Dashboards oder CMS-Flows, localhost-Apps, Formularen, Uploads, Downloads, Medieninspektion, DOM- oder iframe-Inspektion, Shadow DOM oder Browserfehlern, die wie Soft-404s, Authentifizierungswände, Anti-Bot-Prüfungen oder Ratenbegrenzungen aussehen.
X Twitter Scraper
100Verwenden Sie dies, wenn der Benutzer X (Twitter)-Daten oder durch Bestätigung gesicherte X-Aktionen über Xquik benötigt: Tweet-Suche, Benutzer-Lookup, Follower-Extraktion, Mediendownload, Überwachung, Webhooks, MCP, SDKs, Posting, Likes, DMs und Profilaktualisierungen. Erfordert einen Xquik API-Schlüssel. Fordern Sie niemals X-Login-Materialien an.
Slack
100Use the Slack tool to react, pin/unpin, send, edit, delete messages, or fetch Slack member info.