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.
Pipedrive: fill missing organization 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 Pipedrive. We have not run the import inside a Pipedrive account or spent Apify credits for this page; test with a few organizations first.
Pipedrive organizations usually have a Website but no phone number or general email. Pipedrive's own docs say people have a default phone field, while organizations get a phone only if you add a phone-type custom field. So the gap is common. This guide fills it in one batch with no data-provider subscription: export, enrich the websites, then re-import the file as an update matched by the Pipedrive System ID.
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: write down 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)
Go to account menu → Personal preferences → Data fields → Organization and add:
- Phone (field type Phone), unless you already have one
- Email (field type Text)
- Email deliverability (Text or Single option) and Contactability score (Numerical), both optional
You can also create a missing field from the import mapping screen. Pipedrive's import docs say you can do this "without restarting the import".
Step 2: export the organizations with the ID column
Open Contacts → Organizations in list view. Use the gear icon to add the ID column, plus Name, Website, Address and your Phone/Email custom fields. Filter to the organizations you want (for example Phone is empty), then export to CSV.
The ID is what keeps this an update and not a new set of organizations. Pipedrive's article on updating data with a spreadsheet says the System ID "will automatically update your database with your new information". It also warns that changes you make in other exported columns, such as the name, are overwritten into Pipedrive on import. The script copies those columns through unchanged.
Step 3: build the Actor input (free script)
Download pipedrive_enrich_prep.py. It uses only the Python standard library and reads no token. It accepts export headers with or without the Organization - prefix (Organization - ID or ID, and so on). If your custom fields have other names, use --phone-col / --email-col. It skips organizations with no website, social or directory domains (facebook.com, yelp.com …), organizations that already have both a phone and an email, and duplicate domains:
python3 pipedrive_enrich_prep.py prepare organizations-export.csv
Real output on our made-up 7-row sample export (example names, .example domains):
3 websites -> websites.json
skipped org 203: already has phone and email
skipped org 204: platform domain facebook.com
skipped org 205: no website
skipped org 206: 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 organizations that already have both values. The script still won't overwrite them in step 5.
Step 4: find the contacts
Free option: open each organization's website contact page by hand and copy the phone and general email into Pipedrive. That works for 20 organizations. 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. If you'd rather use the API, the CSV enrich guide has curl and Python calls.
Step 5: build the Pipedrive update file
python3 pipedrive_enrich_prep.py merge organizations-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 -> pipedrive_import.csv (existing values kept: 1)
ID,Name,Website,Phone,Email,Email deliverability,Contactability score
201,Acme Plumbing,https://www.acmeplumbing.example/,+14155550123,office@acmeplumbing.example,READY,82
202,Bright Dental,brightdental.example,,,NO_MX,20
206,Bright Dental (Riverton North),https://brightdental.example/locations,,,NO_MX,20
207,Falcon Movers,falconmovers.example,+13125550142,quotes@falconmovers.example,PARTIAL,64
What the merge does:
- Never overwrites an existing Phone or Email. Falcon Movers (207) keeps its +13125550142, and the found +13125550199 is ignored. Only blank fields get filled.
- 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 Pipedrive organization, so two organizations on the same website (202 and 206) both get the result.
- Copies Name and Website through unchanged, so the import doesn't change them.
Step 6: import as an update
Go to account menu → Tools and apps → Import data → Get started and upload pipedrive_import.csv. Map:
- ID → Organization – Pipedrive System ID (this is what makes it an update)
- Name → Organization – Name. Name is the only mandatory field for organizations.
- Phone, Email, Email deliverability, Contactability score → your custom fields from step 1
Import a 10-row slice first and check a few organizations. Pipedrive's limit is 50 MB and 50,000 rows per file.
What happens without the ID column
If you import by name only, Pipedrive's duplicate rules apply. For organizations, it recognizes the name and then checks Address: when the address matches an existing organization, it merges them and adds the new information. If the address is blank or different, you can end up with a second organization of the same name. You can also choose to skip merging during import, which deliberately creates separate records. Keep the ID column and you avoid all of this. If you already have duplicates, admins (or users with that permission) can clean them up under Tools and apps → Merge Duplicates. Merges can't be undone, so check before you merge.
Afterwards, filter Organizations on Contactability score ≥ 50 and Email deliverability is READY or PARTIAL. That's your call list and email list, sorted by how reachable each organization is.
Related guides
- HubSpot version: fill company phones and emails, re-import by 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 7-row made-up export + hand-written EXAMPLE dataset (output pasted above) |
RAN, 2026-11-16 |
| Update by Pipedrive System ID; other exported columns overwritten on import; 50 MB / 50,000 rows | READ, Pipedrive KB Updating Pipedrive data with a spreadsheet |
| Organization duplicates = name + address; option to skip merging | READ, Pipedrive KB How to avoid duplicates during an import? |
| Organization name is the only mandatory import field | READ, Pipedrive KB Importing: mandatory fields |
| Import path, default organization fields (name, address, website …), custom fields from the mapping screen | READ, Pipedrive KB Import fields |
| People have a default phone field; phone-type custom fields can be added to organizations | READ, Pipedrive KB What types of custom fields are there? |
| Merge Duplicates is admin/permission-only and can't be undone | READ, Pipedrive KB Merge duplicates |
| Actor pricing and inputs | READ, public Apify API (no token), 2026-11-16 |
| Live Actor run or Pipedrive import for this page | DID NOT RUN, $0 spent |