How to export Yellow Pages business leads to CSV or Google Sheets (no code, API, n8n)

Description and use

The author built an Apify actor that exports Yellow Pages listings to a CSV ready for CRM import, offering three methods: manual form export, synchronous HTTP call, and automated weekly feeds into Google Sheets or a CRM.

Problem

YellowPages.com lacks an export button or public API, making it hard to obtain clean business lead data for spreadsheets or CRMs.

Outcome

The actor delivers 256 clean rows in a 24‑Sep‑2026 run, costing ~$0.38 at $1.50 per 1,000 businesses, with free plan credits covering several thousand leads.

Workflow

• 1. Open the Apify actor page and click "Try for free".
• 2. Enter search terms (e.g., plumber, hvac contractor) one per line.
• 3. Enter locations (City, ST or ZIP) one per line.
• 4. Set max results per term/location (e.g., 100).
• 5. Optionally tick "Include details" for emails, using residential proxy.
• 6. Click "Start" and download the CSV or Excel from the Output tab.
• 7. (Optional) Use the sync HTTP endpoint to fetch CSV directly via curl or Apify SDK.
• 8. (Optional) Schedule weekly runs via n8n, Make, or Zapier to append data to Google Sheets or a CRM.

Evidence

YellowPages.com has no export button and no public API, copy‑paste breaks the address into one messy cell, and the site sits behind Cloudflare, which stops most quick scripts after a page or two.

Source

One row per business, with the columns a CRM import wants already split: ... 256 of 256

Source

$1.50 per 1,000 businesses, pay per result; failed pages are never charged. The 256-row run above comes to about $0.38 at that price.

Source