Extract emails, phones & social links from websites with Apify and Google Sheets
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 9 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”.
- Set google sheet URL & original sheet name (Edit Fields (Set)): sets 2 fields: google_sheet_url, google_sheet_name
- Create new sheet for founded emails and phones (Google Sheets): create
- Get website URLs from first sheet (Google Sheets): uses Google Sheets
- wait for previous nodes to finish (Merge): merges the data from its input branches
- format data for Apify INPUT type (Code): runs custom JavaScript code
- Run Actor on Apify (Apify): uses Apify
- Get Results from Apify (Apify): work with datasets
- Add emails, phones, socials... into the new Sheet (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 Run Actor on Apify, Get Results from Apify).
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Apify
@apify/n8n-nodes-apify.apify - Google Sheets
n8n-nodes-base.googleSheets
From the author
Try It Out! This n8n template shows how to, based on a list of website, enrich a Google Spreadsheet with emails and phone numbers automatically using the Apify Email & Phone Extractor actor from Anchor. It will create a new sheet with the extracted contact…