Automated Company Data Scraper from Web and Google Maps

This n8n workflow automates the process of collecting business data from Google Maps and websites based on user-submitted forms. It begins with a form trigger where users specify keywords, locations, and the number of leads needed. The workflow then runs an Apify actor to scrape Google Maps for relevant business URLs, retrieves and cleans these URLs, and performs web scraping to extract detailed company information such as name, address, website, phone number, and ratings.

The workflow includes advanced URL parsing to remove query parameters and fragments, randomizes user agents for web requests, and efficiently scrapes website content with delay mechanisms to mimic natural browsing behavior. It also extracts email addresses from the scraped web content using regex filtering, ignoring false positives like image or script file extensions.

Finally, the data is filtered to include only records with valid emails and is then stored in Airtable, where users can view and manage their collected business leads. Sticky notes are used for process documentation, guiding setup and execution.

This automation is especially useful for marketing teams, lead generation agencies, or anyone needing to build a targeted contact database from Google Maps and website sources rapidly and accurately.