Automate business lead scraping from Apify to Google Sheets with data cleaning

Automatically scrapes business leads using Apify, cleans the data, and exports formatted results to Google Sheets for outreach and prospecting.

workflowlead_generation

by David Olusolaon n8n

Nodes

Triggers

Platform

n8n

Tech Stack

Google Sheets

How It Works

This workflow launches an Apify scraper to extract business leads, then automatically cleans the data by formatting phone numbers and emails. The processed leads are exported to Google Sheets with organized company names, contact details, and addresses.

Configure Apify credentials

Sets up required Apify token and task ID variables to authenticate and specify which scraper to run.

Run Apify lead scraper

Launches the configured Apify task to scrape business leads and retrieves the raw dataset results.

Clean and format data

Processes scraped results by removing non-numeric characters from phone numbers and formatting email addresses to lowercase.

Export to Google Sheets

Appends the cleaned lead data to your specified spreadsheet with organized columns for company names, phone numbers, and addresses.

What You'll Need

Attached Files

workflow.json