AutomationMart
Home/Browse/Automate business lead scraping from Apify to Google Sheets with data cleaning
n8n

Automate business lead scraping from Apify to Google Sheets with data cleaning

n8nn8n5 modulesv1.0
Google Sheets

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
Automate business lead scraping from Apify to Google Sheets with data cleaning workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

About the Automation Staying on top of competitor pricing changes can be a full-time job. Manual price tracking is time-consuming and prone to errors, especially when dealing with complex pricing structures and multiple subscription tiers. Paid competitor price monitoring tools like Competera, Visualping and Fluxguard can be expensive. What if you could automate this process and get instant alerts when competitors adjust their pricing? How to easily monitor competitor pricing With this automatio

Free

Add backlinks to Google Sheets from DataForSEO

Add backlinks to Google Sheets from DataForSEO. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/17e_xcmsMDzSdDU72S_QTxuxzOYIl3s5-aS8fOcgGOok/edit?usp=sharing).

Free

Beginner AI dataset generator using OpenAI + LangChain in n8n

This n8n workflow dynamically generates a realistic sample dataset based on a single topic you provide. It uses OpenAI (via LangChain) and n8n’s built-in nodes to: 1. Generate structured JSON data for 5 columns with 3–5 values each 2. Flatten that data into a single text blob 3. Infer meaningful column names via a second AI call 4. Pivot, split, merge, and rename columns automatically 5. Output a clean, labeled dataset ready for export or further processing ---

Free

Add new ActiveCampaign subscribers to a Google Sheets spreadsheet

Every time a new subscriber is added to ActiveCampaign, Make will automatically add that subscriber to a new row in a Google Sheets spreadsheet. If you want to use this template as it is, you need to create a table according to this [example] (https://goo.gl/HofgmG).

Free

Save new YouCanBook.me bookings to a Google Sheets spreadsheet and watch for reschedulations at regular intervals

Make at regular intervals watches new or rescheduled bookings and automatically add that bookings info to a new row in your Google Sheets spreadsheet. You can use this [example spreadsheet](https://docs.google.com/spreadsheets/d/10tYzkqwF1Yad0wAcGAMeLKqjS8VWMrYiSkH4zyplq_0/edit?usp=sharing).

Free

Classify documents with Gemini and organize them in Google Drive

Who is this for Accountants and office managers who want to automatically classify and organize documents in Google Drive. What this workflow does Retrieves files from a Google Drive inbox folder, classifies each using Gemini 2.5 Flash OCR, then renames, moves, and logs them. Get inbox files → Loop through files → Download file fetches files one by one. Check file type routes PDFs and images to Convert to Base64; unsupported formats go to Handle unsupported format → Send error notification → Log

Free

Manage Brevo contact lists with full CRUD and bulk membership control

Brevo List Management Master Template Master advanced Brevo list operations that go beyond the native n8n node. This template provides a complete toolkit for dynamic email marketing automation, allowing you to manage lists and contact memberships with professional-grade precision. Key Features Full List CRUD: Create, Read, Update, and Delete Brevo lists via API. Auto-Pagination: Pre-configured pagination settings to handle hundreds of lists or thousands of contacts automati

Free

Automated reservation system with Telegram, Google Gemini AI, and Google Sheets

What It Is SmartReserve is a flexible, automated Telegram chatbot built in n8n that allows users to request and confirm reservations for any kind of resource—training sessions, equipment, appointments, event slots, or more. It connects with Google Sheets for live availability tracking and automatically sends confirmation emails to your users. ⚙️ How It Works Telegram Chatbot Interface Users interact with a friendly bot to submit their reservation request. The bot collects: Date

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free