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.

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.

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:

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:

Step 6: import as an update

Go to account menu → Tools and apps → Import data → Get started and upload pipedrive_import.csv. Map:

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.

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

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