
Curated by n8n Markets team
Last updated: March 8, 2026
๐ Automated Lead Scraper Workflow (Apify + n8n + Google Sheets) ๐ง What It Does This n8n workflow automates the process of scraping leads using Apify, cleaning the extracted data, and exporting it to Google Sheetsโready for use in outreach, prospecting, or CRM pipelines. ๐ Workflow Steps โ Start โ Manually triggers the workflow. ๐งฉ Set Variables โ Stores required Apify credentials: APIFY_TOKEN: Your Apify token. APIFY_TASK_ID: The Apify task to run. ๐ธ๏ธ Run Apify Scraper โ Launches the scraper and fetches the dataset. ๐งน Clean Data โ Processes scraped results to: โ๏ธ Strip non-numeric characters from phone numbers. โ๏ธ Format emails (lowercase + trimmed). ๐ Export to Google Sheets โ Appends clean data to your spreadsheet: ๐ข company name โ from title ๐ phone โ cleaned number ๐ address โ from scraped info ๐ ๏ธ Requirements ๐ท๏ธ Apify Account A valid APIFY_TOKEN An existing Apify task (APIFY_TASK_ID) ๐ Google Sheets Access OAuth2 credentials set up in n8n (e.g., "Google Sheets account 2") ๐ฆ How to Use โ๏ธ Open the Variables node and plug in your Apify credentials. ๐ Confirm the Google Sheets node points to your desired spreadsheet. โถ๏ธ Run the workflow manually from the Start node. ๐ฅ Output A ready-to-use sheet of cleaned lead data containing: Company names Phone numbers Addresses ๐ผ Perfect For: Sales teams doing outbound prospecting Marketers building lead lists Agencies running data aggregation tasks
n8n instance (self-hosted or cloud). credentials.
1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation
Included in Builder Pro โ $19/mo, 4,177 premium workflows
Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.
100% Secure Checkout
Refund requests within 7 days of a new subscription
โ ๏ธ 1 service require credentials. Make sure you have accounts set up before importing.
0 reviews
No reviews yet.
Log in to ask a question.
No questions yet. Be the first to ask!