Automate Lead Scraping with Scrapeless to Google Sheets with Data Cleaning

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