Transform your B2B lead generation strategy with this comprehensive n8n workflow that automatically scrapes Google Maps for business data and enriches it with verified email contacts. This powerful automation pipeline eliminates manual prospecting by combining Google Maps data extraction with intelligent email discovery from websites and targeted Google searches. What this workflow does This n8n template creates a complete B2B lead generation system through a streamlined 7-step process. You define search queries, locations, and page counts in a Google Spreadsheet config sheet called "Leads." The workflow automatically creates timestamped results sheets to preserve previous runs, then reads your configurations to generate paginated search tasks targeting the HasData Google Maps API. The system processes 20 results per page, splits data into individual businesses, and removes duplicates by name and place ID. For businesses with websites, the HasData web scraper extracts emails directly from their URLs. When website emails aren't found, the workflow performs targeted Google searches using the pattern "business name, city" email "@" and parses organic results with regex to capture contact information. All discovered leads merge into a comprehensive dataset including business name, phone, address, website, emails, rating, reviews, and business type, automatically written to your Google Spreadsheet results sheet. Use cases Build targeted cold email campaigns with local business contacts Automate B2B prospecting for sales teams Conduct market research on competitors and industry players Populate CRM databases with enriched business data Generate leads for location-specific service offerings Technical details This workflow leverages essential n8n nodes including IF conditions, SET operations, CODE functions, MERGE capabilities, and SPLIT OUT logic. The automation requires the HasData n8n node package and integrates with Google Spreadsheets for configuration management and results storage. Setup involves installing the HasData n8n node on your self-hosted instance and connecting your HasData API credentials along with Google Sheets access. Perfect for automation engineers and SaaS operators seeking scalable lead generation without manual data entry or research overhead.
Related
Related
Related
Related