跳到正文
DEV Community· Public Rows·· 2 天前AI 評分52

Google Maps Business Leads 可按每 1,000 家 $2 匯出商戶 CSV

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

AI 導讀

Public Rows 建立的 Google Maps Business Leads 可按搜尋詞和地點整理 Google Maps 商戶資料,並匯出 CSV。每 1,000 家收費 $2,每次執行首 20 家免費;資料經授權的 DataForSEO SERP API 取得,不進行抓取,只保留商戶在自家商家檔案上公開的公司電話和網站。

正文

Public Rows

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.

來源:DEV Community · dev.to