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 tas
At a glance
Automate business lead scraping from Apify to Google Sheets with data cleaning is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 5
- Price
- Free
- Version
- v1.0

About this workflow
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: 🏢 company name → from title 📞 phone → cleaned number 📍 address → from scraped info --- 🛠️ Requirements 🕷️ Apify Account A valid APIFYTOKEN An existing Apify task (APIFYTASKID) 📗 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 ---
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Get notified when your competitors change their pricing with Airtop and Slack
Add backlinks to Google Sheets from DataForSEO
Beginner AI dataset generator using OpenAI + LangChain in n8n
Add new ActiveCampaign subscribers to a Google Sheets spreadsheet
Save new YouCanBook.me bookings to a Google Sheets spreadsheet and watch for reschedulations at regular intervals
Classify documents with Gemini and organize them in Google Drive
Manage Brevo contact lists with full CRUD and bulk membership control
Automated reservation system with Telegram, Google Gemini AI, and Google Sheets
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you