Hey man, I totally feel your pain, doing this manually is indeed torture, I've been there! The good news is there are definitely tools that can save you. For a no code solution, you've got options like browser extensions that add export buttons directly to Google Maps, super easy to use, just install and click. Or there are visual scrapers where you enter your search term and get a spreadsheet back without any setup hassle. If you're okay with something slightly more technical but still not coding heavy, there are open source tools that run in the background and can pull hundreds of listings at once. Most of these will grab exactly what you need: names, addresses, phone numbers, websites, and sometimes even ratings and emails if they're public. Just be aware that Google's terms of service don't love scraping, so take it slow, maybe use a VPN if you're doing thousands of listings. But for getting through those hundreds of businesses in your city, these tools will save your sanity.
