G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
Back to Automate business lead scraping from Apify to Google Sheets with data cleaning

Set Up: Automate business lead scraping from Apify to Google Sheets with data cleaning

This workflow launches an Apify scraper to extract business leads, then automatically cleans the data by formatting phone numbers and emails. The processed leads are exported to Google Sheets with organized company names, contact details, and addresses.

What This Automation Does
1

Configure Apify credentials

Sets up required Apify token and task ID variables to authenticate and specify which scraper to run.

2

Run Apify lead scraper

Launches the configured Apify task to scrape business leads and retrieves the raw dataset results.

3

Clean and format data

Processes scraped results by removing non-numeric characters from phone numbers and formatting email addresses to lowercase.

4

Export to Google Sheets

Appends the cleaned lead data to your specified spreadsheet with organized columns for company names, phone numbers, and addresses.

Prerequisites

  • Apify account with valid API token
  • Existing Apify scraping task configured
  • Google Sheets account with OAuth2 access
  • Target Google Sheets spreadsheet created