YellowPages Scraper — US Business Leads

Scrape US business listings from YellowPages.com into clean JSON, CSV or Excel. Get the business name, category, phone number, full address, website, rating, review count and years in business for any business type in any US city, state or ZIP. Built for bulk lead generation and fast, reliable prospecting.

Features

• 🏢 Business details — name, category and YellowPages listing URL per result
• ☎️ Phone numbers — the direct contact number, the key lead-gen field
• 📍 Full address — street, city, state and ZIP, split into clean fields
• 🌐 Website — the business website link where listed
• ⭐ Rating & reviews — star rating and review count where available
• 📆 Years in business — longevity signal for qualifying leads
• 🔎 Search by term or URL — many categories at once, or paste your own search URLs
• ⚡ Bulk & structured — one clean row per business, ready for outreach or a CRM

Use cases

• B2B lead generation — build outreach lists with phone numbers and addresses
• Sales prospecting — find businesses in a category and city, then qualify by rating
• Local-market research — map suppliers and competitors across any US metro
• CRM enrichment — add phone, website and category to existing account lists
• Marketing lists — segment businesses by category, location and review signals
• Dataset building — assemble US business directories for analytics

How to scrape YellowPages

1. Add the YellowPages Scraper to your Apify account.
2. Enter one or more searchTerms (e.g. plumbers, dentists, electricians).
3. Set a location — a city and state or a ZIP (e.g. Austin, TX or 90210).
4. Optionally paste searchUrls copied from your browser, and set maxItems.
5. Click Run, then export as JSON, CSV or Excel — or pull the data via the Apify API.

Input

{
  "searchTerms": ["plumbers", "dentists"],
  "location": "Austin, TX",
  "maxItems": 200
}

Field	Description
searchTerms	Business categories or keywords, e.g. plumbers, dentists, roofers
location	City and state or ZIP, e.g. Austin, TX or 90210
searchUrls	Optional YellowPages search URLs to scrape directly
maxItems	Maximum number of businesses to return

What you get

{
  "name": "Radiant Plumbing & Air Conditioning",
  "categories": ["Plumbers", "Air Conditioning Service & Repair"],
  "phone": "(512) 263-9988",
  "street": "8309 Cross Park Dr",
  "city": "Austin",
  "state": "TX",
  "zip": "78754",
  "website": "http://www.radiantplumbing.com",
  "rating": 4.5,
  "reviewCount": 218,
  "yearsInBusiness": 25,
  "url": "https://www.yellowpages.com/austin-tx/mip/radiant-plumbing-air-conditioning-460112233",
  "sourceUrl": "https://www.yellowpages.com",
  "collectedAt": "2026-08-28T12:00:00.000Z"
}

Output schema

Field	Type	Description
name	string	Business name.
categories	array	Business categories listed for the result.
phone	string	Contact phone number.
street	string	Street address.
city	string	City.
state	string	Two-letter US state code.
zip	string	ZIP code.
website	string (URL)	Business website, where listed.
rating	number	Star rating, where available.
reviewCount	number	Number of reviews, where available.
yearsInBusiness	number	Years in business, where listed.
url	string (URL)	Business listing URL on YellowPages.
sourceUrl	string (URL)	Base source site URL.
collectedAt	string (ISO date)	When the record was collected.

Related Actors

Combine YellowPages with other business and reviews sources:

• BBB Scraper — Better Business Bureau listings with ratings and phone numbers.
• Google Maps Scraper — local businesses with ratings, phone and address.
• Google Maps Email Extractor — business emails for outreach.
• Trustpilot Reviews Scraper — company reviews and ratings.
• Website Contact Scraper — emails, phones and socials from websites.

FAQ

Do I need any account or setup? No setup — just enter search terms and a location, then run.

How many businesses can I get per run? Use maxItems to cap results. Run different searchTerms and location combinations to widen coverage across the US.

Can I search several categories at once? Yes. Add multiple searchTerms and they are each combined with your location. You can also paste multiple searchUrls.

Does it include phone numbers and websites? Yes — the contact phone, website and full address (street, city, state, ZIP) are included where listed.

What's the output format? Structured JSON — one row per business. Export as JSON, CSV or Excel, or via the Apify API.

Using YellowPages Scraper with n8n

The dataset works well in automations. In n8n, run the Actor with the Apify node (or an HTTP Request to the Apify API), then map each business row to your CRM, Google Sheets, a spreadsheet, or an email-outreach step. One clean row per business keeps downstream mapping simple.

Can I use this in n8n or Make? Yes. Trigger a run and read the dataset via the Apify API or the Apify node, then push rows into your workflow.

Is scraping YellowPages legal? Only public data shown to any visitor on YellowPages.com is collected. This is an independent tool, not affiliated with YellowPages; review YellowPages' Terms of Service and any applicable marketing/data regulations for your use case.

---

Original clean-room implementation.