Automate Business Lead Scraping from Apify to Google Sheets with Data Cleaning
n8n template #4295Summary
Use templateπ 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: APIFYTOKEN: Your Apify token. APIFYTASKID: 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 cl
Hand off to your agent
Prompt
Help me set up the n8n workflow "Automate Business Lead Scraping from Apify to Google Sheets with Data Cleaning" (https://n8n.io/workflows/4295). It uses: Google Sheets, HTTP Request, Code. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Similar workflows
NameViews
- Generate AI Viral Videos with Seedance and Upload to TikTok, YouTube & Instagram215K
- Fully Automated AI Video Generation & Multi-Platform Publishing191K
- Scrape business emails from Google Maps without the use of any third party APIs150K
- AI-Powered Short-Form Video Generator with OpenAI, Flux, Kling, and ElevenLabs93K
- Clone Viral TikToks with AI Avatars & Auto-Post to 9 Platforms using Perplexity & Blotato84K
- Generate Leads with Google Maps82K
- OpenAI GPT-3: Company Enrichment from website content72K
- Google Maps Scraper47K