OpenTable Review Scraper avatar

OpenTable Review Scraper

Under maintenance

Pricing

from $7.00 / 1,000 actor starts

Go to Apify Store
OpenTable Review Scraper

OpenTable Review Scraper

Under maintenance

Extract customer reviews from OpenTable for sentiment analysis, CX insights, or competitive tracking. Supports date filtering, pagination, and structured output.

Pricing

from $7.00 / 1,000 actor starts

Rating

5.0

(1)

Developer

Vertivine

Vertivine

Maintained by Community

Actor stats

3

Bookmarked

79

Total users

1

Monthly active users

13 days ago

Last modified

Features

Limited permissions

Share

Extract customer reviews from OpenTable restaurant listings for sentiment analysis, CX insights, or competitive tracking.

No third-party API keys required β€” runs entirely on Apify using the built-in UNBLOCKER proxy. Just add restaurant URLs and run.


πŸ” Features

  • Zero setup β€” no Scrapfly key or any external service needed
  • Full review extraction β€” scrapes all reviews, no 500-review cap
  • JSON-LD primary parser β€” uses Schema.org structured data for reliable extraction
  • Category ratings on every page β€” Food, Service, Atmosphere sub-ratings plus visit dates ("Dined 3 days ago" β†’ resolved date)
  • Auto-pagination β€” detects total review count and scrapes all pages automatically
  • Duplicate detection β€” stops when pagination wraps around
  • Restaurant metadata β€” captures restaurant name, ID, and aggregate rating
  • Date filtering β€” optional startDate/endDate to filter by review date
  • Cost-efficient β€” plain static HTTP fetches; no browser rendering required

βœ… Input

{
"startUrls": [
{ "url": "https://www.opentable.com/r/restaurant-name" },
{ "url": "https://www.opentable.com/restaurant/profile/1078306/reviews" }
],
"maxReviewPages": 0,
"maxResultsPerCrawl": 0,
"startDate": "",
"endDate": ""
}

Input Fields

FieldTypeDefaultDescription
startUrlsarray[]OpenTable restaurant URLs (supports /r/slug and /restaurant/profile/ID formats)
maxReviewPagesinteger0Max pages per restaurant (0 = auto-detect from review count)
maxResultsPerCrawlinteger0Max total reviews to save (0 = unlimited)
startDatestring""Filter reviews from this date (YYYY-MM-DD)
endDatestring""Filter reviews up to this date (YYYY-MM-DD)
scrapflyKeystringβ€”Optional legacy fallback β€” only if you want an extra retry path through Scrapfly
renderFirstPageWithJSbooleanfalseOptional legacy fallback β€” retry page 1 with Scrapfly JS rendering if static fetch yields nothing

πŸ“„ Output Format

{
"reviewer": "Jane",
"date": "2025-04-15",
"visitDate": "2025-04-10",
"rating": 5,
"review": "Exceptional service and perfectly cooked steak!",
"source": "OpenTable",
"detailedRatings": {
"Food": 5,
"Service": 5,
"Atmosphere": 4
},
"restaurantName": "Bar Rocco",
"restaurantId": "1078306"
}

πŸ’‘ Use Cases

  • Weekly or monthly review reports (DinerVibe)
  • Automated sentiment analysis pipelines
  • Reputation monitoring across restaurant groups
  • Customer experience benchmarking

πŸ›  Technical Notes

  • Fetches through Apify's built-in UNBLOCKER proxy β€” handles OpenTable's anti-bot wall with plain static HTTP
  • JSON-LD extraction from Schema.org structured data (primary parser)
  • HTML enrichment for category ratings (Food, Service, Atmosphere) and visit dates β€” parsed from static pages on every page
  • Scrapes the canonical /r/slug URLs β€” the format you get when copying a restaurant's URL from OpenTable
  • /restaurant/profile/ID/reviews URLs are auto-converted to the canonical slug before scraping
  • Duplicate detection prevents infinite loops when OpenTable wraps pagination
  • Hard safety cap at 500 pages (5,000 reviews) per restaurant

πŸ”„ Changelog

v3.0 (2026-11)

  • Dropped the Scrapfly dependency β€” primary fetch now goes through Apify UNBLOCKER proxy (static HTTP)
  • No API keys required β€” one-click install and run
  • Category ratings + visit dates on every page β€” previously only page 1 with expensive JS rendering
  • Fixed profile-URL handling β€” /restaurant/profile/ID/reviews now resolves to the canonical /r/slug page (profile pages serve no review data)
  • Scrapfly retained as an optional fallback path

v2.0 (2026-06)

  • JSON-LD primary parser β€” more reliable than HTML scraping
  • Removed 500-review cap β€” auto-detects total review count and scrapes all pages
  • Duplicate detection β€” stops on pagination wraparound
  • Category ratings β€” Food, Service, Atmosphere from rendered HTML on page 1
  • Restaurant metadata β€” name, ID, aggregate rating
  • Cost optimization β€” render_js=false for pagination pages
  • Simplified input β€” removed legacy Apify Web Scraper fields

v1.0 (2025-05)

  • Initial release based on Apify Web Scraper template
  • Scrapfly integration for anti-bot bypass
  • Cheerio HTML parsing