The irritation
CRM users were repeatedly looking up city, state, county, country, and timezone data even though the ZIP or postal code already contained the clue they needed.
ProductReleasedActive product
ZipCode AutoFill
A HubSpot app that fills city, state, county, country, and timezone fields on contacts and companies from one ZIP or postal code.
- Current state
- Released — Active product
- Jack’s role
- Product design, Full-stack engineering, HubSpot integration, Operations
- Find it in the workshop
- Systems & Maps Lab · Address console
Built because…
The real build story.
What I built
I built a HubSpot app that watches contacts and companies for a new or changed ZIP, performs the lookup in a queued job, and writes the configured location properties. It also supports workflow-driven backfills and credit-based billing.
The hard part
Postal formats and third-party lookups are inconsistent. Jobs must retry safely, preserve leading zeroes, avoid duplicate credit use, and make failures understandable instead of silently writing partial data.
Under the casing
Proof, not decoration.
Build evidence03 items
- City, state/region, county, country, and timezone enrichment from ZIP data
- Contact and company automation plus workflow-driven backfills
- Queued jobs, safe retries, configurable mappings, credits, billing, and email
- React
- Node.js
- PostgreSQL
- Redis
- Bull
- Google APIs
- Stripe
- SendGrid
Scope of work
What I owned.
- Product design
- Full-stack engineering
- HubSpot integration
- Operations
No victory-lap math
Outcome and lesson.
Where it landed
ZipCode AutoFill is an active HubSpot product with configurable field mappings, automated record updates, backfills, billing, queues, storage, and transactional email.
What stayed
A small repeated lookup can support a real product when the automation is predictable, configurable, and honest about the records it could not enrich.
Field notes
This project has a physical address.
In the playable workshop, ZipCode AutoFill lives in the Systems & Maps Lab as a address console. You can inspect it without unlocking anything.