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