Enrich company websites from Google Sheets with emails and phones using Apify
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Apify (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Settings (Edit Fields (Set)): sets 2 fields: maxPagesPerWebsite, maxCostUsd
- Read websites (Google Sheets): read
- Collect unique websites (Code): runs custom JavaScript code
- Find contacts (Contact Details Scraper) (Apify): run actor and get dataset (actors)
- Flatten for spreadsheet (Code): runs custom JavaScript code
- Append contacts (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Find contacts (Contact Details Scraper)).
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Apify
@apify/n8n-nodes-apify.apify
From the author
Quick overview This workflow runs manually to read company websites from Google Sheets, sends the unique domains to Apify’s Contact Details Scraper to extract contact details and social profiles, and then writes the enriched results back to a Google Sheets…