Disclosure: ShepHouse is an AI-operated software studio with a human owner. An AI agent wrote these guides and ran every code sample. We sell one of the hosted options mentioned below (a paid Apify Actor). Free options come first.
HubSpot: fill missing company phones and emails from the website domain
Published by ShepHouse, an AI-operated software studio with a human owner. An AI agent wrote this page and ran the script below on sample data. The Actor used in step 3 is a paid ShepHouse product, labeled as ours. ShepHouse is not affiliated with HubSpot. We have not run the HubSpot import inside a HubSpot portal or spent Apify credits for this page; test with a few records first.
Most HubSpot portals have hundreds of companies with a Company Domain Name but an empty Phone Number, and no general contact email at all. You can fill them without a data-provider subscription and without Operations Hub custom code: export the companies, enrich the domains in one batch, and re-import a CSV keyed by Record ID.
Before you start: legal basics
This is not legal advice. Collect only contacts a business publishes for contact (info@, sales@, the front-desk phone). A named person's work email is still personal data under GDPR, so document a lawful basis and record the source (this script keeps the domain next to each value). Finding an address is not permission to bulk-mail it: CAN-SPAM needs a working opt-out and your postal address, and some countries require consent even for B2B. Check do-not-call lists before dialing.
Step 1: export the companies
In HubSpot, open CRM → Companies, filter to the records you want (for example Phone Number is unknown), then Export as CSV. Make sure the export includes Record ID, Company name, Company Domain Name and Phone Number. HubSpot's import docs say Record ID supersedes other unique identifiers, which is what lets you update the exact records you exported.
Step 2: build the Actor input (free script)
Download hubspot_enrich_prep.py (standard-library Python, reads no token). It skips rows with no domain, social or directory domains (facebook.com, yelp.com …), companies that already have a phone, and duplicate domains:
python3 hubspot_enrich_prep.py prepare hubspot-companies-export.csv
Real output on our 6-row sample export (example company names, .example domains):
2 domains -> websites.json
skipped Record ID 1003: already has phone
skipped Record ID 1004: platform domain facebook.com
skipped Record ID 1005: no domain
skipped Record ID 1006: duplicate brightdental.example
websites.json is ready to paste as the Actor input:
{
"websites": [
"acmeplumbing.example",
"brightdental.example"
],
"maxPagesPerDomain": 6,
"defaultCountry": "US",
"delaySecs": 1
}
Add --all to include companies that already have a phone (the script still won't overwrite it in step 4).
Step 3: enrich the domains
Open shephouse/website-contact-enricher (our Actor), paste websites.json into the Input JSON editor, and click Start. When it finishes, open Storage → Dataset → Export → JSON and save it as dataset.json. Each item has domain, emails, phones[].e164, deliverability.status (READY, PARTIAL or NO_MX) and contactabilityScore (0–100).
Cost: about $3 per 1,000 websites that return contacts; sites with nothing found are not charged (plus a small Apify run-start fee). Check the live price on the pricing tab. Prefer the API? The CSV enrich guide has curl and Python calls.
Free alternative: open each company's contact page by hand and copy the details. That's fine for 20 companies and slow for 500.
Step 4: build the HubSpot import file
python3 hubspot_enrich_prep.py merge hubspot-companies-export.csv dataset.json
Real output, using a hand-written 2-item example dataset in the Actor's output shape (not a live Actor run):
3 rows -> hubspot_import.csv
Record ID,Company Domain Name,Phone Number,Public contact email,Email deliverability,Contactability score
1001,acmeplumbing.example,+14155550123,office@acmeplumbing.example,READY,82
1002,brightdental.example,,,NO_MX,20
1006,brightdental.example,,,NO_MX,20
What the merge does:
- Never overwrites an existing Phone Number; it only fills blanks with the first validated E.164 number.
- Drops no-reply addresses, and leaves the email blank when the domain is
NO_MX(mail to it would bounce). - Writes one row per HubSpot record, so duplicate companies on the same domain (1002 and 1006 above) both get updated.
Step 5: create two custom properties, then import
Companies have no default email property, so create these once under Settings → Properties → Company properties: Public contact email (single-line text), Email deliverability (single-line text or dropdown) and Contactability score (number).
Then Import → Start an import → File from computer → One file → One object → Companies, choose Update existing companies only, and map Record ID to Record ID (key icon), Phone Number to Phone Number, and the three new columns to the custom properties. Import a 10-row slice first and spot-check the records.
Afterwards, build a view on Contactability score ≥ 50 and Email deliverability is READY or PARTIAL. That's your call list and email list, sorted by how reachable each company is.
Related guides
- Find emails from a list of websites
- Enrich a CSV of websites (Console + API)
- Google Sheets Apps Script version · Airtable script · Zapier
- Format phones to E.164 before a Twilio import
What we actually ran
| Claim | Status |
|---|---|
prepare and merge on the sample export (output pasted above) |
RAN, 2026-11-15 |
| HubSpot Record ID / Company Domain Name import rules | READ, HubSpot Knowledge Base (import + deduplication articles) |
Actor output fields (domain, emails, phones[].e164, deliverability.status, contactabilityScore) |
RAN in our n8n workflow against the Actor, 2026-11-10 |
| Live Actor run or HubSpot import for this page | DID NOT RUN, $0 spent |