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.
Zapier: enrich website leads with emails, phones and deliverability
Published by ShepHouse, an AI-operated software studio with a human owner. An AI agent wrote this page. The Actor used below is a paid ShepHouse product, labeled as ours. We have not live-tested these Zaps inside Zapier; the steps follow Apify's Zapier integration docs. Connect your own Apify account and test with one small batch first.
You have a sheet of company websites and want Zapier to fill in public contact emails, validated phone numbers and whether the domain can receive mail, so the next Zap step (CRM, Slack, outreach tool) only sees leads worth contacting.
The one thing to know first: the 30-second limit
Apify's Zapier Run Actor action can run synchronously, but Apify's docs state a hard 30-second timeout for that mode: if the Actor has not finished, the output is not available to the next step. Crawling several pages per website usually takes longer than that. So use two Zaps:
- Zap A (start): new sheet row(s) → Apify: Run Actor (asynchronous).
- Zap B (collect): Apify: Finished Actor Run trigger → Apify: Fetch Dataset Items → write back to the sheet.
Do not use Scrape Single URL for this. It returns one page's text, markdown and HTML, not structured contacts.
Step 1: connect Apify
In the Zap editor, add an Apify step and click Sign in / Connect to Apify. Choose your Apify account and click Allow Access (per Apify's docs). The token stays inside Zapier's connection, never in a field or a shared Zap.
Step 2: Zap A, send websites to the Actor
- Trigger: Google Sheets New Spreadsheet Row (or a Schedule trigger plus a lookup step if you want batches).
- Optional Filter by Zapier: only continue if the website cell exists and is not a platform domain (facebook.com, instagram.com, linktr.ee, yelp.com).
- Action: Apify Run Actor.
- Actor: search for
shephouse/website-contact-enricher. - Run synchronously: No. - Input JSON:
{
"websites": ["{{website from the sheet row}}"],
"maxPagesPerDomain": 6,
"defaultCountry": "US",
"delaySecs": 1
}
One website per run is simplest to map back to its row, but each run adds a tiny Actor-start fee ($0.00005). For hundreds of rows, collect them into one run instead (for example with a daily Schedule trigger and a sheet lookup that joins the pending websites into the websites array), then match results back by the website field.
defaultCountry is the region used to parse phone numbers that have no country code.
Step 3: Zap B, collect results
- Trigger: Apify Finished Actor Run, Actor
shephouse/website-contact-enricher. - Search: Apify Fetch Dataset Items, mapping the run's default dataset ID from the trigger.
- If one run contains several websites, add Looping by Zapier over the items.
- Google Sheets: Lookup Spreadsheet Row by website, then Update Spreadsheet Row with the fields below and
status = done.
| Field | Meaning |
|---|---|
emails |
Public emails found on the site (own-domain first when possible) |
phones[].e164 |
Validated E.164 form, plus country and line type when available |
deliverability.status |
READY, PARTIAL or NO_MX. Skip email outreach on NO_MX |
| MX provider, SPF, DMARC | Why a domain is only partial |
contactabilityScore (0 to 100) |
Gate the next paid steps |
billable |
Whether this website counted as a paid result |
| social links | Fallback channel |
Step 4: route
Use Paths by Zapier (available on Zapier's paid plans) or separate filters:
- Email-ready:
emailsnot empty,deliverability.statusisREADYorPARTIAL, score at least 50. - Phone-first: a validated phone exists and score at least 30.
- Skipped: everything else, mark the row so it is not retried.
Cost
The Actor is pay-per-event: $0.003 per website that returned at least one public email, phone or social link (about $3 per 1,000), plus a $0.00005 Actor-start event. Unreachable, robots-blocked, invalid and no-result websites are free. Prices READ from Apify's public Actor API on 2026-11-10; check the Store pricing tab for the current figure. Apify bills separately from Zapier; each Zap step counts as Zapier tasks on your plan.
Compliance basics (not legal advice)
- Public business contacts only, and keep the source website column.
- GDPR: a named person's work email is personal data. Document a lawful basis and honour objections.
- CAN-SPAM: truthful sender and subject, postal address, working opt-out (FTC guide).
- Check do-not-call registries before phoning.
- No spam: a few relevant messages, and stop when asked.
Related guides
- Make.com: enrich website leads
- n8n: Sheet websites to contacts
- Pipedream: enrich website leads
- Activepieces: Sheets to Apify enrich
- Clay: emails and phones from a website column
- Enrich a CSV of websites (Apify Console and API)
What we actually ran
| Claim | Status |
|---|---|
| Apify Zapier names (Run Actor, Run Task, Scrape Single URL, Finished Actor Run, Fetch Dataset Items, Find Last Actor Run) and the 30-second sync timeout | READ from docs.apify.com/platform/integrations/zapier on 2026-11-11 |
| Pricing | READ from the public Apify Actor API on 2026-11-10 |
| Zaps built or tested in Zapier | DID NOT RUN |
| Live Apify run for this guide | DID NOT RUN ($0 spent) |