How would I create a table that scrapes Google My Business listings for recently closed kayak rental businesses that had a physical location (not a service area)?
To create a table scraping Google My Business listings for kayak rental businesses: 1. Create New Table: Click "Create New Table" from Clay homepage and select "Google Maps" as your data source 2. Set Search Parameters: Enter "kayak rental" as your business type and specify your target location 3. Configure Search: Use our "Find Local Businesses using Google Maps" tool which leverages Google Places API to retrieve detailed business information including names, addresses, and ratings Note: Our Google Maps integration doesn't have built-in filters for "recently closed" businesses or distinguish between physical locations vs service areas. You'll need to manually review results or use additional enrichment columns to identify closed businesses and verify physical locations The search will return active businesses, so you may need to cross-reference with other data sources to identify recently closed establishments.
Will the search only pull active businesses?
Hi there! Thanks for reaching out. The Google Maps search in Clay will not automatically filter out closed businesses. Current Behavior: The Google Maps integration pulls businesses that appear on Google Maps, but it doesn't automatically exclude permanently or temporarily closed businesses. How to Identify Closed Businesses: To detect closed businesses, you'll need to use additional enrichment methods: 1. Website Scraping You can scrape the Google Maps page for each business to look for status indicators like: • "Permanently closed" • "Temporarily closed" • These status messages typically appear near the beginning of the page 2. Multi-pronged Verification Since there's no "one-stop shop" for business status verification, you can create a scoring system that checks multiple factors: • Social media presence verification • Phone number validation • Website accessibility • Online directory listings (Yellow Pages, Yelp) • Customer review analysis 3. Review Analysis You can use AI to analyze recent reviews that might mention the business being closed Recommended Workaround: The most reliable approach is to: 1. Pull all businesses from Google Maps (including closed ones) 2. Add enrichment columns to check business status through web scraping 3. Filter results based on the status information you collect This gives you more control over which businesses to include or exclude based on your specific needs. Let me know if you need help setting up any of these enrichment workflows!
This isn't the originally intended use case for the Google maps integration. So it should work, pulling all results on Google maps, but once a result is closed long enough I don't know if it will stay on Google maps. Please let me know if you need help implementing the above. We can also try a mix of Claygent prompts as an alternate option.