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.

monday 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 monday.com. We have not run the import inside a monday.com account or spent Apify credits for this page; test with a few accounts first.

monday CRM account boards often have a website but a blank phone or email. This guide fills both in one batch with no data-provider subscription: export the board to Excel, enrich the websites, then import the result back into the same board with duplicate behavior Update, so existing items are changed instead of copied.

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 writes 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. Don't use this for spam.

The catch: what monday's import matches on

monday's help pages describe one way to change existing items from a file: Import items into the board, then in Set duplicate behavior choose Update and "select a column to determine what counts as a match." Two details from the same pages shape everything below:

So this guide matches on the Name (item) column, which is supported, and the script refuses any account whose name appears more than once in the export. If your board has another unique column of a supported type (for example a Text column holding your own account key), pass it with --match-col.

Step 1: export the board to Excel

Open the Accounts board (or whichever board holds your companies). Optionally filter it first; monday says the export "respects active filters and includes only the items that match the current filter." Then click the three-dot menu at the top right of the board → More actions → Export board to Excel → Export. Export just the table (no updates or subitems needed).

From monday's export page: up to 100,000 items per export; only table views export; the export format can't be customized; and on Enterprise plans an admin can stop non-admins from exporting. You can also export a single group (three-dot menu next to the group name → Export to Excel) or selected items via Batch Actions.

Step 2: build the Actor input (free script)

Download monday_enrich_prep.py. It uses only the Python standard library, reads the .xlsx directly (or the same sheet saved as .csv), and reads no token or login. It finds each header row whose first cell is Name (a board export can repeat it per group), and expects a website column called Website, Domain, Company domain or Link plus Phone and Email. Use --website-col, --phone-col or --email-col if your board names them differently. It skips accounts with no website, social or directory domains (facebook.com, yelp.com …), accounts that already have both a phone and an email, duplicate domains, and names that aren't unique:

python3 monday_enrich_prep.py prepare Accounts_export.xlsx

Real output on our made-up sample export (two groups, example names, .example domains):

9 items read, 3 websites -> websites.json
  skipped item 'Cedar Law Group': already has phone and email
  skipped item 'Dune Coffee': platform domain facebook.com
  skipped item 'Eastside Gym': no website
  skipped item 'Bright Dental (Riverton North)': duplicate brightdental.example
  skipped item 'Granite Roofing': Name appears 2x; Update would hit the wrong item
  skipped item 'Granite Roofing': Name appears 2x; Update would hit the wrong item

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

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

For the two "Granite Roofing" items, rename one on the board (for example add the city) and export again. 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 values go

The import's mapping screen lets you pick an existing board column for each file column, Create new column (it becomes a Text column), or Don't import column. Phone and Email are both supported column types, so map to your existing Phone and Email columns if the board has them. Email Deliverability, Contactability Score and Contact Source can go to new columns or be left out.

Step 4: find the contacts

Free option: open each account's website contact page by hand and copy the phone and general email into monday. 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 Store API record checked on 2026-11-18: $0.003 per unique website that returned at least one public email, phone number or social link (about $3 per 1,000). Unreachable, 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 monday import file

python3 monday_enrich_prep.py merge Accounts_export.xlsx 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 -> monday_import.csv (match column: Name; existing values kept: 1; ambiguous Name skipped: 0)
Name,Phone,Email,Email Deliverability,Contactability Score,Contact Source
Acme Plumbing,+14155550123,office@acmeplumbing.example,READY,82,https://acmeplumbing.example
Bright Dental,,,NO_MX,20,https://brightdental.example
Bright Dental (Riverton North),,,NO_MX,20,https://brightdental.example
Falcon Movers,(312) 555-0142,quotes@falconmovers.example,PARTIAL,64,https://falconmovers.example

What the merge does:

Step 6: import into the same board with "Update"

This follows monday's help pages Import files from Excel and Import from Excel to monday CRM:

  1. On the board, click the arrow next to the New item button (monday notes it may be renamed, for example New Contact, on customized boards) and choose Import items (or Import contacts). Drop in monday_import.csv.
  2. Map Name to the Name (item) column, Phone to Phone and Email to Email. For the other three columns pick a column, Create new column, or Don't import column. Set Unmapped columns to Don't import. The Add items to group only matters for rows that end up as new items.
  3. In Set duplicate behavior, choose Update (the default is Add as new items) and choose Name as the column that decides a match.
  4. If this is the Leads board and automations are on, monday says imported items' status changes to New Lead; turn the automation off for the import. Then click Import Now.
  5. When the green banner appears, download the CSV summary and check it. Start with a 10-row slice of the file and check those accounts before importing the rest.

Limits from the same pages: one file at a time per board, 100 uploads per account per hour, 10 MB per file, .xlsx, .xls or .csv. For row limits the two pages differ: the general article says up to 100 columns and 10,000 rows when importing to an existing board, the monday CRM article says fewer than 50 columns and 8,000 rows. Keep each file under 8,000 rows to be safe. We found no documented undo for an Update import, so keep the original export as your backup.

Then filter the board 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 made-up 2-group export (as .xlsx and .csv, same result) + hand-written EXAMPLE dataset (output pasted above), incl. duplicate-name check RAN, 2026-11-18
Export board to Excel path; 100,000-item limit; filters respected; table views only, format not customizable; Enterprise admin export permission; group and Batch Actions export READ, monday.com support Export from monday to Excel, 2026-11-18
Import items into an existing board; mapping options; supported column types; Set duplicate behavior (Add as new items / Skip / Update); unmatched rows added as new items; CSV summary; limits; .xlsx/.xls/.csv READ, monday.com support Import files from Excel, 2026-11-18
monday CRM Import contacts menu; same duplicate behavior; fewer than 50 columns and 8,000 rows; Leads board automations set New Lead READ, monday.com support Import from Excel to monday CRM, 2026-11-18
Item ID column exists; not in the import's supported-column list (so not used as match key here) READ, monday.com support The Item ID Column, 2026-11-18
Actor pricing ($0.003 per website with contacts + $0.00005 start) READ, public Apify Store API, 2026-11-18
Live Actor run or monday.com import for this page DID NOT RUN, $0 spent

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