Automate Business Lead Scraping from Apify to Google Sheets with Data Cleaning

πŸš€ Automated Lead Scraper Workflow (Apify + n8n + Google Sheets)

🧠 What It Does

This n8n workflow automates the process of scraping leads using Apify, cleaning the extracted data, and exporting it to Google Sheetsβ€”ready for use in outreach, prospecting, or CRM pipelines.

πŸ”„ Workflow Steps

βœ… Start – Manually triggers the workflow. 🧩 Set Variables – Stores required Apify credentials:

APIFY_TOKEN: Your Apify token. APIFY_TASK_ID: The Apify task to run. πŸ•ΈοΈ Run Apify Scraper – Launches the scraper and fetches the dataset. 🧹 Clean Data – Processes scraped results to:

βœ‚οΈ Strip non-numeric characters from phone numbers. βœ‰οΈ Format emails (lowercase + trimmed). πŸ“Š Export to Google Sheets – Appends clean data to your spreadsheet:

🏒 company name β†’ from title πŸ“ž phone β†’ cleaned number πŸ“ address β†’ from scraped info

πŸ› οΈ Requirements

πŸ•·οΈ Apify Account

A valid APIFY_TOKEN An existing Apify task (APIFY_TASK_ID)

πŸ“— Google Sheets Access

OAuth2 credentials set up in n8n (e.g., "Google Sheets account 2")

🚦 How to Use

βš™οΈ Open the Variables node and plug in your Apify credentials. πŸ“„ Confirm the Google Sheets node points to your desired spreadsheet. ▢️ Run the workflow manually from the Start node.

πŸ“₯ Output

A ready-to-use sheet of cleaned lead data containing:

Company names Phone numbers Addresses

πŸ’Ό Perfect For:

Sales teams doing outbound prospecting Marketers building lead lists Agencies running data aggregation tasks

0
Downloads
17006
Views
8.84
Quality Score
beginner
Complexity
Author:David Olusola(View Original β†’)
Created:8/13/2025
Updated:11/17/2025

πŸ”’ Please log in to import templates to n8n and favorite templates

Workflow Visualization

Loading...

Preparing workflow renderer

Comments (0)

Login to post comments