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

说明与用途

作者创建了一个 Apify 角色，将 Yellow Pages 列表导出为适合 CRM 导入的 CSV，并提供三种方法：手动表单导出、同步 HTTP 调用以及自动化的每周 Google 表格或 CRM 流程。

问题

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

结果

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.

工作流

• 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.

证据

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.

来源

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

来源

$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.

来源