Recipe · Apify Store · runs in muse
Local businesses in a table, with ratings, phones and websites
Ask Muse for one kind of business in one town and get back the places Google Maps lists, as a table of name, rating, review count, phone and website, best rated first. Twenty places cost about three cents.
What you get
We asked for 20 coffee shops in London, Ontario. These are the first eight, in the order Google Maps listed them.
| # | Place | Rating | Reviews | Phone | Website |
|---|---|---|---|---|---|
| 1 | Asmara Coffee House Old East Village · Coffee shop | 4.9 | 749 | (519) 913-3440 | asmaracoffeehouse.com |
| 2 | Studio Coffee Central London · Coffee shop | 4.7 | 103 | (226) 279-2647 | studio-coffee.ca |
| 3 | Almore Coffee Central London · Coffee shop | 5.0 | 86 | (519) 476-3358 | almorecoffee.com |
| 4 | Cherry’s Coffee House & Desserts Hyde Park · Coffee shop | 4.8 | 477 | (519) 933-4440 | cherrysdesserts.ca |
| 5 | Twins Café North London · Cafe | 4.9 | 1,239 | (519) 670-2611 | www.twinscafe.ca |
| 6 | Hutsul Coffee Space Glen Cairn · Cafe | 4.9 | 108 | (226) 242-0398 | hutsulcoffee.ca |
| 7 | Reset Social Cafe Central London · Coffee shop | 4.5 | 661 | (519) 645-8888 | www.resetsocial.cafe |
| 8 | PANINO MIO Highland · Coffee shop | 4.8 | 97 | (382) 577-2793 | none listed |
Rows also carry the address, coordinates, hours and a Maps link. The prompt below sorts all 20 by rating:
- 5.0
- Almore Coffee · 86 reviews · (519) 476-3358 · almorecoffee.com
- 4.9
- Twins Café · 1,239 reviews · (519) 670-2611 · www.twinscafe.ca
- 4.9
- Asmara Coffee House · 749 reviews · (519) 913-3440 · asmaracoffeehouse.com
- 4.9
- Hutsul Coffee Space · 108 reviews · (226) 242-0398 · hutsulcoffee.ca
- 4.8
- Cherry’s Coffee House & Desserts · 477 reviews · (519) 933-4440 · cherrysdesserts.ca
- 4.8
- PANINO MIO · 97 reviews · (382) 577-2793 · no website in the results
- 4.7–4.3
- 14 more, from Cappadocia Breakfast & Cafe (4.7, 1,774 reviews) down to Commonwealth Coffee (4.3, 1,020 reviews). Variety Cafe has no phone in the results.
Claude wrote this from the results of one real run on 2026-11-14, using the prompt below, with ties broken by more reviews. Download the results: all 20 rows, unchanged.
Run it in Muse
Connect Muse to Apify with the setup guide, then paste this and change the words in quotes:
Use the Apify connector to run the Actor automatic/google-maps-places-scraper with searchQueries ["coffee shop"], location "London, ON", countryCode "ca" and maxPlaces 20. If the run hasn't finished when the call returns, check its status until it has, then fetch the dataset items. Give me a table of name, rating, number of reviews, phone and website, best rated first, with ties broken by more reviews. Copy every value from the results, leave a cell empty when the results have no value, and don't run anything else.
Muse may ask you to approve the run. Ours took 5 seconds on Apify. No Muse? Paste the same input into the Actor's page on Apify.
What it costs
At the list prices we read on 2026-11-14, the Actor charges $0.005 per run start and $0.001 per place. The start is charged per GB of memory, and a default run uses 512 MB, so once. Twenty places: $0.005 + 20 × $0.001 = $0.025, about three cents. Apify bills your account; the free plan's $5 monthly credit covers about 200 such runs.
Make it yours
- Other businesses. Put several terms in
searchQueries, such as["dentist", "orthodontist"]. A place found twice is charged once. - A smaller area.
locationtakes a neighbourhood or postal code. Or givelat,lngandradiusMetersto keep only places inside a circle. - More places. Raise
maxPlaces. Each search also stops atmaxPlacesPerSearch(default 40, up to 500). - Emails. Google Maps has none. Ask Muse to pass the website column to
automatic/website-contact-extractorwithmaxPagesPerDomain2, which reads up to two pages per site, usually the homepage and contact page, for $0.001 a page plus a $0.005 start.
Good to know
- Rows come in Google's order, not by rating: the only 5.0 was third. And a 5.0 from 86 reviews is a weaker signal than a 4.9 from 1,239.
- Google matches loosely. Our “coffee shop” search included a bakery and a breakfast restaurant, and Google also files Cotti Coffee under “Brake shop”.
- Expect gaps: one place had no website, one no phone, and Cotti Coffee's website is a Facebook link, which the contact extractor skips without charge. None of our 20 rows had a price level or description.
- Weekly hours start on the day of the run, Saturday in ours, not on Monday.
- Review text isn't included, only the rating and the count.
Sources in this recipe
-
Google Maps Places
Collect places from Google Maps searches: name, rating, review count, address, categories, coordinates, website, phone, opening hours and Maps link, one row per place.
Machine-readable: openapi.json · llms.txt