OpenTable Reviews Scraper 🍽️

What does OpenTable Reviews Scraper do?

OpenTable Reviews Scraper collects restaurant reviews, ratings, and diner feedback from OpenTable. Provide one or more restaurant profile URLs or metro search pages, and the Actor returns structured data including review text, star ratings, food/service/ambience/value scores, reviewer details, and restaurant replies.

Why use OpenTable Reviews Scraper?

• Structured review datasets - Collect full review text, ratings, and reviewer context without manual copy-paste.
• Automation-ready output - Export results to JSON, CSV, Excel, XML, or connect to Google Sheets and other tools.
• Reputation monitoring - Track feedback for your own restaurants or competitors on a recurring schedule.
• Market intelligence - Analyze dining trends, popular cuisines, and rating patterns across metros and neighborhoods.

What data can you extract from OpenTable?

Field	Description
rating	Overall star rating (1-5)
text	Full review text
foodRating	Food quality score (1-5)
serviceRating	Service quality score (1-5)
ambienceRating	Atmosphere score (1-5)
valueRating	Price-to-value score (1-5)
noiseLevel	Noise description (e.g. LOUD, MODERATE)
restaurantName	Restaurant name
author	Reviewer nickname
date	Review submission date
visitDate	Date the reviewer dined
reviewerMetro	Reviewer metro area
reviewerIsVip	VIP status indicator
helpfulCount	Number of helpful votes
publicRestaurantReply	Public reply from the restaurant

How to use OpenTable Reviews Scraper

1. Open the Actor on Apify Store.
2. Add one or more OpenTable URLs (restaurant profile pages or metro/search pages).
3. Set the maximum number of reviews to collect.
4. Optionally configure proxy settings for larger runs.
5. Run the Actor.
6. Download the dataset or connect it to your workflow.

Input Parameters

Parameter	Type	Required	Default	Description
startUrls	Array	No	Bestia example URL	List of OpenTable URLs including restaurant profile pages or metro/search pages to collect reviews from.
results_wanted	Integer	No	20	Maximum number of reviews to collect in one run.
proxyConfiguration	Object	No	Apify Proxy (Residential)	Proxy settings. Residential proxies are recommended for large-scale runs.

Output Data

Field	Type	Description
reviewId	String	Unique identifier for the review
restaurantName	String	Name of the restaurant
restaurantId	String	Internal OpenTable restaurant ID
restaurantUrl	String	URL of the restaurant profile
rating	Number	Overall star rating (1-5)
text	String	Full review content
author	String	Reviewer nickname
date	String	ISO timestamp of review submission
visitDate	String	Date the reviewer dined
submittedDate	String	ISO timestamp of submission
foodRating	Number	Food quality score (1-5)
serviceRating	Number	Service quality score (1-5)
ambienceRating	Number	Ambience score (1-5)
valueRating	Number	Value score (1-5)
noiseLevel	String	Noise description (LOUD, MODERATE, etc.)
helpfulCount	Number	Total helpfulness votes
helpfulUp	Number	Positive helpfulness votes
helpfulDown	Number	Negative helpfulness votes
reviewType	String	Review source type (e.g. OPENTABLEVERIFIED)
fromPreviousConcept	Boolean	Whether review is from a previous restaurant concept
reviewerName	String	Reviewer display name
reviewerInitials	String	Reviewer initials
reviewerReviewCount	Number	Number of approved reviews by this reviewer
reviewerMetro	String	Reviewer metro area
reviewerMetroId	Number	Reviewer metro ID
reviewerIsVip	Boolean	VIP status indicator
reviewerProfileColor	String	Profile color shown by OpenTable
reviewerPhoto	String	Reviewer profile photo URL
publicRestaurantReply	String	Public reply from the restaurant
publicRestaurantReplyDate	String	Date of restaurant reply
photoUrls	Array	Review photo URLs

Usage Examples

Basic Review Extraction

Collect the latest reviews from a single restaurant:

{
  "startUrls": [
    { "url": "https://www.opentable.com/r/bestia-los-angeles" }
  ],
  "results_wanted": 50
}

Batch Scraping from a Metro Search

Provide a metro or search URL to collect reviews from all restaurants in that area:

{
  "startUrls": [
    { "url": "https://www.opentable.com/metro/los-angeles-restaurants" }
  ],
  "results_wanted": 100
}

Competitive Monitoring

Compare reviews across multiple specific restaurants in one run:

{
  "startUrls": [
    { "url": "https://www.opentable.com/r/restaurant-a" },
    { "url": "https://www.opentable.com/r/restaurant-b" }
  ],
  "results_wanted": 200,
  "proxyConfiguration": {
    "useApifyProxy": true,
    "apifyProxyGroups": ["RESIDENTIAL"]
  }
}

Sample Output

{
  "reviewId": "OT-96412-2110686937",
  "restaurantName": "Bestia",
  "restaurantId": "96412",
  "restaurantUrl": "https://www.opentable.com/r/bestia-los-angeles",
  "rating": 5,
  "text": "The food was incredible, especially the bone marrow and the cavatelli. Service was attentive and the atmosphere was lively.",
  "author": "FoodieLA",
  "date": "2023-11-20T10:45:00Z",
  "visitDate": "2023-11-18T19:30:00Z",
  "foodRating": 5,
  "serviceRating": 5,
  "ambienceRating": 4,
  "valueRating": 5,
  "noiseLevel": "LOUD",
  "helpfulCount": 12,
  "helpfulUp": 12,
  "helpfulDown": 0,
  "reviewType": "OPENTABLEVERIFIED",
  "fromPreviousConcept": false,
  "reviewerInitials": "F",
  "reviewerReviewCount": 34,
  "reviewerMetro": "Los Angeles",
  "reviewerMetroId": 6,
  "reviewerIsVip": true,
  "reviewerProfileColor": "PLUM"
}

Tips for Best Results

• Use residential proxies for larger runs to maintain reliability.
• Start with a modest results_wanted value to confirm the URL works, then increase for broader collection.
• Use restaurant profile URLs (e.g. opentable.com/r/restaurant-name) for deep dives into a single brand.
• Use metro or search URLs (e.g. opentable.com/metro/city-restaurants) to collect reviews across multiple restaurants in an area.
• Check the dataset preview before scheduling larger runs to verify data quality.

Integrations

• Google Sheets - Export review data for sentiment tagging and reporting.
• Webhooks - Trigger downstream workflows after each run completes.
• Make or Zapier - Connect results to no-code automations.
• API - Access datasets programmatically from your own systems.

Export Formats

• JSON - Ready for API consumption and developer workflows.
• CSV - Ideal for Excel and spreadsheet analysis.
• Excel - For clean business reporting.
• XML - For legacy system integrations.

Frequently Asked Questions

Can I scrape reviews from any country?

Yes. The Actor supports OpenTable domains globally including the US, UK, Canada, Australia, Germany, France, Japan, and more.

Does it handle reviews in different languages?

The Actor collects review text as it appears on OpenTable. Reviews in Spanish, French, German, Japanese, or other languages are extracted in their original language.

How many reviews can I collect?

There is no hard limit. You can collect thousands of reviews in a single run. Residential proxies are recommended for large-scale collection.

Can I scrape reviews from metro or search pages?

Yes. Metro URLs, neighborhood pages, and search results are supported. The Actor finds restaurant links from these pages and collects reviews from each one.

Can I export the data to CSV or Excel?

Yes. Apify datasets can be downloaded in CSV, Excel, JSON, XML, and other supported formats from the Apify Console.

Can I run this Actor on a schedule?

Yes. You can schedule the Actor in Apify Console to refresh data hourly, daily, weekly, or at another interval.

Why are some fields missing in the output?

Some fields may be empty when the source page does not publish that information. For example, not all reviewers have a metro listed or a VIP badge. Check multiple results before assuming the Actor failed.

Is it legal to scrape OpenTable reviews?

Scraping public web data can be legal, but you are responsible for complying with applicable laws, website terms, and privacy rules. Use the data responsibly.

Related Actors

• OpenTable Scraper - Collect restaurant listings, cuisine types, price bands, and contact data from OpenTable.
• Trip.com Hotel Reviews Scraper - Extract hotel reviews, ratings, and guest feedback from Trip.com.
• Realtor Agents Scraper - Extract real estate agent profiles, contact details, and market data.

Support

For issues, feature requests, or custom Actor work, use the Issues tab on the Actor page or contact the developer through Apify.

Legal Notice

This Actor is designed for legitimate data collection from publicly available sources. Users are responsible for using the data responsibly and complying with applicable laws and OpenTable's terms of service.