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.
Zoho CRM: 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 Zoho. We have not run the import inside a Zoho CRM org or spent Apify credits for this page; test with a few accounts first.
Zoho CRM Accounts often have a Website but a blank Phone or email. This guide fills both in one batch with no data-provider subscription: export the accounts with their Record Id, enrich the websites, then re-import with Update existing Accounts only, matched on Record Id, so no new account is created.
Before you start: legal basics
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. The Zoho import tool itself asks you to accept Zoho's anti-spam policy before you submit.
Step 1: export the accounts with the Record Id
Go to Setup → Data Administration → Export → Start an Export (or, in the Accounts module, click the ⋯ button next to Create and choose Export). Pick the Accounts module, filter by a custom view or criteria (for example Phone is empty), and choose CSV.
Keep the Record Id column. Zoho's export page notes you can exclude Record ID under Exclude Fields; don't, because the update in step 6 matches on it. Limits from the same page: up to 200,000 records per CSV export (50,000 for XLSX), up to 200 chosen fields, a daily export count that depends on your edition (Free 10, Standard 100, Professional 250, Enterprise 500, Ultimate 1,000), and the download link (a zip) lasts seven days. You need the Export permission for the module.
Zoho's partner-support article on lookup migration says the system-generated Record Id format starts with zcrm_. Leave that prefix in place. If you open the CSV in a spreadsheet and save it again, a long all-digit ID can turn into something like 5.55E+18, which has lost digits. The script refuses those rows so you re-export instead of updating the wrong record.
Step 2: build the Actor input (free script)
Download zoho_enrich_prep.py. It uses only the Python standard library and reads no token or login. It expects the headers Record Id, Account Name, Website, Phone and Email (Record ID, Id and Account Id also work). If your email field has another label, use --email-col "Company Email". It skips rows with no usable Record 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 zoho_enrich_prep.py prepare Accounts_export.csv
Real output on our made-up 8-row sample export (example names and IDs, .example domains):
3 websites -> websites.json
skipped account zcrm_5550000000000000103: already has phone and email
skipped account zcrm_5550000000000000104: platform domain facebook.com
skipped account zcrm_5550000000000000105: no website
skipped account zcrm_5550000000000000106: duplicate brightdental.example
skipped account 5.55E+18: Record Id 5.55E+18 was turned into scientific notation; re-export
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 3: decide where the email goes
If your Accounts layout has no email field, you don't have to create one up front: the Zoho import tool has a Create New Fields button on the mapping screen that turns an unmapped column into a new field. The same works for Email Deliverability and Contactability Score if you want to keep them. Use the standard Phone field for the phone number.
Step 4: find the contacts
Free option: open each account's website contact page by hand and copy the phone and general email into Zoho. 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 checked 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). Websites with no result 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 Zoho update file
python3 zoho_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 -> zoho_import.csv (existing values kept: 1, zcrm_ prefix added: 1)
Record Id,Account Name,Website,Phone,Email,Email Deliverability,Contactability Score
zcrm_5550000000000000101,Acme Plumbing,https://www.acmeplumbing.example/,+14155550123,office@acmeplumbing.example,READY,82
zcrm_5550000000000000102,Bright Dental,brightdental.example,,,NO_MX,20
zcrm_5550000000000000106,Bright Dental (Riverton North),https://brightdental.example/locations,,,NO_MX,20
zcrm_5550000000000000107,Falcon Movers,falconmovers.example,(312) 555-0142,quotes@falconmovers.example,PARTIAL,64
What the merge does:
- Never overwrites an existing Phone or Email. Falcon Movers keeps its (312) 555-0142, and the found +13125550199 is ignored. Only blank fields get filled. (To also normalize existing numbers to E.164, see the CRM phone cleanup guide.)
- Writes every Record Id in the
zcrm_form. Bright Dental's bare5550000000000000102becamezcrm_5550000000000000102. Use--no-prefixto keep IDs exactly as exported. - Drops no-reply addresses: Acme's
noreply@was skipped in favor ofoffice@. - Leaves the email blank when the domain is
NO_MX, because mail to it would bounce. - Writes one row per account, so two accounts on the same website both get the result.
- Copies Account Name and Website through unchanged, so the import doesn't rename anything.
Step 6: import as "Update existing Accounts only"
This follows Zoho's help page for the current import tool:
- In Accounts, click the down arrow next to Create Account and choose Import Accounts. Drop in
zoho_import.csv(CSV, XLS, XLSX; 25 MB max per file). Leave Charset on Auto-Detect. Click Next. - Choose Update existing Accounts only. Zoho says this changes existing records and creates no new ones. To find existing records you pick a unique CRM field; choose the Record Id. Zoho's help page for the classic import tool says to pick the module's ID field in Find existing using exactly in this case: re-importing records that were exported from Zoho CRM and changed in a spreadsheet.
- Tick skip updating empty values. Per Zoho, without it a blank cell in the file overwrites the CRM value with an empty one. The script already writes existing values back, so this is a second safety net (for example for Bright Dental's empty Email).
- Map Record Id to the Record Id field, Phone to Phone, and Email, Email Deliverability and Contactability Score to your fields (or use Create New Fields). Leave unwanted columns unmapped.
- Decide whether to tick Trigger automation and process management for imported records, accept the anti-spam policy, and click Submit. Import a 10-row slice first, then check those accounts.
Read this before submitting: Zoho says updates to existing records cannot be reverted. Undo only removes records an import added. Keep your original export as the backup. Other limits on the same page: rows per file depend on edition (Free 1,000; Standard 20,000; Professional 50,000; Enterprise 100,000; Ultimate/CRM Plus 200,000), at most 500 columns, and you need the Import Records permission. Afterwards, Setup → Data Administration → Import → Import History shows rows added, updated and skipped, and lets you download skipped rows with their errors (for imports in the last seven days).
Then build a custom view on Contactability Score ≥ 50 and Email Deliverability = READY or PARTIAL. That's your call and email list, sorted by how reachable each account is.
Related guides
- Salesforce version: Data Import Wizard update by Salesforce.com ID · HubSpot version: re-import companies by Record ID · Pipedrive version: update organizations by System ID
- monday CRM version: Import items with duplicate behavior Update, matched on Name
- Attio version: re-import Companies matched on Record ID
- Clean and format phone numbers before a CRM import
- Find emails from a list of websites · Enrich a CSV of websites (Console + API)
- Google Sheets Apps Script version · Airtable script · Zapier
Sources and what we actually ran
| Claim | Status |
|---|---|
prepare and merge on the 8-row made-up export + hand-written EXAMPLE dataset (output pasted above), incl. zcrm_ prefix and scientific-notation check |
RAN, 2026-11-17 |
| Export paths, Record ID can be excluded, CSV/XLSX limits, daily export limits per edition, 7-day download link | READ, Zoho CRM help Export CRM Data, 2026-11-17 |
| Import Accounts path; Update existing only (no new records); unique field to find existing records; skip updating empty values; Create New Fields; anti-spam checkbox; updates cannot be reverted; file/row/column limits; Import History | READ, Zoho CRM help Import data into a CRM module (new import tool), 2026-11-17 |
| Choose the [Module ID] in Find existing using when re-importing records exported from Zoho CRM; Update existing only can skip updating empty values | READ, Zoho CRM help Importing Data to Zoho CRM (classic import tool), 2026-11-17 |
Record Id format starts with zcrm_ |
READ, Zoho Partner Support Data Migration - Lookup Migration, 2026-11-17 |
| Actor pricing and inputs | READ, public Apify pricing, 2026-11-16 |
| Live Actor run or Zoho CRM import for this page | DID NOT RUN, $0 spent |