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

n8n template #4295

Summary

🚀 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: APIFYTOKEN: Your Apify token. APIFYTASKID: 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 cl

How to set it up

Open template #4295 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create a credential under Credentials → Add credential: Google Sheets. Then open each of those nodes and pick the credential.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Automate Business Lead Scraping from Apify to Google Sheets with Data Cleaning" (https://n8n.io/workflows/4295). It uses: Google Sheets, HTTP Request, Code. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Google Sheets HTTP Request Code

Questions

Yes. David Olusola published it free on n8n.io as a verified creator, and it has 17K views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets. The other 2 nodes are built into n8n.

Similar workflows

NameViews