Enrich Websites with Emails & Phones in n8n (Google Sheets + Apify)

Enrich company websites with emails, phones, and social links—automatically in n8n (Google Sheets + Apify)

This n8n workflow reads company websites from your Google Sheets, sends the unique domains to Apify’s Contact Details Scraper, then appends enriched results (emails, phone numbers, socials, and contact links) back into a Google Sheets results sheet.

What this workflow does

• Runs manually when you click Test workflow (Manual Trigger).
• Reads websites from Google Sheets by pulling values from common columns (website/url/domain) in your input worksheet.
• Normalizes and deduplicates the values into a single list of unique domains.
• Calls Apify’s Contact Details Scraper (actor: jipdiW9Rwbp1Lruzx) using a configurable page limit and spend cap.
• Flattens the scraper output into one spreadsheet-friendly row per website, including fields like email, phones, socials, contact links, provider, and status.
• Appends enriched rows to your Google Sheets destination worksheet.

Use cases

• Lead enrichment: turn a list of company domains into a contact dataset with emails and phone numbers for outreach.
• Sales/BD ops: continuously build a richer spreadsheet of prospects from a maintained website list.
• Startup/SaaS research: quickly gather public contact details and social profiles for target companies.

Technical details

• n8n nodes / components: Manual Trigger, Google Sheets, Set, Code, Sticky Note, and Apify (apify/nodes-apify).
• Apify integration: uses your Apify API token credential for the Apify community node and the Contact Details Scraper actor (jipdiW9Rwbp1Lruzx).
• Controls: optionally adjust maxPagesPerWebsite and maxCostUsd in the Settings step.
• Output: appends one enriched row per domain into a results Google Sheet.

Perfect for n8n automation engineers and SaaS operators who need reliable website-to-contact enrichment in a Google Sheets workflow.