Tomasz S.

Hey guys, Maybe some of you Clay power users could help me with my task that I am trying to solve whole day. I am from Poland, important info :) The goal is to find all local business in one small city, like "Grodzisk Mazowiecki". So the goal is I want to have a list with all let's say restaurants and bars in Grodzisk Mazowiecki following this pattern: Name, City, Website, Phone number and e-mail. The problem is that with template based on Google ApI it doesn't work well with predefined business types, so I need to use "Free text" mode. And here is the question, if you know how to best prompt this search query, cause I was trying multiple types:

Plus I am seeing when I was not adding keyword with location such as "Grodzisk Mazowiecki" I was getting a lot of restaurants from different places around Grodzisk. It would be also nice if I could create just one long list and input for example all type of businesses I need: Warsztaty samochodowe "Instalatorzy pv Lokalne sklepy spożywcze Małe warsztaty stolarskie Małe kawiarnie i restauracje Pralnie Gabinety weterynaryjne Zakłady kosmetyczne i Spa Zakłady fryzjerskie i Barber Shop Biura lokalne (prawnicze, księgowe) Małe drukarnie Serwisy komputerowe Zakłady fotograficzne/studia graficzne", but I tried this method and it's even worse when I try to do more than 2 type of businesses. For now what I found the best method is to scrap for Google Maps with some web scrapper tool, the URL links and names and then import it into Clay and write Claygen AI prompt than would do it. But then it gives the data unstructured, so maybe you know how can I prompt it so it will create 3 additional columns with website, phone number and phone. Photo with current solution Pls help :)