Hi everyone, I’m trying to build a list of HORECA businesses in Spain using Clay, but I’m running into a common issue — many of these companies don’t have LinkedIn profiles or websites. My goal is to capture key data (name, address, phone number, website if available, social links, etc.) so I can filter and segment them in Clay. Has anyone set up a reliable workflow to capture and enrich local business data from sources like Google Maps, TripAdvisor, Yelp, or similar? I’m especially interested in whether you’ve done this:
Directly inside Clay
Or by connecting Clay to external scrapers/APIs (like Apify or SerpAPI)
Any examples or tips for filling the gap when businesses have no LinkedIn and no website would be super helpful Thanks in advance!
Samuel A. i was working on a similar problem that i wanted businesses where website and linkedin and not available. I used the maps feature to fetch local businesses. I am not sure if this will be helpful or not
Anirudh S. Thanks, I’m solving it in a similar way. How did you handle finding employees to contact once you had the business list?
There is a enrichment that you can use "find contact from companies" or something similar. That will get you the employees. You can use job titles to find employees (based on the hierarchy of the person you want) you can limit 10 to 15 people per company. That will help you limit the total people you reach out to from a single account
understood, thank you very much
Hey Samuel, for Spain HORECA without LinkedIn/website, I use Google Maps scraping (Apify/SerpAPI), then enrich in Clay via socials (FB/Instagram) or directories like TripAdvisor/Páginas Amarillas. Works well for emails/phones even when only a GMB profile exists. Happy to share my Clay recipe if useful. Best, Sourabh Panoptic Analytics panopticanalytics.com sourabh@panopticanalytics.com LI: https://www.linkedin.com/in/sourabh85/
Hi there. Thanks for sharing this. I think you have a good handle on the best options here – native search, Google Maps, SerpAPI, etc. – but also wanted to mention we have a newer integration with OpenMart. You can use that as your import/source for a new table. I think their data is a bit stronger in the U.S. right now, but they do well with smaller businesses, and it might be worth a look for you.
