GelbeSeiten Lead Extractor

Extract business leads from GelbeSeiten, Germany's largest online business directory. Search by keyword and city to collect names, phone numbers, addresses, websites, ratings, reviews, and opening hours, all in a clean structured dataset ready for CRM import, outreach, or market research.

Supports multiple keywords and multiple cities in a single run. The result limit applies per keyword and city pair, so you can scrape dozens of combinations at once.

---

What data you get

Each business listing returns the following fields:

Field	Description
name	Business name
category	Industry category (e.g. Cafe-Restaurants, Arztpraxen, Rechtsanwaelte)
street	Street name and number
postalCode	German 5-digit postal code
city	City name
address	Full formatted address
phone	Primary phone number
website	Business website URL
rating	Average star rating out of 5.0
reviewCount	Total number of customer reviews
businessDescription	Short description or tagline from the listing
openingHours	Current open/closed status and closing time
profileUrl	Direct link to the GelbeSeiten business profile
sourceUrl	Search results page the listing was found on
keyword	Search keyword used
searchLocation	Location searched

---

How to use

Basic input

{
  "keywords": ["cafe"],
  "locations": ["berlin"],
  "maxItems": 50
}

Multi-city, multi-keyword run

{
  "keywords": ["arzt", "zahnarzt"],
  "locations": ["berlin", "münchen", "hamburg"],
  "maxItems": 100
}

This runs 6 searches (2 keywords × 3 cities) and returns up to 600 results total.

---

Input parameters

Parameter	Required	Default	Description
keywords	Yes	—	One or more German search terms. Each keyword is searched in every location.
locations	Yes	—	One or more German cities or regions. Each location is paired with every keyword.
maxItems	No	50	Maximum listings per keyword and location pair. Pagination runs automatically until this limit is reached.
requestTimeoutSecs	No	30	Seconds to wait for each page request before timing out.

How maxItems works

The limit is per search pair, not across the entire run.

Keywords	Locations	maxItems	Max total results
1	1	100	100
2	3	50	300
5	10	200	10,000

---

Sample output

{
  "name": "FreudenGrün",
  "category": "Cafés",
  "street": "Chausseestr. 9",
  "postalCode": "10115",
  "city": "Berlin",
  "address": "Chausseestr. 9, 10115 Berlin",
  "phone": "030 25 76 25 96",
  "website": "https://freudengrun.de/",
  "rating": 5.0,
  "reviewCount": 1,
  "businessDescription": null,
  "openingHours": "Geöffnet – Schließt um 18:00",
  "profileUrl": "https://www.gelbeseiten.de/gsbiz/45c22f1a-3b99-4c04-9f0e-534ca0cd64d8",
  "sourceUrl": "https://www.gelbeseiten.de/suche/cafe/berlin",
  "keyword": "cafe",
  "searchLocation": "berlin"
}

---

Use cases

• Sales prospecting — build targeted contact lists for any German city and industry
• Email outreach — collect phone numbers and websites for direct marketing campaigns
• Competitor research — find all businesses in a category across multiple cities
• Market analysis — compare business density, ratings, and coverage by region
• Local SEO audits — gather category, address, and rating data for analysis
• CRM enrichment — bulk-import German business contacts into your CRM

---

Common search keywords

GelbeSeiten is a German directory so keywords should be in German.

English	German keyword
Doctor	arzt
Dentist	zahnarzt
Lawyer	rechtsanwalt
Notary	notar
Tax advisor	steuerberater
Architect	architekt
Restaurant	restaurant
Cafe	cafe
Hotel	hotel
Bakery	baeckerei
Supermarket	supermarkt
Pharmacy	apotheke
Gym	fitnessstudio
Hairdresser	friseur
Electrician	elektriker
Plumber	klempner
Painter	maler
Car dealer	autohaendler
Insurance	versicherung
Real estate	immobilien
Bank	bank
Cleaning service	reinigungsservice
Driving school	fahrschule
Kindergarten	kindergarten
Physiotherapy	physiotherapie

---

Common locations

Any German city, district, postal code, or region is accepted.

Major cities: berlin, münchen, hamburg, frankfurt, köln, stuttgart, düsseldorf, dortmund, essen, leipzig, bremen, dresden, hannover, nürnberg, duisburg, bochum, wuppertal, bielefeld, bonn, münster, mannheim, karlsruhe, augsburg, wiesbaden, gelsenkirchen, mönchengladbach, braunschweig, kiel, chemnitz, aachen

By state: bayern, nordrhein-westfalen, baden-württemberg, niedersachsen, hessen, sachsen, berlin, rheinland-pfalz, schleswig-holstein, thüringen

---

Output formats

Results are stored in the Apify dataset and can be exported as:

• JSON — for API integrations and pipelines
• CSV — for Excel and Google Sheets
• Excel (XLSX) — ready-to-open spreadsheet
• XML — for legacy system imports
• RSS — for feed-based workflows

Use the Export button in the Apify console or download via the Apify API.

---

Tips and notes

• GelbeSeiten returns up to 50 listings per page. Pagination is automatic.
• Fields with no data on the listing page return null.
• Ratings are shown in German format (comma decimal) and are automatically converted to standard decimal numbers.
• For bulk city coverage, list all cities in locations instead of running the actor separately per city.
• Keywords are case-insensitive. Arzt and arzt return the same results.
• If a city has fewer results than maxItems, the actor stops when results run out and moves to the next pair.

---