{"product_id":"enrich-domain-contacts-via-apify-in-n8n-google-sheets","title":"Enrich Domain Contacts via Apify in n8n + Google Sheets","description":"\u003ch3\u003eEnrich your domain contact list in n8n using Apify + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation reads domains from your Google Sheets, enriches them with the Apify \u003cstrong\u003econtact-details-scraper\u003c\/strong\u003e, and appends verified email\/phone contact data back into a target sheet—complete with run date and overall email\/phone hit-rate metrics.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes every \u003cstrong\u003eMonday at 08:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads domains from Google Sheets:\u003c\/strong\u003e pulls one domain (or URL) per row from a source sheet column named \u003ccode\u003edomain\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches in Apify batches:\u003c\/strong\u003e processes domains in \u003cstrong\u003e10-domain batches\u003c\/strong\u003e and sends each batch to the Apify actor \u003ccode\u003edami_studio~contact-details-scraper\u003c\/code\u003e to collect \u003cstrong\u003eemails, phone numbers, and LinkedIn links\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes results per domain:\u003c\/strong\u003e consolidates the Apify output so you get a \u003cstrong\u003esingle consolidated row per domain\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eControls pacing:\u003c\/strong\u003e pauses \u003cstrong\u003e30 seconds\u003c\/strong\u003e between batches to keep enrichment steady.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates hit-rate metrics:\u003c\/strong\u003e after all batches, aggregates results and computes overall \u003cstrong\u003eemail coverage\u003c\/strong\u003e and \u003cstrong\u003ephone coverage\u003c\/strong\u003e percentages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends enriched data back to Google Sheets:\u003c\/strong\u003e writes the enriched rows (plus \u003cstrong\u003erun date\u003c\/strong\u003e and hit-rate fields) into your destination sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUpdate weekly prospect lists for \u003cstrong\u003eSaaS sales outreach\u003c\/strong\u003e by enriching domain contacts automatically.\u003c\/li\u003e\n  \u003cli\u003eKeep a lead database current for \u003cstrong\u003eBDR\/AE teams\u003c\/strong\u003e using fresh email and phone hit-rate reporting.\u003c\/li\u003e\n  \u003cli\u003eAutomate enrichment for \u003cstrong\u003emarketing ops\u003c\/strong\u003e when domain sourcing comes from spreadsheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow:\u003c\/strong\u003e Scheduled trigger + Code\/aggregate logic to normalize and compute metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e credentials, read source domains, append to destination.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e uses actor \u003ccode\u003edami_studio~contact-details-scraper\u003c\/code\u003e (contact-details-scraper) with batching and max charge considerations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional notifications:\u003c\/strong\u003e Slack for alerts and\/or Gmail for email recipients.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used (as provided):\u003c\/strong\u003e code, wait, gmail, slack, aggregate, sticky note.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45945707364531,"sku":"N8N-19093","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/McxGznN8V0lMstrWHEoRb_itX4cQOu.png?v=1788426572","url":"https:\/\/buyflowscripts.com\/products\/enrich-domain-contacts-via-apify-in-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}