Yellow Pages US Scraper

Extract US local business data, contact leads, and directory intelligence

Yellow Pages US Scraper collects comprehensive business intelligence, verified contact details, and local commercial listings directly from the United States Yellow Pages directory. Whether you are building targeted B2B sales pipelines, evaluating local market competition, auditing regional merchant presence, or enriching customer relationship management (CRM) databases, this Actor delivers clean, structured records ready for immediate business use.

Each record extracted includes high-value data points: verified company names, telephone numbers, direct business website URLs, canonical Yellow Pages listing URLs, complete street addresses, city, state, and ZIP codes, primary and secondary industry categories, average customer rating scores, total review counts, operational open/closed status, years in business, price indicators, storefront logo images, and sample customer review excerpts.

The Actor runs using high-speed, lightweight HTTP requests designed for maximum throughput, low memory consumption, and predictable compute costs. Scraped datasets can be exported instantly to CSV, Excel, JSON, JSONL, XML, or HTML formats, or synced directly into automated workflows via webhooks, cloud integrations, and the official Apify API.

---

Why use Yellow Pages US Scraper?

• Comprehensive B2B Contact Profiles — Gather complete business records with phone numbers, official external websites, categorized trades, and full postal addresses.
• Fast and Cost-Efficient Execution — Optimized lightweight request architecture minimizes execution time and memory footprint, delivering hundreds of listings in seconds.
• Valuable Trust & Longevity Signals — Capture key commercial indicators including verified customer review volumes, average rating scores, operating status, and established years in business.
• Clean and Direct Destination URLs — Profile links and external company websites are automatically normalized into direct, canonical URLs suitable for CRM enrichment and cold outreach.
• Native Apify Dataset Table View — Includes pre-configured schema views enabling instant column filtering, sorting, and tabular inspection directly inside the Apify Console.
• Nationwide Geographic Coverage — Search any commercial category, keyword, or profession across any city, metropolitan area, county, or 5-digit ZIP code in all 50 US states.
• Configurable Result Depth — Fine-tune pagination from a quick single-page check (up to 30 listings) to deep multi-page directory crawls.
• Automatic Deduplication — In-memory deduplication ensures that duplicate listings across paginated result sets are resolved before records reach your dataset.
• Multiple Export Formats — Download datasets immediately in CSV, Excel (XLSX), JSON, JSONL, or XML for seamless integration with Google Sheets, Airtable, and business intelligence suites.

---

What data can you extract?

Yellow Pages US Scraper captures 16 structured fields per business listing:

Core Identity & Category

Field	Type	Description
rank	Number	Position ranking of the listing within the search results page.
businessName	String	Official commercial name of the business.
category	String	Comma-separated industry categories and trade classifications.
detailLink	String	Direct canonical URL to the complete listing profile on Yellow Pages.
logoURL	String	Direct link to the company's storefront image or logo photo.

Contact & Location Details

Field	Type	Description
phone	String	Primary formatted contact telephone number.
website	String	Official external company website URL (cleaned and direct).
address	String	Complete physical street address combined with locality.
locality	String	City, state abbreviation, and 5-digit ZIP code.

Reputation, Status & Commercial Indicators

Field	Type	Description
rating	Number	Customer satisfaction score (e.g., 4.5 out of 5 stars).
reviews	Integer	Total count of verified customer reviews.
yearsInBusiness	String	Reported number of years the company has been active.
priceRange	String	Price level indicator when published (e.g., $, $$, $$$).
openStatus	String	Current operating status (e.g., OPEN NOW, CLOSED NOW).
snippetReview	String	Featured customer review excerpt or highlighted testimonial.
time	Number	Unix epoch timestamp in milliseconds when the record was extracted.

---

Who is Yellow Pages US Scraper for?

• B2B Sales Teams & Account Executives — Construct targeted outbound calling and prospecting lists of local service businesses, trades, and medical providers.
• Digital Marketing Agencies & SEO Consultants — Identify established local businesses with missing websites, outdated listings, or low review counts to pitch high-value agency services.
• Market Researchers & Analysts — Evaluate regional merchant density, price distribution, and category saturation across distinct US metropolitan markets.
• Directory Publishers & Local Portals — Aggregate and maintain fresh, authoritative local business listings for community portals, industry directories, and search tools.
• Recruiters & Talent Sourcing Specialists — Locate trade contractors (electricians, HVAC specialists, roofers, plumbers) to fill skilled commercial positions.
• Franchise Developers & Retail Operators — Analyze competitor volume and service coverage in target neighborhoods before expanding operations or signing commercial leases.

---

Practical use cases

1. Targeted B2B outbound lead generation

Sales development representatives (SDRs) can pull hundreds of localized SMB contacts categorized by profession (e.g., roofing contractors in Dallas, TX, or pediatric dentists in Chicago, IL). With structured phone numbers, physical locations, and websites, leads can be uploaded straight into outbound calling dialers and automated email sequences.

2. Digital marketing and web design agency prospecting

Marketing agencies can filter extracted records for companies where the website field is empty or customer reviews is under 10. These represent ideal prospects for mobile-friendly web design, Google Business Profile management, reputation marketing, and local search engine optimization.

3. Regional competitor benchmarking

Businesses preparing to open a new branch or launch a local service can audit existing competitors across targeted ZIP codes. Comparing average customer ratings, operational longevity (yearsInBusiness), and category breadth provides an evidence-based roadmap for market entry.

4. Skilled trade and contractor recruitment

Staffing agencies looking for certified technicians and master tradespeople can map local sub-contractors and independent repair shops across specific counties, discovering small business owners and crew leaders for specialized industrial roles.

5. Franchise site selection and feasibility studies

Commercial developers and franchise brands can determine market demand and existing provider density before choosing a retail or service location. Assessing the number of competing facilities within a 10-mile radius ensures strategic territorial planning.

---

Getting started

Quick UI walkthrough

1. Log in to your Apify Console and open Yellow Pages US Scraper.
2. In the Search Term field, enter the business type or category (e.g., Plumber, Accountant, Italian Restaurant).
3. In the Location or Locality field, enter the city and state (e.g., Phoenix, AZ) or a 5-digit ZIP code (e.g., 85001).
4. Set the Maximum Pages to determine how many pages of results to scrape (each page contains up to 30 listings).
5. Click Save & Run.
6. When the run finishes, click on the Dataset tab to inspect your records, or download them as CSV, Excel, or JSON.

---

Progressive configuration examples

Example 1: Simple category and metro search

The fastest way to gather initial leads for a local service:

{
  "search": "Electrician",
  "locality": "Denver, CO",
  "maxPages": 1
}

Example 2: Multi-page deep extraction for sales outreach

Extract up to 90 verified dental practices across a metropolitan center:

{
  "search": "Dentist",
  "locality": "Atlanta, GA",
  "maxPages": 3,
  "proxyConfiguration": {
    "useApifyProxy": true
  }
}

Example 3: Targeted ZIP code search

Pinpoint local businesses within a specific postal zone:

{
  "search": "Auto Repair",
  "locality": "75201",
  "maxPages": 2,
  "proxyConfiguration": {
    "useApifyProxy": true
  }
}

---

Input parameters reference

Parameter	Type	Default	Required	Description
search	String	"Restaurant"	Yes	Business keyword, profession, or commercial category (e.g., "Plumbing", "Veterinarian", "Lawyer").
locality	String	"Los Angeles, CA"	Yes	Geographic location to query. Accepts "City, State" format, county, or a 5-digit US ZIP code.
maxPages	Integer	1	No	Maximum number of search result pages to process. Each standard page yields up to 30 listings.
proxyConfiguration	Object	{"useApifyProxy": true}	No	Proxy settings. Apify Proxy with residential proxies is recommended for reliable and uninterrupted execution.

---

Output reference & sample record

Extracted data is stored in the Actor's default dataset. Each listing is delivered as a flat, fully typed JSON record:

{
  "rank": 1,
  "businessName": "Beacon Plumbing & Heating",
  "detailLink": "https://www.yellowpages.com/seattle-wa/mip/beacon-plumbing-heating-461829314",
  "category": "Plumbers, Heating Contractors & Specialties, Water Heater Repair",
  "phone": "(206) 452-3130",
  "website": "https://www.beaconplumbing.net",
  "address": "8655 S 208th St, Seattle, WA 98198",
  "locality": "Seattle, WA 98198",
  "logoURL": "https://i1.ypcdn.com/blob/f955b567092e7fbf97cd244c47941037f13d042e_130x130_crop.jpg",
  "rating": 4.7,
  "reviews": 342,
  "yearsInBusiness": "24 Years",
  "priceRange": "$$",
  "openStatus": "OPEN NOW",
  "snippetReview": "Prompt emergency service on a Sunday morning. Fixed our broken water line quickly and professionally.",
  "time": 1788384746119
}

---

Tips for best results

• Use "City, State" or 5-digit ZIP codes — Specifying "Austin, TX" or "78701" produces significantly more precise matches than city names alone, which might match multiple states.
• Refine keywords for niche trades — Use specific category keywords like "Commercial Roofing" or "Emergency Plumber" rather than generic terms like "Contractor" to extract higher-intent leads.
• Scale with multi-run batches — When collecting thousands of records across a large state, run separate Actor tasks per major city or ZIP code. This parallelizes collection and avoids hitting Yellow Pages search pagination ceilings.
• Inspect yearsInBusiness for lead scoring — Established businesses operating for 10+ years often have distinct operational needs and budgets compared to newly registered businesses.
• Audit missing websites — Listings with a null website URL represent prime candidates for web development and local search marketing services.

---

Practical workflows

Workflow 1: Building an automated B2B sales engine

1. Define target market: Choose your industry category (e.g. HVAC Contractors) and target metropolitan areas.
2. Execute scrape: Run Yellow Pages US Scraper across the target localities.
3. Export & cleanse: Download the dataset as CSV and filter for records containing both phone and physical address.
4. CRM ingestion: Upload records into Salesforce, HubSpot, or Pipedrive.
5. Outbound sequence: Trigger automated cold-call queues or direct-mail postcards to verified business addresses.

Workflow 2: Identifying high-intent agency prospects

1. Target local services: Scrape categories that depend heavily on customer foot traffic and phone calls (e.g., Roofing, Chiropractors, Landscaping).
2. Filter opportunities: In Excel or Google Sheets, identify listings where:
   • website is empty or incomplete;
   • reviews is low (less than 15 reviews);
   • rating is below 4.0.
3. Pitch solution: Contact business owners directly via phone with a tailored proposal demonstrating competitor rankings and actionable reputation management steps.

Workflow 3: Regional market saturation analysis

1. Collect market data: Run queries across multiple neighboring ZIP codes for a specific franchise concept (e.g., Fitness Centers).
2. Aggregate in Google Sheets / BigQuery: Combine runs and analyze total provider counts, price distributions, and customer rating benchmarks.
3. Select territory: Choose postal codes with lower competitor density and high customer review demand for new facility openings.

---

API and automation

Integrate Yellow Pages US Scraper directly into your applications, pipelines, and AI agents using Apify's official client libraries.

Node.js / JavaScript

import { ApifyClient } from 'apify-client';

const client = new ApifyClient({
    token: 'YOUR_APIFY_TOKEN',
});

const input = {
    search: 'Roofing Contractors',
    locality: 'Phoenix, AZ',
    maxPages: 2,
};

// Start the Actor and wait for completion
const run = await client.actor('karamelo/yellow-pages-us-scraper').call(input);

// Fetch items from the default dataset
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(`Successfully collected ${items.length} business records.`);
items.slice(0, 5).forEach((item) => {
    console.log(`${item.businessName} | ${item.phone} | ${item.website}`);
});

Python

from apify_client import ApifyClient

client = ApifyClient('YOUR_APIFY_TOKEN')

run_input = {
    'search': 'Roofing Contractors',
    'locality': 'Phoenix, AZ',
    'maxPages': 2,
}

run = client.actor('karamelo/yellow-pages-us-scraper').call(run_input=run_input)

print(f"Results dataset: https://console.apify.com/storage/datasets/{run['defaultDatasetId']}")
for item in client.dataset(run['defaultDatasetId']).iterate_items():
    print(f"{item['businessName']} - {item['phone']} - {item['locality']}")

cURL

curl --request POST "https://api.apify.com/v2/acts/karamelo~yellow-pages-us-scraper/runs?token=YOUR_APIFY_TOKEN" \
  --header "Content-Type: application/json" \
  --data '{
    "search": "Electricians",
    "locality": "San Diego, CA",
    "maxPages": 1
  }'

AI Agents & MCP integration

Yellow Pages US Scraper can be called autonomously by AI assistants and agentic frameworks via the Apify Model Context Protocol (MCP) server.

Add the Apify MCP server to your MCP client configuration:

{
  "mcpServers": {
    "apify": {
      "type": "http",
      "url": "https://mcp.apify.com/?tools=karamelo/yellow-pages-us-scraper"
    }
  }
}

---

Integrations

Connect Yellow Pages US extraction pipelines directly to external applications and business workflows:

• Google Sheets & Microsoft Excel — Automatically append newly scraped leads to shared spreadsheets.
• Make, Zapier & n8n — Trigger downstream automations when new records are pushed to your Apify dataset.
• CRM Systems (HubSpot, Salesforce, Pipedrive) — Ingest clean business names, phone numbers, and addresses straight into lead queues via webhooks.
• Cloud Warehouses (BigQuery, Snowflake, PostgreSQL) — Schedule recurring extractions to monitor directory changes and market growth over time.
• Webhooks — Receive instant HTTP POST notifications with run details upon completion.

---

Limitations and good-to-know details

• Directory Search Ceiling: Yellow Pages typically limits organic pagination to a maximum number of pages per individual search term and location. For extensive nationwide or statewide coverage, split queries across distinct cities or 5-digit ZIP codes.
• Field Completeness: Some businesses do not provide optional details such as official websites, operational hours, or price tiers to the directory. When a field is unavailable, the Actor returns null.
• Geographic Scope: This Actor is designed specifically for US directory searches on Yellow Pages (yellowpages.com). Queries should target locations within the 50 US states and US territories.

---

Troubleshooting

Symptom	Likely cause	Recommended solution
0 listings found	Unrecognized locality or overly specific keyword.	Check spelling and use standard "City, ST" format (e.g. Miami, FL) or a valid 5-digit ZIP code (e.g. 33101).
Run finishes before maxPages	Reached the final page of available listings.	Yellow Pages has exhausted all listings matching the query. The Actor automatically stops when no additional pages exist.
Website field is null for some records	The merchant has not listed an external website.	This is common among small local contractors. Utilize phone and physical address for direct contact.
Access or connection failure	Public network restrictions or temporary rate limits.	Ensure proxyConfiguration is active with Apify residential proxies enabled in your input settings.

---

Frequently asked questions

How many listings does each page contain?

Each standard Yellow Pages US search results page contains up to 30 organic business listings. Setting maxPages: 3 will yield up to approximately 90 business records.

Can I search using US ZIP codes?

Yes. You can input either "City, ST" (e.g., "Atlanta, GA") or any valid 5-digit US ZIP code (e.g., "30301") into the locality parameter.

Does the scraper produce duplicate records?

No. Yellow Pages US Scraper includes automatic in-memory deduplication based on business name, telephone number, and address to ensure each business row in your dataset is unique.

How fresh is the extracted data?

All listings and indicators are extracted in real time directly from the live Yellow Pages directory at the moment the Actor runs.

Can I schedule recurring lead extractions?

Yes. You can set up scheduled runs in the Apify Console under the Schedules tab to automatically refresh leads daily, weekly, or monthly.

What export formats are supported?

You can download your data at any time from the Apify Console in CSV, JSON, JSONL, Excel (XLSX), XML, or HTML format.

---

Responsible and legal use

Yellow Pages US Scraper is intended for collecting publicly available commercial business listings for legitimate research, market intelligence, directory enrichment, and B2B communication. When utilizing contact details for outbound sales or direct marketing, users are responsible for complying with all applicable local, national, and international laws, including the CAN-SPAM Act, the Telephone Consumer Protection Act (TCPA), GDPR, and relevant do-not-call registries. Users must ensure that their collection and downstream data processing adhere to all applicable regulations.