Enrich Domain Contacts via Apify in n8n + Google Sheets

Enrich your domain contact list in n8n using Apify + Google Sheets

This n8n automation reads domains from your Google Sheets, enriches them with the Apify contact-details-scraper, and appends verified email/phone contact data back into a target sheet—complete with run date and overall email/phone hit-rate metrics.

What this workflow does

• Runs on a schedule: executes every Monday at 08:00.
• Reads domains from Google Sheets: pulls one domain (or URL) per row from a source sheet column named domain.
• Enriches in Apify batches: processes domains in 10-domain batches and sends each batch to the Apify actor dami_studio~contact-details-scraper to collect emails, phone numbers, and LinkedIn links.
• Normalizes results per domain: consolidates the Apify output so you get a single consolidated row per domain.
• Controls pacing: pauses 30 seconds between batches to keep enrichment steady.
• Calculates hit-rate metrics: after all batches, aggregates results and computes overall email coverage and phone coverage percentages.
• Appends enriched data back to Google Sheets: writes the enriched rows (plus run date and hit-rate fields) into your destination sheet.

Use cases

• Update weekly prospect lists for SaaS sales outreach by enriching domain contacts automatically.
• Keep a lead database current for BDR/AE teams using fresh email and phone hit-rate reporting.
• Automate enrichment for marketing ops when domain sourcing comes from spreadsheets.

Technical details

• n8n workflow: Scheduled trigger + Code/aggregate logic to normalize and compute metrics.
• Google Sheets integration: credentials, read source domains, append to destination.
• Apify integration: uses actor dami_studio~contact-details-scraper (contact-details-scraper) with batching and max charge considerations.
• Optional notifications: Slack for alerts and/or Gmail for email recipients.
• Nodes used (as provided): code, wait, gmail, slack, aggregate, sticky note.