Skip to main
All claybooks
/
Other
/
Find new coffee shops in your city with high ratings and your favorite menu options

Find new coffee shops in your city with high ratings and your favorite menu options

What does this have to do with marketing and sales? Absolutely nothing. But Clay knows no boundaries, and we know you love coffee ;)

Start building now with
Google Sheets
Download the template
Get started

Before you begin

Tired of going to the same coffee shops every day? Me too. 

Especially since I don’t love any of the coffee shops I already go to: bad mocha, no vegetarian options, long lines, overwhelming menus. 

So I used Clay to create a comprehensive cafe exploration guide—one that includes locations, ratings and reviews, phone numbers, and the food items that I love most. 

What does this have to do with sales and marketing? Don’t all sales and marketing professionals drink coffee? Just me?

Kidding. This fun, quirky claybook was part of my onboarding project at Clay. 

Here’s how it works: 

  • Cafe Discovery: First we import cafes using Google Maps as the data source. Ideally, we'd have 52 cafes—one for each week of the year.
  • Data Enrichment: Next, we enhance the dataset with details like address, number of reviews, ratings, and top dishes. You can also categorize cafes into themes like “work-friendly,” “date night,” or “upbeat vibes” based on your mood.

Send to Google Sheets: Last, we send cafe data to a separate Google Sheet. Bonus: You can use Clay’s native integration with Slack to post recommendations in a private channel instead!

Information
Follow the step by steps here in Clay
Download the free template
1

First, copy the exact Clay workbook template we use to run this Claybook here. 

If you’re already a user, you’ll be directed to your workspace. If not, you’ll be prompted to create a free Clay account.

The interactive demos on the right will guide you through each step of this Claybook.

‍

2
Step 2:

Import coffee cafes in your region

Next, using the “Find local businesses with Google maps” native integration in column one, select the region you want to investigate, then import selected cafes to the table.

‍

As soon as you import coffee shops, the rest of the table will run automatically: Claygent will analyze the cafe’s website for its top dishes, then classify it based on its atmosphere, offerings, target audience, and unique features. And we’ll enrich cafes with phone numbers, locations, reviews, ratings, and more.

‍

3
Step 3:

Send cafes to a Google Sheet

Next, we’re going to send each cafe result (along with phone numbers, addresses, style, vegetarian dishes, etc.) to its own row in a Google Sheet. From here, we can check for new cafe spots manually, or we can proceed to the next step and have Clay send Slack alerts every morning. 

‍

From here, you can add a Slack integration column to send cafe updates to a Slack channel, or use Zapier to

‍

Other popular resources

Experts

Find a Clay Expert

Explore our network of Clay experts and agencies.

View experts
Community

Join our slack community

Find help in our slack community, and support channels.

Go to slack
Cohorts

Join a cohort, learn Clay fast!

The faster way to master Clay. Sign in if you're enrolled in a cohort (current or past) or apply to an upcoming one!

Learn more about cohorts