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

1. ✅ Start – Manually triggers the workflow. 2. 🧩 Set Variables – Stores required Apify credentials:

APIFYTOKEN: Your Apify token. APIFYTASKID: The Apify task to run. 3. 🕸️ Run Apify Scraper – Launches the scraper and fetches the dataset. 4. 🧹 Clean Data – Processes scraped results to:

✂️ Strip non-numeric characters from phone numbers. ✉️ Format emails (lowercase + trimmed). 5. 📊 Export to Google Sheets – Appends clean data to your spreadsheet: