Website Contact Data Enrichment using Apify and Google Sheets - n8n Workflow

Sales Teams and Business Development Representatives needing to surface contacts for target accounts quickly.
Growth Marketers focused on cleaning, enriching, and validating prospect lists at scale.
Recruiters who need to efficiently find direct contact details on company career or profile pages.
Researchers and Data Analysts mapping industries or organizations with verified contact data.

• Users looking for high-performance web scraping and data processing solutions within an n8n workflow.

This expert n8n workflow solves the tedious problem of manual lead and contact data gathering. Sales professionals, recruiters, and marketers often require up-to-date contact information (emails, phone numbers, social media profiles) from a large list of target company websites. Trying to do this manually is slow and error-prone. This specific n8n workflow automates the entire process. It utilizes the power of the Apify Email & Phone Extractor actor to systematically crawl the provided websites and retrieve critical contact data.

The best part is that this n8n template manages the entire input and output process seamlessly through Google Sheets, providing a clean, organized, and scalable data enrichment solution. By using this robust n8n node structure, businesses can ensure their outreach lists are constantly refreshed with verified contact information without manual intervention.

This efficient n8n workflow runs through several key stages, starting with data ingestion and ending with structured data output:

1. Start and Configuration: The process begins using the manual n8n trigger, 'When clicking ‘Execute workflow’.' The subsequent 'Set' n8n node defines essential parameters: the target Google Sheet URL and the name of the input sheet containing the website domains (e.g., websites).


2. Sheet Preparation and Data Ingestion: Two parallel Google Sheets n8n node actions occur. 'Get website URLs from first sheet' reads the input list of URLs. Simultaneously, 'Create new sheet for founded emails and phones' creates a brand new, timestamped output sheet ready to receive the enriched data.


3. Synchronization: A Merge n8n node ('wait for previous nodes to finish') ensures that both the input data retrieval and the new output sheet creation steps are successfully completed before proceeding.


4. Apify Formatting: A Code n8n node ('format data for Apify INPUT type') transforms the Google Sheets output (the list of URLs) into the precise JSON structure required by the Apify Actor. This step also allows customizing scraping parameters like maxDepth or sameDomain.


5. Execution: The Apify n8n node ('Run Actor on Apify') executes the specialized Apify Email & Phone Extractor actor, offloading the heavy web scraping tasks to the Apify platform. This Apify n8n node handles the job submission.


6. Result Retrieval: A subsequent Apify n8n node ('Get Results from Apify') polls and retrieves the structured dataset containing all the scraped emails, phone numbers, and social links once the Apify job is finished.


7. Final Output: The last Google Sheets n8n node ('Add emails, phones, socials...') utilizes the new sheet ID to append the comprehensive, extracted contact data directly to the Google Spreadsheet, finalizing the output of the n8n workflow.

To successfully run this n8n template, you need to set up credentials for Google Sheets and Apify, and configure the input source.

1. Import the n8n Workflow

1. Copy the provided n8n workflow JSON code.


2. In your n8n instance, click '+ New' and then 'Import from JSON'. Paste the code.

2. Configure Credentials

3. Prepare the Input Sheet

1. In Google Sheets, create a new spreadsheet.


2. Create a sheet (e.g., named websites) and list the domains or URLs you wish to scrape in the first column (ensure each URL is in a separate row).

4. Configure the Workflow

1. Open the 'Set google sheet URL & original sheet name' n8n node.


2. Replace the placeholder value for googlesheeturl with the URL of your prepared spreadsheet.


3. Verify the googlesheetname matches the name of your input sheet (e.g., websites).

5. Run the n8n Workflow

This n8n workflow relies on a mix of core logic nodes, data manipulation, and external service integrations:

When clicking ‘Execute workflow’ (Manual Trigger): The starting point, acting as the primary n8n trigger to initiate the data enrichment.
Set google sheet URL & original sheet name (Set n8n node): Essential for workflow modularity. It defines variables (googlesheeturl and googlesheetname) used dynamically by subsequent Google Sheets nodes.
Google Sheets n8n node (Get website URLs / Create new sheet / Add emails...): Handles all interaction with the spreadsheet. It reads the input URLs, creates a new output sheet, and finally appends the extracted contact data.
format data for Apify INPUT type (Code n8n node): This customization node takes the raw URL list and converts it into the precise input schema required by the Apify Actor, including setting crawling parameters like maxDepth: 1 and sameDomain: true.
Run Actor on Apify (Apify n8n node): Executes the remote web scraping task. It specifically calls the anchor/email-phone-extractor Apify Actor using the dynamically generated input from the previous n8n node.
Get Results from Apify (Apify n8n node): Waits for the extraction job to finish and retrieves the dataset, delivering the enriched contact information back into the n8n workflow items.