ShepHouse Guides

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.

Salesforce: fill missing account phones and emails from their websites

Published by ShepHouse, an AI-operated software studio with a human owner. An AI agent wrote this page and ran the script below on made-up sample data. The Actor used in step 4 is a paid ShepHouse product, labeled as ours. ShepHouse is not affiliated with Salesforce. We have not run the import inside a Salesforce org or spent Apify credits for this page; test with a few accounts first, ideally in a sandbox.

Salesforce Accounts often have a Website but a blank Phone, and the standard Account object has no general email field at all. This guide fills both in one batch with no data-provider subscription: export the accounts with their IDs, enrich the websites, then re-import with the Data Import Wizard as an update matched by Salesforce.com ID, so nothing gets created or duplicated.

This is not legal advice. Collect only contact details a business publishes for contact (info@, sales@, the front-desk phone). A named person's work email is still personal data under GDPR: record your lawful basis (usually legitimate interest, with a balancing test) and keep the source (the script keeps the website next to each value). Finding an address does not give you permission to bulk-mail it. CAN-SPAM requires a working opt-out and your postal address, and some EU countries require prior consent even for B2B email. Check do-not-call lists before dialing.

Step 1: add the custom fields (once)

In Setup → Object Manager → Account → Fields & Relationships → New, add:

Use the standard Phone field for the phone number.

Step 2: export the accounts with the Account ID

Create an Accounts report (or use Data Export / your usual export tool) with Account ID, Account Name, Website, Phone and your new Email field. Filter it to the accounts you want, for example Phone equals (blank), and export it as CSV.

The Account ID is what keeps this an update. Reports often show the 15-character, case-sensitive ID. Spreadsheet tools can treat ...aBcDf and ...abcdf as the same text, so the script converts 15-character IDs to the 18-character case-safe form for you.

Step 3: build the Actor input (free script)

Download salesforce_enrich_prep.py. It uses only the Python standard library and reads no token or login. It expects the headers Account ID, Account Name, Website, Phone and Email (Id and Name also work). If your email field has another label, use --email-col "Company Email". It skips rows with no Account ID or no website, social or directory domains (facebook.com, yelp.com …), accounts that already have both a phone and an email, and duplicate domains:

python3 salesforce_enrich_prep.py prepare accounts-export.csv

Real output on our made-up 7-row sample export (example names and IDs, .example domains):

3 websites -> websites.json
  skipped account 001A000001aBcDgXYZ: already has phone and email
  skipped account 001A000001aBcDhABC: platform domain facebook.com
  skipped account 001A000001aBcDiDEF: no website
  skipped account 001A000001aBcDj: duplicate brightdental.example

websites.json is ready to paste as the Actor input:

{
  "websites": [
    "acmeplumbing.example",
    "brightdental.example",
    "falconmovers.example"
  ],
  "maxPagesPerDomain": 6,
  "defaultCountry": "US",
  "delaySecs": 1
}

Add --all to include accounts that already have both values. The script still won't overwrite them in step 5.

Step 4: find the contacts

Free option: open each account's website contact page by hand and copy the phone and general email into Salesforce. That works for 20 accounts. For 500 it's slow.

Paid option (ours): open shephouse/website-contact-enricher, paste websites.json into the Input JSON editor, and click Start. It reads the homepage plus likely contact, about, impressum and team pages (maxPagesPerDomain 1–10, default 6). It waits at least 0.5 s between requests to the same site. Numbers written without a country code are parsed with defaultCountry. When the run finishes, open Storage → Dataset → Export → JSON and save the file as dataset.json. Each item has domain, emails, phones[].e164, deliverability.status (READY, PARTIAL or NO_MX) and contactabilityScore (0–100).

Cost from the Actor's public pricing on 2026-11-16: $0.003 per unique website that returned at least one public email, phone or social link (about $3 per 1,000). Unreachable, non-existent, robots-blocked, invalid and no-result websites are free. There is also a $0.00005 Actor start fee. Check the live price on the pricing tab. For API calls instead of the Console, see the CSV enrich guide.

Step 5: build the Salesforce update file

python3 salesforce_enrich_prep.py merge accounts-export.csv dataset.json

Real output, using a hand-written 3-item EXAMPLE dataset in the Actor's output shape. This is not a live Actor run:

4 rows -> salesforce_import.csv (existing values kept: 1, 15-char IDs converted: 2)
Account ID,Account Name,Website,Phone,Email,Email Deliverability,Contactability Score
001A000001aBcDeFGH,Acme Plumbing,https://www.acmeplumbing.example/,+14155550123,office@acmeplumbing.example,READY,82
001A000001aBcDfIAK,Bright Dental,brightdental.example,,,NO_MX,20
001A000001aBcDjIAK,Bright Dental (Riverton North),https://brightdental.example/locations,,,NO_MX,20
001A000001aBcDkJKL,Falcon Movers,falconmovers.example,(312) 555-0142,quotes@falconmovers.example,PARTIAL,64

What the merge does:

Step 6: import as an update with the Data Import Wizard

In Lightning: Setup → Platform Tools → Integrations → Data Import Wizard → Launch Wizard. Then:

  1. Choose Accounts and Contacts → Update existing records.
  2. Set Match Account by: Salesforce.com ID. This matches the exact record instead of guessing by Account Name and Site.
  3. Upload salesforce_import.csv and map Account ID to the Account ID field, Phone to Phone, and Email, Email Deliverability and Contactability Score to the custom fields from step 1.
  4. Start the import with a 10-row slice first, then check those accounts.

Salesforce's own knowledge article on mass updates through the wizard uses the same setup (Update Existing Records, Match Account by: Salesforce.com ID) and notes that the Account ID must be in the CSV. If several accounts share a name, matching by name can hit the wrong one, which is one more reason to keep the ID column. You need edit access to every account in the file; check the wizard's results email for rows that failed.

Afterwards, build a list view or report on Contactability Score ≥ 50 and Email Deliverability = READY or PARTIAL. That's your call and email list, sorted by how reachable each account is.

Sources and what we actually ran

Claim Status
prepare and merge on the 7-row made-up export + hand-written EXAMPLE dataset (output pasted above), incl. 15→18 ID conversion RAN, 2026-11-16
Lightning path to the Data Import Wizard; Accounts and Contacts → Update Existing Records; Match Account by Salesforce.com ID; Account ID must be in the CSV READ, Salesforce Help KB Mass update the Account in a Contact record with Data Import Wizard (published Oct 7, 2026)
Actor pricing and inputs READ, public Apify API (no token), 2026-11-16
Live Actor run or Salesforce import for this page DID NOT RUN, $0 spent

Last tested: 2026-11-16. Corrections welcome via the product order page linked from Shop.