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:

   • APIFY_TOKEN: Your Apify token.
   • APIFY_TASK_ID: 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:

   • 🏢 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

1. ⚙️ Open the Variables node and plug in your Apify credentials.
2. 📄 Confirm the Google Sheets node points to your desired spreadsheet.
3. ▶️ 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