DEV Community

Public Rows
Public Rows

Posted on AI-assisted

Every dentist, agency or restaurant in a city as a CSV, from Google Maps, for $2 per 1,000

Finding every dentist, agency or restaurant in a city usually means scrolling Google Maps by hand and copying rows into a sheet. This turns a search and a place into a CSV: one row per business, with the phone number and website the listing itself publishes, from a licensed source that does not get blocked.

Disclosure: I built the actor this uses. The rows come from Google Maps through the licensed DataForSEO SERP API; nothing is scraped, and only the firm-level phone and website a business publishes on its own profile are kept.

What you get

One row per business found for your search and place: name, category and additional_categories, address, city and postcode, phone and website, rating and reviews_count, open_status and the full work_hours timetable, latitude and longitude, the place_id and cid that identify the listing, the google_maps_url that opens it, and is_sponsored for paid pins. A few extra fields come through when the listing has them: price_level, is_claimed, total_photos and a booking_url.

There is no review text, no photos and no names of the people behind a listing, only the firm-level contact details the business publishes.

What it costs

Item Price 1,000 businesses
Businesses $0.002 per business $2.00
First 20 businesses free −$0.04
Total about $2

Billing happens on your Apify account. The first 20 businesses of every run are free, so a first search costs nothing.

Steps

  1. Open Google Maps Business Leads on Apify and sign in or create a free Apify account.
  2. Write what to search in searches, one per line: a category, a brand or a phrase ("dentist", "vegan restaurant", "Shopify agency"). Each line is one search.
  3. Set where to search. Use locationName in Google's own naming ("Austin,Texas,United States", "Manchester,England,United Kingdom", "Pune,Maharashtra,India"), or give a coordinate instead, as latitude,longitude,zoom such as 30.2672,-97.7431,13z; zoom 13z covers a city district and 10z a metro area.
  4. Pick language for the result labels, and set maxPerSearch up to 700. Each block of up to 100 places is one request to the supplier, answered in seconds.
  5. Set maxItems and press Start.
  6. Download CSV, Excel or JSON from the Dataset tab, or push the rows into a CRM or a sheet through Apify's integrations. It is also an MCP tool through mcp.apify.com, so an agent can ask for the businesses in a place and get rows back.

Things worth knowing

  • Rows describe businesses, not people. phone and website are what the business lists on its own Google profile; review text, photos and the people-also-search list are not collected.
  • Sponsored pins are included in the results and flagged with is_sponsored; rank is the position in that search.
  • Searches are not de-duplicated across lines: the same business can come back under two different searches. cid identifies the business itself, so group on that if your search list overlaps.
  • If the supplier is unreachable the run waits and retries for several minutes; if it still gets nothing, it fails with the reason and you are not charged.
  • You can bring your own DataForSEO credentials in the two optional inputs if you prefer the supplier charge on your own account; the row price stays the same.

If you try it and something feels off, open an issue on the actor page; I read them.

Top comments (0)