Hi - if I wanted to set up a table that would research and pull a list of all the city or county waterfront parks (lake, ocean, or slow moving river only) in the United States, what would be the best way to start?
Use Google Maps search in Clay to find waterfront parks by location. Create a new table, select Google Maps as your source, then search for terms like "waterfront park lake," "oceanfront park," or "riverside park" in specific cities/counties. For more targeted results, use Google search operators with quotes for exact matches: "waterfront park" AND ("lake" OR "ocean" OR "river") plus location terms. You can also perform keyword searches to find web pages mentioning waterfront parks, then scrape those sites for park listings. Start by adding your target cities/counties to a table, then use these search methods to pull park data systematically.
Is there a way to do it for an entire state all at once?
Clay's Google Maps search currently only allows you to search one geographic region at once, not entire states. For state-wide searches, consider using external tools like D7 Lead Finder or Outscraper for initial list generation across multiple geographies, then import the results into Clay for enrichment. Alternatively, create a table with all major cities/counties in your target state, then use Google Maps search with terms like "waterfront park lake," "oceanfront park," or "riverside park" for each location systematically. You can also use Google search operators with quotes for exact matches: "waterfront park" AND ("lake" OR "ocean" OR "river") plus location terms.
Hi there, Thank you for reaching out! That’s an interesting search you’re trying to perform. Currently, Clay doesn’t support setting up a search at the entire USA level in one go. However, you can achieve this by breaking it down by state: 1. Use the ‘Find Local Businesses with Google Maps’ integration to search for businesses in one state at a time. 2. Create separate tables for each state you want to cover. 3. Consolidate results into a central table by writing data from all state tables to a single destination table. This approach requires creating multiple tables (one per state), which can be time-intensive for all 50 states, but it’s the only way to accomplish this in Clay today. I hope this helps! Let me know if you have further questions. - Smit
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.