OpenTable Reviews Scraper

Scrape full OpenTable restaurant reviews by keyword and area or by pasted restaurant profile URLs. The actor collects every available review for each restaurant and returns structured rows with review text, ratings, diner profile data, review tags, review photos, restaurant metadata, cuisines, neighborhood, and profile links.

What You Get

Each dataset row is one OpenTable review. A keyword search collects the full review history for every restaurant it discovers around your coordinates; URL mode collects every review for each restaurant link you paste.

{
  "reviewId": "OT-4528-2110885052-140154862704",
  "reviewText": "Great place for dinner! The bar is beautiful and casual while the dining space is really nice!",
  "ratingOverall": 5,
  "ratingFood": 5,
  "ratingService": 5,
  "ratingAmbience": 5,
  "ratingValue": 5,
  "ratingNoise": "MODERATE",
  "reviewType": "OPENTABLEVERIFIED",
  "submittedDateTime": "2026-06-10T16:02:39Z",
  "dinedDateTime": "2026-06-09T18:45:00-04:00",
  "dinedDate": "2026-06-09",
  "reviewHelpfulUp": 0,
  "reviewHelpfulDown": 0,
  "reviewHelpfulScore": 0,
  "restaurantReplyText": null,
  "reviewerName": "Lynn",
  "reviewerLocation": "New York City",
  "reviewerApprovedReviewCount": 3,
  "reviewPhotoUrls": ["https://resizer.otstatic.com/v4/photos/94818492-1?width=160&height=160"],
  "reviewPhotoCount": 1,
  "restaurantId": 4528,
  "restaurantName": "Nobu Downtown",
  "restaurantUrl": "https://www.opentable.com/r/nobu-downtown-new-york",
  "restaurantPrimaryCuisine": "Japanese",
  "restaurantRating": 4.7,
  "restaurantTotalReviewCount": 5397
}

Input Modes

Keyword Search

Use keyword search when you want discovery by restaurant, cuisine, or dining phrase around a latitude and longitude.

{
  "mode": "search",
  "keywords": ["sushi", "steakhouse"],
  "location": "New York",
  "maxItems": 20
}

location accepts a city, neighborhood, or address (for example New York, Chelsea Manhattan, or 90210) and is resolved to map coordinates automatically. For precise control you can instead set latitude and longitude, which override location when both are provided.

Restaurant URLs

Use URL mode when you already have OpenTable restaurant profile links.

{
  "mode": "url",
  "startUrls": [
    { "url": "https://www.opentable.com/r/yakiniku-shodai-san-francisco" }
  ],
  "maxItems": 10
}

Filters

Filters apply to both input modes:

Field	Type	Description
minOverallRating	number	Keep reviews with this overall rating or higher.
minFoodRating	number	Keep reviews with this food rating or higher.
minServiceRating	number	Keep reviews with this service rating or higher.
minAmbienceRating	number	Keep reviews with this ambience rating or higher.
minValueRating	number	Keep reviews with this value rating or higher.
cuisines	array	Keep restaurants matching at least one cuisine value.
neighborhoods	array	Keep restaurants matching at least one neighborhood value.
fromDinedDate	string	Keep reviews dined on or after this YYYY-MM-DD date.
toDinedDate	string	Keep reviews dined on or before this YYYY-MM-DD date.
vipOnly	boolean	Keep reviews from VIP reviewers only.
requireReviewPhotos	boolean	Keep reviews with diner photos only.

Output Controls

Field	Type	Description
maxItems	integer	Primary cap on total review rows saved across the run.
maxReviewsPerRestaurant	integer	Optional cap per restaurant. Leave empty to collect every review (bounded only by maxItems).
maxRestaurants	integer	Keyword search only. How many restaurants per keyword to collect reviews from.
reviewSort	string	Review order per restaurant: highestRated (default), newest, or lowestRated.

MCP Connectors

Use mcpConnectors to send selected results into connected apps through Apify integrations. Supported connector servers include Notion, Linear, Airtable, and Apify. Set notionParentPageUrl when exporting to Notion. maxNotifyListings controls how many rows are sent to each connector and does not change the dataset.

Notes

OpenTable can return fewer rows than maxItems when the selected keyword, area, URLs, or filters match fewer current reviews. For URL mode, paste OpenTable restaurant profile links and the actor returns the matching restaurant's review where available.