claymation
Posts
Finding Local Businesses with Clay

Finding Local Businesses with Clay

Google Maps Search, UberEats, & Instagram

August 29, 2024 • Estimated Reading Time: 6 minutes

Heyo, Claymakers!

I’ve rolled back from a vacation in Costa Brava, Spain. It was a feast of Iberico Jamon, delicious seafood tapas, and 2.5 euro beers.

My love for food inspired me to play around with Google Maps Search within Clay.

Outside of SaaS selling to SaaS, there are a ton of companies that sell to local businesses. Let’s take a look at a couple things you can do with a restaurant search.

In this week’s post, I’ll show you how to:

Use Google Search to find restaurants in a specific location
Import a range of data on that restaurant
Use AI to look up whether delivery is available in UberEats
Find the restaurant’s instagram handle

Let’s dive in.

Google Maps Search + Research Automation

Step 1:

You can start off table searches in a bunch of different ways. For this one, choose the “Find Local Businesses using Google Maps” search.

This will pop up a window (Step 2) where you update the types of businesses you want to search for.

Step 2:

Now you can start inputting the search requirements. Note you can search via “Businesses” or a “Free Text” field.

There are a ton of different options here. For example:

Dentist Clinics
Hospitals
Bars
Spas
Hotels
And even Zoos & Nightclubs

This can be very powerful for the universe of vertical SaaS companies who sell into these niches.

Step 3:

Now you have a table that has brought in 100 results. I clicked into one to show all of the info that you can extract and then break out into different data columns.

Step 4:

Now you can add in a Claygent (AI Agent for automating manual research) to check if that restaurant is on UberEats. Check out how simple the prompt is below.

I also have some additional tips on prompting here:

Prompt that I used is this:

TIP: You can use the toggle to define whether or not that data point is necessary. This is helpful if some rows don’t have data. If all of them are toggle blue, and you have some rows that don’t have data, then you’ll run into some errors and not be able to complete the runs.

Here is the template that you can copy for this table.

Around the Kiln

First - if we aren’t connected, add me on LinkedIn. I post a ton of different GTM content there like the one below on SaaS to Service-as-Software. I’m also happy to connect you to help inside Clay: [email protected]