OpenTable Review Scraper
Under maintenancePricing
from $7.00 / 1,000 actor starts
Go to Apify Store
OpenTable Review Scraper
Under maintenanceExtract 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
Maintained by CommunityActor stats
3
Bookmarked
79
Total users
1
Monthly active users
13 days ago
Last modified
Categories
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
| Field | Type | Default | Description |
|---|---|---|---|
startUrls | array | [] | OpenTable restaurant URLs (supports /r/slug and /restaurant/profile/ID formats) |
maxReviewPages | integer | 0 | Max pages per restaurant (0 = auto-detect from review count) |
maxResultsPerCrawl | integer | 0 | Max total reviews to save (0 = unlimited) |
startDate | string | "" | Filter reviews from this date (YYYY-MM-DD) |
endDate | string | "" | Filter reviews up to this date (YYYY-MM-DD) |
scrapflyKey | string | β | Optional legacy fallback β only if you want an extra retry path through Scrapfly |
renderFirstPageWithJS | boolean | false | Optional 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/slugURLs β the format you get when copying a restaurant's URL from OpenTable /restaurant/profile/ID/reviewsURLs 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/reviewsnow resolves to the canonical/r/slugpage (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=falsefor 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