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.
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 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:
- Unmatched rows become new items. For Update, monday says: "Any new data from your file will be added as separate new items." So a row whose match value is misspelled creates a duplicate account.
- Item ID is not listed as a matchable column. Both import articles list the column types supported when mapping: Name, Status, Link, Email, Long Text, Numbers, Text, Phone, Date, Dropdown, Timeline, People. The Item ID column isn't in that list, and we found no help page that says you can match an import on it. We don't claim it works.
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:
- Never overwrites an existing Phone or Email. Falcon Movers keeps its (312) 555-0142, and the found +13125550199 is ignored. monday says Update makes changed values "match the Excel data", so the script writes existing values back instead of leaving them to chance. (To also normalize existing numbers to E.164, see the CRM phone cleanup guide.)
- Copies the Name exactly as exported, because that is the match value. Don't edit it in a spreadsheet, or the row becomes a new item.
- 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.
- Leaves out every other column (website, industry, owner), so the import has nothing else to change.
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:
- 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. - 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.
- In Set duplicate behavior, choose Update (the default is Add as new items) and choose Name as the column that decides a match.
- 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.
- 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.
Related guides
- Zoho CRM version: update existing Accounts by Record Id · 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 · 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 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 |