Clay (Free) to find and enrich local coffee shops and automate Slack alerts
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!
Steps
Copy this template
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.
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.
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
Copy the template
Leverage Clay’s “Find businesses with Google Maps” feature to locate new coffee shops in your region.
Copy this template to start enriching and automating pre-meeting notes with Clay.
Learn with our resources
Check out Clay University, read our GTM blog, or try out our top templates to transform your growth ideas into outreach in minutes.
Clay University
Master Clay in a few core lessons. Uplevel your data enrichment, craft better outbound messages, and book more meetings.
Go to market blog
Our best content on growing your GTM motion, from outbound sales automation to AI lead generation.
Integrations
Browse through all the integrations you can connect to Clay in seconds and discover what you can do!
Clay Experts
Hire a Clay Enterprise expert or find a Clay partner to help with your next project
Clay's Chrome extension
Clay’s Chrome Extension makes it wicked easy to find leads almost anywhere on the internet