Automate Business Lead Scraping from Apify to Google Sheets with Data Cleaning
VerifiedScrapes leads via HTTP, cleans data, and exports to Google Sheets.
What this workflow does
This automation uses an HTTP Request to retrieve data, standardizes contact fields, and appends records to Google Sheets.
It suits sales teams needing reliable lead capture and basic data prep before outreach.
Who is this for?
Sales development reps, growth marketers, and small outbound teams who need fresh leads without manual copy-paste work.
What problem it solves
Manually running Apify scrapers, cleaning phone numbers and emails, then pasting results into Google Sheets wastes hours and introduces errors.
What it automates
Weekly prospect list refresh
Run the workflow every Monday to pull new leads from an Apify actor and append clean rows to a shared outreach sheet.
Event attendee follow-up
Trigger after an event to scrape attendee data, normalize contacts, and push them straight into a campaign sheet.
CRM top-up before campaigns
Quickly generate a clean lead batch for an upcoming email sequence without leaving n8n.
How the workflow works
The 3 nodes in this automation, in order.
- 1Google SheetsgoogleSheets
- 2HTTP RequesthttpRequest
- 3Codecode
Apps & integrations used
How to set up Automate Business Lead Scraping from Apify to Google Sheets with Data Cleaning
- 1Add a Manual Trigger node as the start.
- 2Add a Set node and store APIFY_TOKEN and APIFY_TASK_ID.
- 3Add an HTTP Request node to call the Apify task run endpoint using the token.
- 4Add a Function or Set node to clean phones (strip non-digits) and lowercase emails.
- 5Add a Google Sheets node, select Append, and map the cleaned fields to your sheet columns.
- 6Activate the workflow and test with the manual trigger.
How to customize this workflow
- →Swap Manual Trigger for Schedule Trigger to run daily or weekly.
- →Add a filter after cleaning to drop rows missing email or phone.
- →Change the HTTP Request to a different Apify actor by updating the task ID.
- →Insert a Slack node after Google Sheets to notify the team when new rows are added.
Automate Business Lead Scraping from Apify to Google Sheets with Data Cleaning: pros & cons
Pros
- +Handles scraping, cleaning, and export in one flow
- +Uses only native n8n nodes plus HTTP Request
- +Beginner-friendly with clear variable setup
- +Data is normalized before it reaches Sheets
Cons
- –Still requires a paid Apify account for most actors
- –Manual trigger only; no built-in scheduling
- –Cleaning logic is basic and may need tweaks per data source
Frequently asked questions
It runs an Apify scraper via HTTP, cleans phone numbers and emails, then appends the results to Google Sheets.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other sales & crm automations worth a look.