AutomationMart
Home/Browse/Automate lead scraping with Scrapeless to Google Sheets with data cleaning
n8n

Automate lead scraping with Scrapeless to Google Sheets with data cleaning

n8nn8n4 modulesv1.0
Google Sheets

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Prerequisites - A n8n account (free trial available) - A Scrapeless account and API key - A Google account to access Google Sheets --- 🛠️ Step-by-Step Setup 1. Create a New Workflow in n8n Start by creating a new workflow in n8n. Add a Manual Trigger node to begin. --- 2. Add the Scrapeless Node - Add the Scrapeless node and choose the Scrape operation - Paste in your API key - Set your target

At a glance

Automate lead scraping with Scrapeless 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
4
Price
Free
Version
v1.0
Automate lead scraping with Scrapeless to Google Sheets with data cleaning workflow diagram

About this workflow

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Prerequisites - A n8n account (free trial available) - A Scrapeless account and API key - A Google account to access Google Sheets --- 🛠️ Step-by-Step Setup 1. Create a New Workflow in n8n Start by creating a new workflow in n8n. Add a Manual Trigger node to begin. --- 2. Add the Scrapeless Node - Add the Scrapeless node and choose the Scrape operation - Paste in your API key - Set your target website URL - Execute the node to fetch data and verify results --- 3. Clean Up the Data Add a Code node to clean and format the scraped data. Focus on extracting key fields like: - Title - Description - URL --- 4. Set Up Google Sheets - Create a new spreadsheet in Google Sheets - Name the sheet (e.g., Business Leads) - Add columns like Title, Description, and URL --- 5. Connect Google Sheets in n8n - Add the Google Sheets node - Choose the operation Append or update row - Select the spreadsheet and worksheet - Manually map each column to the cleaned data fields --- 6. Run and Test the Workflow - Click "Execute Workflow" in n8n - Check your Google Sheet to confirm the data is properly inserted --- Results With this automated workflow, you can continuously extract business lead data, clean it, and push it directly into a spreadsheet — perfect for outbound sales, lead lists, or internal analytics. --- How to Use ⚙️ Open the Variables node and plug in your Scrapeless credentials. 📄 Confirm the Google Sheets node points to your desired spreadsheet. ▶️ Run the workflow manually from the Start node. 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

Add a new row in Google Sheets for every completed Pipefy card

Streamline your project management process by automatically logging completed tasks in Pipefy to Google Sheets. With this template, every time a card is marked as done in Pipefy, Make will create a new row in your Google Sheets, allowing you to easily track and analyze your project progress. This integration ensures that you maintain an organized record of your achievements, enhancing your team's productivity and accountability.

Free

Extract Google My Business leads by service or location with Bright Data

Extract Google My Business Leads by Service & Location with Bright Data to Google Sheets This template requires a self-hosted n8n instance to run. A comprehensive n8n automation that extracts Google My Business listings by service type and geographic location using Bright Data's Google Maps dataset, with intelligent city expansion and automatic duplicate removal. --- 👥 Who is this for? Lead generation professionals Sales teams Marketing agencies Business development representatives Entrepre

Free

Export QuestionPro survey responses to Google Sheets

This template helps you export your QuestionPro survey data. At the specified time interval (every hour, day, week, etc), Make will automatically export the survey responses to Google Sheets. The template uses [this example spreadsheet](https://docs.google.com/spreadsheets/d/1np3fc-EC9ZBtDm6funY5LA6lcArIqFL2bS92IYfW4sw/edit?usp=sharing).

Free

Send AI pre-op reminders with Google Calendar, Gmail, Sheets, Slack and GPT-4o

Description This workflow automates end-to-end pre-surgery checklist reminders and confirmation tracking for healthcare operations teams. It ensures patients receive timely preparation instructions, can confirm completion with a single click, and allows staff to monitor confirmation status in real time—without manual coordination. Every day at 9:00 AM, the workflow fetches surgery events from Google Calendar, extracts patient details from event descriptions, and generates a unique confirmat

Free

Send data to Google Sheets from your app and create a Slack message using a custom webhook

Automatically send data to Google Sheets from you app using HTTP and create a Slack message using a custom webhook. Streamline data management and communication with this integration.

Free

Score resume authenticity with GitHub, LinkedIn, OpenAI and Google Sheets

Quick Overview This workflow accepts resume submissions via webhook or a weekday schedule, extracts verifiable claims from the resume text, cross-checks them against GitHub and LinkedIn data, uses OpenAI to generate a verification report, calculates an authenticity score, logs results to Google Sheets, and emails a summary via SendGrid. How it works 1. Triggers from an inbound webhook request or on a weekday cron schedule for batch verification. 2. Normalizes incoming candidate data (ID, name, r

Free

Analyze Google Sheets data with OpenAI-powered data agent

Welcome to Ozki Your Data Analyst Agent V1. The Ozki Data Analyst Agent is designed to analyze data from Google Sheets. To use it, you'll need to provide the URL of your Google Sheet file. The agent will then process the data and provide you with analysis results, including key performance indicators (KPIs). Configuration: Configure your credentials on the OpenAI model or select the n8n free OpenAI credits. Set up your agent memory. Use Simple Memory as default. Set your credentials to Google

Free

Serve inspirational quotes on-demand via webhook using ZenQuotes API

This n8n template lets you instantly serve batches of inspirational quotes via a webhook using the free ZenQuotes API. It’s perfect for developers, content creators, community managers, or educators who want to add dynamic, uplifting content to websites, chatbots, or internal tools—without writing custom backend code. --- 🔧 How it works - A Webhook node listens for incoming HTTP requests on your chosen path. - Get Random Quote from ZenQuotes sends an HTTP Request to and retrieves five random quo

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