Gelbe Seiten Scraper

Extract every German business listing from Gelbe Seiten — Germany's national Yellow Pages — at scale. Pull names, full postal addresses, phone numbers, emails, websites, GPS coordinates, opening hours, services, photos, social links, ratings, and complete review feeds for any what-and-where search across all 16 federal states. Built for B2B sales teams, recruiters, and CRM enrichment pipelines that need verified German SMB contact data without stitching together regional directories themselves.

Why This Scraper?

• Two-tier pricing — pay only for what you collect. $1.20 per 1,000 businesses + $0.30 per 1,000 reviews. Toggle reviews off and review charges disappear entirely.
• Verified contact stack on every row — phone, email, website, street address, postal code, city, district, and GPS latitude/longitude pulled from each business's detail page.
• Full review history per business — review text, 0–5 rating, author, date, helpful count, and original review-source attribution preserved (golocal partner network and others). Up to 5,000 reviews per business.
• Three input modes in one run — keyword + location ("Restaurant" + "Berlin"), direct search URLs (/suche/restaurant/10115), or specific business URLs (/gsbiz/<ID>). Mix and match freely.
• All 16 German federal states + every Postleitzahl — Berlin, München, Hamburg, Köln, Frankfurt, Stuttgart, and every 5-digit postal code in between. Search by city or PLZ.
• Two sort modes — relevance (Gelbe Seiten default) or bewertung (highest-rated first), so you can surface top-rated providers before paginating deep.
• Lead-only mode for cheap directory pulls — disable detail enrichment to pay only the business rate ($1.20 / 1,000) and skip the review event entirely. Ideal for fast prospect-list builds.
• Fresh-review guarantee — review records are only emitted when Gelbe Seiten's live review module confirms the listing is active. Stale federation reviews on inactive listings are dropped automatically; you never pay for ghost data.
• Stable, schema-aware extraction — every business is keyed by Gelbe Seiten's canonical UUID (gelbeseitenId) so you can dedupe across runs even when names or branding change.

Use Cases

Lead Generation & B2B Sales

• Build prospect lists of every Steuerberater, Klempner, or Friseur in a target city
• Pull verified phone + email + website for every SMB in a Postleitzahl-bound territory
• Layer queries (e.g. "Restaurant" in 25 cities) into one run for nation-wide outreach lists

Market Research & Competitive Intelligence

• Map competitor density by federal state, city, or district (Bezirk)
• Compare review volume and average ratings across regional sub-markets
• Snapshot a category monthly to track new entrants and closures

CRM Enrichment & Data Cleansing

• Match existing German account rows against Gelbe Seiten by name + city to backfill phone, email, website, and GPS
• Pull services and categories arrays to enrich industry tagging
• Refresh stale contact details for an existing book of business

Recruiting & Talent Sourcing

• Source German SMB hiring managers from Gelbe Seiten's category browser
• Pair with social-link extraction to surface LinkedIn, Facebook, and Instagram presence per company

Local-SEO Audits & Listings Management

• Audit a client's Gelbe Seiten profile against competitors in the same district
• Pull every review on a competitor's listing — full text, dates, owner replies — for sentiment and recurring-complaint analysis
• Validate citation consistency (NAP) across regional rivals

Data Journalism & Academic Research

• Build longitudinal datasets of German local-business density
• Aggregate ratings and review counts by region for economic analysis
• Power studies on regional service availability (healthcare, legal, automotive)

Getting Started

Simple — Keyword + City

The fastest path: enter what you want and where in Germany.

{
    "searchQueries": ["Restaurant"],
    "location": "Berlin",
    "maxResults": 50
}

Highest-Rated First

Sort by rating to surface the top providers before deep pagination kicks in.

{
    "searchQueries": ["Klempner"],
    "location": "München",
    "sort": "bewertung",
    "maxResults": 100
}

Direct URL — Postal-Code Targeting

Paste a Gelbe Seiten URL and the actor honors every filter in it (sort, radius, postcode).

{
    "searchUrls": [
        "https://www.gelbeseiten.de/suche/restaurant/10115",
        "https://www.gelbeseiten.de/branchen/restaurant/berlin"
    ],
    "maxResults": 200
}

Lead-Only Power Run

Disable review enrichment for the cheapest, fastest possible run — names, addresses, phones, ratings, and primary categories only. Pay $1.20 per 1,000 businesses, no review charges at all.

{
    "searchQueries": ["Steuerberater", "Rechtsanwalt", "Notar"],
    "location": "Hamburg",
    "includeReviews": false,
    "maxResults": 1000
}

Mixed Run — Queries + URLs + Cap

Combine multiple search terms, a direct business URL, and a high review cap.

{
    "searchQueries": ["Friseur"],
    "location": "Köln",
    "searchUrls": [
        "https://www.gelbeseiten.de/gsbiz/00000000-0000-0000-0000-000000000000"
    ],
    "includeReviews": true,
    "maxReviewsPerBusiness": 100,
    "maxResults": 500
}

Input Reference

Search Inputs

Parameter	Type	Default	Description
searchQueries	string[]	["Restaurant"]	What to search for on Gelbe Seiten (e.g. Restaurant, Klempner, Steuerberater, Friseur). One row per term.
location	string	"Berlin"	Where to search in Germany. City name (e.g. Berlin, München, Hamburg) or 5-digit postal code (e.g. 10115). Leave empty if your queries already include a location, or if you're using direct URLs.
searchUrls	string[]	[]	Paste Gelbe Seiten URLs directly: search results, category pages, or individual business pages. Filters in the URL (sort, radius, postcode) are honored as-is.

Filtering

Parameter	Type	Default	Description
sort	select	Relevance (default)	Order of results — Relevance (default) or Highest Rated First. Rating sort surfaces the top-rated providers from row 1.

Output Detail

Parameter	Type	Default	Description
includeReviews	boolean	true	Visit each business's detail page to collect reviews, photos, social links, full opening hours, and services. Disable for faster, cheaper runs that return only search-card data (name, address, phone, rating, primary category).
maxReviewsPerBusiness	integer	20	Cap on reviews captured per business (most recent first). Set to 0 to capture every available review. Ignored when Include Detailed Profile Data is off.

Limits

Parameter	Type	Default	Description
maxResults	integer	100	Hard cap on total business rows across all queries and URLs. Set to 0 for no cap. The run stops requesting new pages once this number is reached but keeps the full final page even if it slightly overshoots.

Output

Each result is one business row — a German listing with all profile fields and (when enabled) an embedded reviews[] array. Example:

{
    "name": "Bass Gastro UG",
    "url": "https://www.gelbeseiten.de/gsbiz/00000000-0000-0000-0000-000000000000",
    "gelbeseitenId": "00000000-0000-0000-0000-000000000000",
    "categories": ["Restaurants", "Italienisches Restaurant"],
    "description": "Familiengeführtes italienisches Restaurant im Herzen von Köpenick...",
    "phone": "+49 30 12345678",
    "email": "info@example.de",
    "website": "https://www.example.de",
    "street": "Beispielstraße 12",
    "postalCode": "12555",
    "city": "Berlin",
    "district": "Köpenick",
    "country": "DE",
    "latitude": 52.4561,
    "longitude": 13.5712,
    "rating": 5.0,
    "ratingCount": 2,
    "openingHours": [
        { "day": "Monday", "open": "11:30", "close": "22:00" },
        { "day": "Tuesday", "open": "11:30", "close": "22:00" }
    ],
    "services": ["Lieferung", "Außerhausverkauf"],
    "socialLinks": {
        "facebook": "https://www.facebook.com/bassgastro",
        "instagram": "https://www.instagram.com/bassgastro",
        "twitter": null,
        "linkedin": null,
        "youtube": null
    },
    "images": [
        "https://example-cdn.de/photo1.jpg",
        "https://example-cdn.de/photo2.jpg"
    ],
    "reviews": [
        {
            "author": "Paula Beck",
            "rating": 5.0,
            "date": "2023-01-20",
            "title": "Sehr empfehlenswert",
            "body": "Tolles Essen, freundlicher Service, schöne Atmosphäre.",
            "helpfulCount": 3,
            "ownerReply": null,
            "source": "golocal",
            "sourceUrl": "https://www.golocal.de/...",
            "reviewId": "12345678"
        }
    ],
    "searchQuery": "Restaurant",
    "searchLocation": "Berlin",
    "scrapedAt": "2026-05-08T14:30:00Z"
}

Core Identity

Field	Type	Description
name	string	Business name
url	string	Canonical Gelbe Seiten detail URL
gelbeseitenId	string	Internal Gelbe Seiten UUID — stable across runs, ideal for deduping
categories	string[]	All Gelbe Seiten categories for this business
description	string | null	Short business description / tagline

Contact

Field	Type	Description
phone	string | null	Primary phone number
email	string | null	Primary email address
website	string | null	Business website (Gelbe Seiten / partner / federation links filtered out)

Address & Geo

Field	Type	Description
street	string | null	Street and house number
postalCode	string | null	German postal code (PLZ)
city	string | null	City
district	string | null	District / borough — e.g. Mitte, Köpenick
country	string	Always "DE"
latitude	number | null	GPS latitude
longitude	number | null	GPS longitude

Ratings & Hours

Field	Type	Description
rating	number | null	Average star rating (0–5)
ratingCount	integer | null	Total number of ratings
openingHours	object[]	Per-weekday open / close pairs: {day, open, close} in English day names + 24-hour times
services	string[]	Services published on the detail page (e.g. ["Lieferung", "Außerhausverkauf"])

Media & Social

Field	Type	Description
socialLinks	object	{facebook, instagram, twitter, linkedin, youtube} — each is a URL or null
images	string[]	Photo URLs from the gallery + cover image

Run Metadata

Field	Type	Description
searchQuery	string | null	The search term that produced this row
searchLocation	string | null	The location used for that search
scrapedAt	string	ISO-8601 timestamp when the row was captured

Review Fields (when includeReviews=true)

Each entry inside the reviews[] array:

Field	Type	Description
author	string | null	Reviewer display name (or null for anonymous)
rating	number | null	Reviewer's star rating (0–5)
date	string | null	Review date in ISO format (YYYY-MM-DD)
title	string | null	Review title, when present
body	string | null	Full review text
helpfulCount	integer | null	Number of "helpful" upvotes
ownerReply	string | null	Business owner's reply, when posted
source	string | null	Original review source (golocal, partner network name, or gelbeseiten)
sourceUrl	string | null	Link to the original review on the source platform, when available
reviewId	string | null	Stable review identifier for downstream dedupe

Tips for Best Results

• Use specific German trade terms. Steuerberater, Heizungsbau, Fliesenleger, Optiker return tighter, more relevant pools than English equivalents. Gelbe Seiten is a German-language directory.
• Postal codes beat city names for precision. Searching 10115 returns Berlin-Mitte only; searching Berlin covers all 12 boroughs. PLZ is the cleanest territorial filter.
• Lead-only mode for prospect-list speed. Set includeReviews=false when you only need names, addresses, phones, and primary categories. The run skips per-business detail pages, finishes much faster, and pays only the business rate.
• Bulk vertical pulls via searchUrls. Paste category URLs like https://www.gelbeseiten.de/branchen/restaurant/berlin into searchUrls to bypass keyword tuning. The actor automatically rewrites /branchen/... to /suche/... so pagination unlocks the full result pool instead of capping at 10.
• Sort by rating for "best of" lists. When you only need the highest-rated providers in a category, sort by Highest Rated First and lower maxResults — you'll skip the long tail entirely.
• Cap reviews to control cost. Default maxReviewsPerBusiness=20 captures the most recent 20 reviews per listing. Set to 0 for the full history, or to a smaller number like 5 for sentiment-only sampling.
• Dedupe across runs by gelbeseitenId. The UUID is stable — overlapping runs or weekly refreshes can be merged on this field without name-matching drift.
• A small share of listings have inactive review feeds. Some Gelbe Seiten profiles display a public review count but the underlying review feed is no longer active — those businesses ship with reviews: [] and are not charged at the review rate. Your dataset stays clean and you only pay for reviews you actually receive.

Pricing

$1.20 per 1,000 businesses + $0.30 per 1,000 reviews — pay-per-event. No compute charges, no run-time surprises.

You're billed for two things only:

• Business row — $1.20 per 1,000 businesses returned ($0.0012 each).
• Review — $0.30 per 1,000 reviews captured ($0.00030 each), only when Include Detailed Profile Data is on. Turn it off and review charges disappear — you pay only for business rows.

Businesses	Lead-only (reviews off)	With ~10 reviews per business
100	$0.12	$0.42
1,000	$1.20	$4.20
10,000	$12.00	$42.00
100,000	$120.00	$420.00

If a run hits an error and returns zero rows, you pay nothing.

Integrations

Export your data in JSON, CSV, Excel, XML, or RSS. Connect to 1,500+ apps via:

• Apify API — Full programmatic access to runs, datasets, and schedules
• Webhooks — Trigger downstream workflows when a run completes
• Google Sheets — Direct spreadsheet export
• Zapier / Make / n8n — Automate workflows with 1,000+ app integrations
• Slack / Email — Notifications on new results
• Datasets — Download as JSON, CSV, XML, or Excel

Legal & Ethical Use

This actor extracts publicly visible business listings from Gelbe Seiten for legitimate B2B research, lead generation, market intelligence, and CRM enrichment. Only public business data is collected — no personal user information, no private accounts, no information behind authentication. Users are responsible for complying with applicable laws, Gelbe Seiten's Terms of Service, and German / EU data-protection regulations (GDPR, BDSG) in their jurisdiction. Do not use the extracted data for spam, harassment, or any illegal purpose. When publishing or redistributing review content, attribute Gelbe Seiten and the original review source.