Automate Lead Scraping with Scrapeless to Google Sheets with Data Cleaning

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "id": "tuw3biw6upnFtvFb",
  "meta": {
    "templateId": "4295",
    "templateCredsSetupCompleted": true
  },
  "name": "Automate Business Lead Scraping from Scrapeless to Google Sheets with Data Cleaning",
  "tags": [],
  "nodes": [
    {
      "id": "331e904a-362e-4b18-ac01-60bd138a7ee1",
      "name": "Manual Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        500,
        760
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fb61d5a9-0352-4079-a00f-c42df06bb09e",
      "name": "Clean Data",
      "type": "n8n-nodes-base.code",
      "position": [
        980,
        760
      ],
      "parameters": {
        "jsCode": "const items = $input.all();\nconst cleanedData = items.map((item) => {\n  return {\n    title: item?.json?.metadata?.title,\n    description: item?.json?.metadata?.description,\n    url: item?.json?.metadata?.url,\n  };\n});\nreturn cleanedData;\n"
      },
      "typeVersion": 2
    },
    {
      "id": "a6988139-87e5-423c-bec9-ce155f617dab",
      "name": "Export to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1180,
        760
      ],
      "parameters": {
        "columns": {
          "value": {
            "url": "={{ $json.url }}",
            "title": "={{ $json.title }}",
            "description": "={{ $json.description }}"
          },
          "schema": [
            {
              "id": "title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "description",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "title"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Nb23KkxxuIWC3rS2Fo3ZqX1K55z6El96p7HfdVeKd4s/edit#gid=0",
          "cachedResultName": "test"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Nb23KkxxuIWC3rS2Fo3ZqX1K55z6El96p7HfdVeKd4s",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Nb23KkxxuIWC3rS2Fo3ZqX1K55z6El96p7HfdVeKd4s/edit?usp=drivesdk",
          "cachedResultName": "Scrapeless-business-lead-scraping"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "04a980cf-365b-4cc3-8439-fd71cb1f05a3",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        260,
        200
      ],
      "parameters": {
        "color": 7,
        "width": 1660,
        "height": 780,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b0bec9e9-af6c-4aa6-a41f-fd015f5d2d0f",
      "name": "Scrape",
      "type": "n8n-nodes-scrapeless.scrapeless",
      "position": [
        780,
        760
      ],
      "parameters": {
        "url": "https://www.linkedin.com/company/amazon/",
        "resource": "crawler"
      },
      "credentials": {
        "scrapelessApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {},
  "versionId": "a12fc25e-f246-423e-9b65-2256f0917cf6",
  "connections": {
    "Start": {
      "main": [
        [
          {
            "node": "Variables",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape": {
      "main": [
        [
          {
            "node": "Clean Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clean Data": {
      "main": [
        [
          {
            "node": "Export to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Scrape",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Export to Google Sheets": {
      "main": [
        []
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• googleSheetsOAuth2Api
• scrapelessApi

About this workflow

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. A n8n account (free trial available) A Scrapeless account and API key A Google account to access Google Sheets

Source: https://n8n.io/workflows/5340/ — original creator credit. Request a take-down →

More Marketing & Ads workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.