📒 Sección Amarilla Scraper - Mexico Business Leads & Emails

Extract business leads from Sección Amarilla, the yellow pages of Mexico. Search any category or business name in any state, city, neighborhood (colonia) or postal code, and get each business's phone and WhatsApp in international format, email, website, street address with neighborhood and postal code, GPS position and listing type. Turn on Business details to also get the photo, description, opening hours, services, payment methods, every phone and WhatsApp number, and Facebook, Instagram, LinkedIn, YouTube, X and TikTok links. Several searches and places in one run, 1,000 businesses in about 25 seconds, no cut-off at the site's 7,980 results per search, and it can run on a schedule to send you only new businesses.

🎯 Who uses it?

📞 Sales teams and lead generation agencies

Build call, WhatsApp and email lists of Mexican businesses by category, city and neighborhood, ready for your CRM.

📣 Marketing agencies

Find businesses without a website or social media in a city, and offer them yours.

🏭 Distributors and suppliers

List every hardware store, pharmacy, restaurant or clinic in a state to plan sales routes and coverage, down to the postal code.

📊 Market researchers

Count and map businesses by category, state, city and postal code, with GPS positions.

✨ What it does

• Search like on the site. Type categories or business names ("abogados", "dentistas", "taller mecánico"). Several terms in one run.
• Any place in Mexico. A state ("Jalisco", "CDMX"), city ("Monterrey"), neighborhood ("Polanco") or postal code ("44100"). Every term is searched in every place. Leave it empty for all of Mexico.
• No 7,980 cut-off. The site stops at 399 pages per search. Bigger searches are split by state, and by city when needed, so you get everything.
• Or paste links. Results pages or business pages. Filters are ignored with links.
• Filters: only close matches, only with email, phone, WhatsApp, website or street address, only advertisers, postal codes, and open on chosen days.
• Business details add-on: photo, description, opening hours per day, services, payment methods, all phones and WhatsApp numbers, and social media links.
• Monitoring: run it on a schedule with Only new businesses and each run saves only businesses you haven't received yet.

🏆 Why this scraper

• Fast. 1,000 businesses in about 25 seconds. Business details for 300 advertisers in about 40 seconds.
• Every result. Searches with more than 7,980 businesses are split by state and city automatically, with duplicates removed.
• Only real matches. The site mixes in nearby towns and related categories. Only close matches keeps just the businesses that fit your search words and place.
• Phones ready to dial. Every phone and WhatsApp number in international format (+52...).
• Clean addresses. Street, neighborhood, city, state and postal code in separate fields. The state is taken from the postal code, because the site writes Mexico City as DF, CDMX or MEX. Placeholder places the site uses for free listings are left empty.
• Clean, typed data. Map positions as numbers, yes/no fields as true/false, days in English, no HTML leftovers.
• No proxy needed. Nothing extra to set up or pay for.

⚖️ How it compares

Based on each Actor's public input options and output fields (October 2026).

Capability	This actor	happitap
Search by term and place (no links needed)	yes	no
States, cities, neighborhoods and postal codes	yes	no
Several search terms and places in one run	yes	no
Searches over 7,980 results split automatically	yes	no
Results page links	yes	yes
Business page links	yes	no
Email, phone, WhatsApp, website and address filters	yes	no
Postal code filter	yes	no
Only close matches	yes	no
Opening hours, services, payment methods, social links	yes	no
Open on chosen days filter	yes	no
Only new businesses (monitoring)	yes	no
Fields per business	33	7
Proxy needed	no

📦 What data you get

Field	Description
imageUrl	(Business details) Main photo of the business.
name	Business name.
category	Category the business is listed under.
searchTerm, searchLocation	Which of your search terms and places found it.
phone	Main phone in international format (+52...).
whatsapp	WhatsApp number in international format.
email	Email address.
address	Street and number.
neighborhood	Neighborhood (colonia).
city	City or municipality.
state	State, taken from the postal code when there is one.
postalCode	Postal code (código postal).
latitude, longitude	Map position.
listingId	The site's listing ID.
description	(Business details) What the business says about itself.
isAdvertiser	True for paid listings with their own business page.
url	The business page on Sección Amarilla (advertisers only).
website	Business website.
googleMapsUrl	Google Maps link to the business position (or its address when there is no position).
facebook, instagram, linkedin, youtube, twitter, tiktok	(Business details) Social media pages: Facebook, Instagram, LinkedIn, YouTube, X (Twitter) and TikTok.
phones	(Business details) Every phone number listed (landlines and mobiles).
whatsapps	(Business details) Every WhatsApp number listed.
paymentMethods	(Business details) Payment methods accepted (cash, cards, transfer...).
services	(Business details) Products and services the business lists.
openingHours	(Business details) Opening hours: day, opening time and closing time.
scrapedAt	When this row was saved.
error	Only present when a row failed. The fields that loaded are still there.

Fields marked Business details only appear when that add-on is on.

Example row (trimmed)

{
  "imageUrl": "https://graficos.seccionamarilla.com.mx/PRODUCTS/03/413131003/1/CONTENTS/15/45519015/1/10951286/06_412939292-18_f.jpg",
  "name": "LA COCINA DE SAN JUAN",
  "category": "Restaurantes en General",
  "searchTerm": "restaurantes",
  "searchLocation": "CDMX",
  "phone": "+525522486633",
  "whatsapp": "+525522486633",
  "email": "lacocinadesanjuan@gmail.com",
  "address": "2DA CALLE DE ERNESTO PUGIBET 21 LOC 342",
  "neighborhood": "Centro (Area 7)",
  "city": "Cuauhtemoc",
  "state": "Ciudad de México",
  "postalCode": "06000",
  "latitude": 19.42986,
  "longitude": -99.14513,
  "listingId": "413131003",
  "description": "SABADO Y DOMINGO CON RESERVACIÓN VÍA WHATSAPP",
  "isAdvertiser": true,
  "url": "https://www.seccionamarilla.com.mx/informacion/la-cocina-de-san-juan/restaurantes/distrito-federal/cuauhtemoc/centro-area-7/413131003",
  "website": "http://cocinadesanjuan.com.mx",
  "googleMapsUrl": "https://www.google.com/maps/search/?api=1&query=19.42986,-99.14513",
  "facebook": "https://www.facebook.com/lacocinadesanjuan",
  "phones": ["+525522486633"],
  "whatsapps": ["+525522486633"],
  "paymentMethods": ["American Express", "Mastercard", "Visa"],
  "services": ["SERVICIO A DOMICILIO", "COCODRILO A LA VERACRUZANA", "PATO A LA MANZANA"],
  "openingHours": [{ "day": "Monday", "opens": "11:00", "closes": "20:00" }],
  "scrapedAt": "2026-10-17T14:37:39.487Z"
}

💡 Use cases

⚖️ Law firms with email in Guadalajara

{ "searchTerms": ["abogados"], "locations": ["Guadalajara"], "onlyCloseMatches": true, "onlyWithEmail": true }

🦷 Dentists in Polanco and Condesa with email

{ "searchTerms": ["dentistas"], "locations": ["Polanco", "Condesa"], "onlyWithEmail": true }

🔧 Every hardware store in Nuevo León

{ "searchTerms": ["ferreterias"], "locations": ["Nuevo León"] }

📮 Restaurants in exact postal codes of Mexico City

{ "searchTerms": ["restaurantes"], "locations": ["06700", "11560"], "postalCodes": ["06700", "11560"] }

🕐 Veterinarians open on Sundays, with hours and services

{ "searchTerms": ["veterinarias"], "locations": ["Monterrey"], "openOn": ["Sunday"] }

🔔 New notaries in Puebla, every week (schedule it)

{ "searchTerms": ["notarias"], "locations": ["Puebla"], "onlyNew": true, "monitorName": "notarias-puebla" }

🔗 Pages you already found on the site

{ "startUrls": [{ "url": "https://www.seccionamarilla.com.mx/resultados/abogados/jalisco/guadalajara/1" }] }

⚙️ How the input is organised

Section	What it's for
Maximum results	Always first, caps the whole run. Empty means no limit.
What to scrape	Search terms, places and business details (hours, services, social links).
Filters	Only close matches, only with email, only with phone, only with WhatsApp, only with website, only with street address, only advertisers, postal codes and open on these days.
Monitoring	Only new businesses and monitor name.
Links	Links instead of the fields above. Filters are ignored with links.

💰 Pricing

Pay-per-event: a one-time $0.003 when the run starts, plus a price per business saved to your dataset. The price depends on your Apify plan tier:

Your Apify plan	Price per business
Free	$0.013
Bronze	$0.012
Silver	$0.011
Gold / Platinum / Diamond	$0.010

Approximate total cost:

Businesses collected	Free	Bronze	Silver	Gold+
100	$1.30	$1.20	$1.10	$1.00
1,000	$13.00	$12.00	$11.00	$10.00
10,000	$130.00	$120.00	$110.00	$100.00

Business details add-on: when Business details is on (or the opening-day filter turns it on), each advertiser saved with its details adds one more charge:

Your Apify plan	Business details, per business
Free	$0.004
Bronze	$0.0035
Silver	$0.003
Gold / Platinum / Diamond	$0.0025

So 1,000 advertisers with details cost $12.50 on Gold ($10 + $2.50). Free listings have no business page, so they pay only the base price, and so do businesses whose details didn't load. Businesses left out by filters are free. No proxy costs. New Apify accounts start with $5 in free credit. On the Free plan a run saves up to 10 businesses.

🚀 Run it

1. Create a free Apify account with $5 in credit.
2. Open the Sección Amarilla Scraper.
3. Type search terms and places (or keep the prefilled ones), add filters, then click Start.
4. Export the results as CSV, Excel, JSON or XML from the Dataset tab.

🤖 Use with AI agents (MCP)

Connect the Apify MCP server to Claude, ChatGPT, Cursor or any MCP client and ask in plain words, for example: "Find 200 law firms in Monterrey with email on Sección Amarilla". The agent runs this Actor and reads the results.

🔧 Troubleshooting

• Few or no results. Sección Amarilla searches in Spanish: try "abogados" instead of "lawyers", or the plural and singular ("farmacia", "farmacias").
• A place was skipped. The log says when the site doesn't know a place. Try the state, the city or a postal code instead.
• Businesses from nearby towns or other categories. The site mixes them in. Turn on Only close matches.
• Many empty emails or websites. Free listings carry only a name, phone and address. Use Only advertisers, Only with email or Only with website.
• Opening hours are empty. Only advertisers have a business page, and not all of them publish hours.

❓ FAQ

Is there a limit per search? The site shows at most 7,980 businesses per search. Bigger searches are split by state and city, so there is no limit in practice.

Can I search by postal code? Yes, type it as a place ("44100"), or use the Postal codes filter to keep only some codes or code prefixes ("441").

Do I need a proxy? No.

🛡️ Limits & responsible use

This Actor collects business information that the businesses publish on Sección Amarilla. Use it in line with the site's terms and with Mexico's data protection law (LFPDPPP) and anti-spam rules, especially for email and WhatsApp outreach.

📧 Contact

Questions, bugs or a field you need: norm.data.scrapers@gmail.com

🧪 Local development

bun install
bun scripts/fetch-places.mjs
bun scripts/gen-schemas.mjs
sh test/run.sh first '{"maxItems":10,"searchTerms":["abogados"],"locations":["Guadalajara"]}'