Generate Business Leads with OpenStreetMap Data and Save to Google Sheets

Generate targeted business leads worldwide — for free.

This workflow uses the OpenStreetMap Overpass API to gather detailed business info for any industry and location. It scrapes websites to fill gaps like missing emails, cleans and organizes data, and saves it all to Google Sheets — perfect for small businesses, marketers, real estate agents, and sales teams looking to build rich prospect lists without expensive APIs.

What it does:

🔍 Searches OpenStreetMap for businesses matching your keywords and locations

🌐 Scrapes business websites to extract missing emails

🧹 Cleans, deduplicates, and filters contact data

📊 Saves comprehensive leads with names, addresses, phones, emails, social links, and more to Google Sheets

✅ Setup guide & importable workflow included

Need help customizing queries or Google Sheets integration? We offer full setup and testing for a one-time fee.