Automate Business Lead Scraping from Apify to Google Sheets with Data Cleaning
    100%
    Automation
    0(0 reviews)
    1700 downloads

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

    NM

    Curated by n8n Markets team

    Last updated: March 8, 2026

    ๐Ÿš€ 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

    What's Included

    • Complete n8n workflow template with 0 nodes. Ready to import and customize.

    Requirements

    n8n instance (self-hosted or cloud). credentials.

    How to Use

    1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation

    Apps in this n8n workflow

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0++
    • Setup time: 15-30 min

    Included in Builder Pro โ€” $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Mar 2026
    v1.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Dependencies & Requirements

    Google Sheets
    Data

    โš ๏ธ 1 service require credentials. Make sure you have accounts set up before importing.

    Reviews

    0

    No reviews yet

    See all 0 reviews โ†“
    โ€”

    0 reviews

    5โ˜…
    0
    4โ˜…
    0
    3โ˜…
    0
    2โ˜…
    0
    1โ˜…
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought