Automate Business Lead Scraping: Apify to Google Sheets + Cleaning

This n8n workflow automates lead generation by running an Apify scraper to extract business data like company names, phones, addresses, and emails. It then cleans the data—stripping non-numeric characters from phones and formatting emails to lowercase/trimmed—before appending it directly to a Google Sheets spreadsheet. Ideal for streamlining data collection without manual effort.

The workflow includes five key nodes: a manual Start trigger, Set Variables for Apify credentials (token and task ID), Run Apify Scraper to fetch results, Clean Data for processing, and Export to Google Sheets. This ensures output is structured and ready for CRM import or campaigns.

Requirements are straightforward: an Apify account with token/task ID and Google Sheets OAuth in n8n. Benefits include time savings on data scraping/cleaning (hours to minutes), higher data quality for outreach, and scalability for sales/marketing teams building lead lists.

Perfect for sales prospecting, agency data aggregation, or marketing pipelines—transform raw web data into actionable leads effortlessly.