Restaurant Review Aggregator avatar

Restaurant Review Aggregator

Try for free

Pay $3.00 for 1,000 Reviews

View all Actors
Restaurant Review Aggregator

Restaurant Review Aggregator

tri_angle/restaurant-review-aggregator
Try for free

Pay $3.00 for 1,000 Reviews

Add restaurant names and get reviews from Yelp, Google Maps, Doordash, UberEats, Tripadvisor, and Facebook. Extract review text, place address, rating, date, reviewer's name. Export reviews in JSON, CSV, HTML, use API, schedule and monitor runs or integrate reviews data with other tools.

Do you want to learn more about this Actor?

Get a demo

šŸ½ļø What is Restaurant Reviews Aggregator?

Restaurant Reviews Aggregator is designed to scrape restaurant reviews across 6 restaurant review sites: Tripadvisor, Yelp, Google Maps, Facebook, DoorDash and UberEats. The scraper extracts the reviews based on your search query + location or place URL.Ā It is an Actor bundleĀ created by combining scrapers from six most popular restaurant review platforms (see theĀ detailed listĀ ā¬‡ļø).

What can you accomplish with this Restaurant Reviews Aggregator?

šŸ¤ Extract restaurant reviews data by keywords, names or specific URLs

ā­ļø Extract review text, place address, rating, date, reviewer's name in one go

šŸ±Ā Aggregate reviews from multiple platforms into one dataset

šŸ‘€Ā Choose how many platforms to scrape reviews from ā€” just a few or all six at once

šŸŽÆĀ Choose location and narrow down the keyword search to match the restaurant name

šŸ—“Ā Prefilter scraped reviews by date

ā˜„ļø Get more than 1,600 results for free

šŸ¦¾Ā Use scraped data as restaurant reviews API

ā¬‡ļø Download reviews data in Excel, CSV, JSON, XML, and other formats

šŸ’ø Is this Restaurant Reviews Aggregator free?

Yes. Apify provides you with $5 free usage credits every month on the Apify Free plan, allowing you to scrape 1,600 restaurant reviews within those limits.

For regular data extraction needs, consider getting an Apify subscription. We recommend our $49/month Starter plan for extensive scraping.

šŸ›Ž How to use Restaurant Review Aggregator

It's easy to extract reviews across different review sites with Restaurant Reviews Aggregator. Follow these steps:

  1. Find Restaurant Review Aggregator on Apify Store and click the Try for free button.
  2. Add the search queries and location.
  3. Add a number of reviews to be scraped from that area by that keyword.
  4. Alternatively, add Google Maps URLs of restaurants (as a starting point).
  5. Choose the target review websites you want to scrape reviews from.
  6. Click "Start" and wait for the data to be extracted.
  7. Export your reviews dataset in JSON, XML, CSV, Excel, or HTML or using API.

ā¬‡ļø Input

To search for restaurant reviews, the input for Restaurant Reviews Aggregator should be search queries or restaurant names, location or URLs. You can add queries or URLs one by one or all at once. Here's an example of an input for the keyword "grill" in Chicago, for all 6 review sites for the past year.

restaurant Reviews API

You can input data by filling out fields, using JSON, or programmatically via an API. For more details on how to configure input in JSON, see the input tab.

ā¬†ļø Output sample

The results will be wrapped into a dataset which you can find in the Output tab. The full information about each review comes from the target review website. In case the review for some reason is not available on the target review site, the review will be scraped from Google Maps. Each place is uniquely identified through theĀ googleMapsPlaceId.

Google Reviews API

You can preview all the fields in theĀ StorageĀ tab and choose the format in which to export the restaurant reviews you've extracted: JSON, CSV, Excel, or HTML table. Here below is the same sample dataset in JSON:

1{
2    "googleMapsPlaceId": "ChIJJcecAXjLD4gRXx7OEnnaQ74",
3    "placeName": "Jerusalem Grill",
4    "placeAlternateNames": [],
5    "placeUrl": "https://www.tripadvisor.com/Restaurant_Review-g35805-d15168112-Reviews-Jerusalem_Grill-Chicago_Illinois.html",
6    "placeAddress": "3142 N Narragansett Ave, Chicago, IL 60634-4919",
7    "provider": "tripadvisor",
8    "reviewId": "631461494",
9    "reviewUrl": "https://www.tripadvisor.com/ShowUserReviews-g35805-d15168112-r631461494-Jerusalem_Grill-Chicago_Illinois.html",
10    "reviewTitle": "Delicious and fresh",
11    "reviewText": "Healthy and delicious and fresh! We absolutely love ordering from the place, especially since itā€™s close to the house. Even our kids love it. My favorite is the mixed grill šŸ˜‹",
12    "reviewDate": "2018-11-06T00:00:00.000Z",
13    "reviewRating": 5,
14    "authorName": "ToleRae"
15  },
16  {
17    "googleMapsPlaceId": "ChIJVb_BQabND4gRcoAAUepE81o",
18    "placeName": "Outdoor Grill",
19    "placeAlternateNames": [],
20    "placeUrl": "https://www.tripadvisor.com/Restaurant_Review-g35805-d3349050-Reviews-Outdoor_Grill-Chicago_Illinois.html",
21    "placeAddress": "3265 N Milwaukee Ave, Chicago, IL 60618-5118",
22    "provider": "tripadvisor",
23    "reviewId": "824503927",
24    "reviewUrl": "https://www.tripadvisor.com/ShowUserReviews-g35805-d3349050-r824503927-Outdoor_Grill-Chicago_Illinois.html",
25    "reviewTitle": "Fantastic!",
26    "reviewText": "Wonderful food, incredible staff, local flavors, and a great atmosphere. Simply delicious and I will definitely be back again!",
27    "reviewDate": "2022-01-09T00:00:00.000Z",
28    "reviewRating": 5,
29    "authorName": "Michael M"
30  },
31  {
32  "googleMapsPlaceId": "ChIJI84nLZrND4gRE4zTJfq4xG0",
33  "placeName": "Subway",
34  "placeAlternateNames": [],
35  "placeUrl": "https://www.doordash.com/store/subway-chicago-277530/",
36  "placeAddress": "5150 W Belmont Ave, Chicago, IL 60641, USA",
37  "provider": "door-dash",
38  "reviewUrl": null,
39  "reviewTitle": null,
40  "reviewText": "add more meat for gods sake",
41  "reviewDate": "2024-01-03T21:47:20.757Z",
42  "reviewRating": 4,
43  "authorName": "laiiboo l"
44},
45{
46  "googleMapsPlaceId": "ChIJI84nLZrND4gRE4zTJfq4xG0",
47  "placeName": "Subway",
48  "placeAlternateNames": [],
49  "placeUrl": "https://www.doordash.com/store/subway-chicago-277530/",
50  "placeAddress": "5150 W Belmont Ave, Chicago, IL 60641, USA",
51  "provider": "door-dash",
52  "reviewUrl": null,
53  "reviewTitle": null,
54  "reviewText": "Forgot my lettuce and Mayonesa",
55  "reviewDate": "2023-03-03T00:43:20.300Z",
56  "reviewRating": 2,
57  "authorName": "Roberto V"
58},
59{
60  "initialQuery": "https://www.google.com/maps/search/?api=1&query=Haps%20grill%20fish%26chicken&query_place_id=ChIJud67RoUvDogRWY8Zem-iYVs",
61  "googleMapsPlaceId": "ChIJud67RoUvDogRWY8Zem-iYVs",
62  "placeName": "Haps grill fish&chicken",
63  "placeAlternateNames": [],
64  "placeUrl": "https://www.google.com/maps/search/?api=1&query=Haps%20grill%20fish%26chicken&query_place_id=ChIJud67RoUvDogRWY8Zem-iYVs",
65  "placeAddress": "6859 S Loomis Blvd, Chicago, IL 60636",
66  "provider": "google-maps",
67  "reviewId": "ChdDSUhNMG9nS0VJQ0FnSUNsdzV6YThBRRAB",
68  "reviewUrl": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnSUNsdzV6YThBRRAB!2m1!1s0x0:0x5b61a26f7a198f59!3m1!1s2@1:CIHM0ogKEICAgIClw5za8AE%7CCgwIqrmIqwYQ4NOVhQE%7C?hl=en",
69  "reviewTitle": null,
70  "reviewText": "quick sandwich, kool enjoyed it going back,",
71  "reviewDate": "2023-11-25T16:11:22.279Z",
72  "reviewRating": 3,
73  "authorName": "Michael McClom Sr."
74},
75{
76  "initialQuery": "https://www.google.com/maps/search/?api=1&query=Haps%20grill%20fish%26chicken&query_place_id=ChIJud67RoUvDogRWY8Zem-iYVs",
77  "googleMapsPlaceId": "ChIJud67RoUvDogRWY8Zem-iYVs",
78  "placeName": "Haps grill fish&chicken",
79  "placeAlternateNames": [],
80  "placeUrl": "https://www.google.com/maps/search/?api=1&query=Haps%20grill%20fish%26chicken&query_place_id=ChIJud67RoUvDogRWY8Zem-iYVs",
81  "placeAddress": "6859 S Loomis Blvd, Chicago, IL 60636",
82  "provider": "google-maps",
83  "reviewId": "ChdDSUhNMG9nS0VJQ0FnSURGcHZPeF9BRRAB",
84  "reviewUrl": "https://www.google.com/maps/reviews/data=!4m8!14m7!1m6!2m5!1sChdDSUhNMG9nS0VJQ0FnSURGcHZPeF9BRRAB!2m1!1s0x0:0x5b61a26f7a198f59!3m1!1s2@1:CIHM0ogKEICAgIDFpvOx_AE%7CCgwI-balqgYQgJCwgQM%7C?hl=en",
85  "reviewTitle": null,
86  "reviewText": "Welp they close again šŸ˜• he was struggling",
87  "reviewDate": "2023-11-06T21:32:41.808Z",
88  "reviewRating": 2,
89  "authorName": "Tiara Carter"
90},
91{
92  "googleMapsPlaceId": "ChIJ_14BgMIvDogRdL0QQ2VYLXY",
93  "placeName": "Chicago Food On The Run | Chicago IL",
94  "placeAlternateNames": [],
95  "placeUrl": "https://www.facebook.com/100026879958286/",
96  "placeAddress": "8040 S. Ashland Ave, Chicago, IL, United States, Illinois",
97  "provider": "facebook",
98  "reviewId": "UzpfSTEwMDA3MTcyMTQ4Nzk2ODoxNDUwMjkxODQ1NjQ0NjQ6MTQ1MDI5MTg0NTY0NDY0",
99  "reviewUrl": "https://www.facebook.com/permalink.php?story_fbid=pfbid0YAVjAiA7d8Z1tTmaC2dZ9m5Pye3yVXGgXViTM3Ttk9MGdPAhoAwcngHhW926Xaqvl&id=100071721487968",
100  "reviewTitle": null,
101  "reviewText": "Last year in August they was pretty good, I donā€™t know if they changed cooks or what, theirs food is to spicy now, put to many potatoes in their roast now, and less meat , sweet potatoes ainā€™t the same , string beans to hot, they food used to taste fresher, now is like itā€™s a week old or  cooked food has been frozen to long , I havenā€™t been in awhile, until today and itā€™s even worse .",
102  "reviewDate": "2022-01-10T23:58:31.000Z",
103  "reviewRating": null,
104  "authorName": "Antoinette Wash"
105},
106{
107  "googleMapsPlaceId": "ChIJ_14BgMIvDogRdL0QQ2VYLXY",
108  "placeName": "Chicago Food On The Run | Chicago IL",
109  "placeAlternateNames": [],
110  "placeUrl": "https://www.facebook.com/100026879958286/",
111  "placeAddress": "8040 S. Ashland Ave, Chicago, IL, United States, Illinois",
112  "provider": "facebook",
113  "reviewId": "UzpfSTEwMDAwMDI1MjY3Nzg1NDo1MzA2NTgyNzg2MDI2NzU4OjUzMDY1ODI3ODYwMjY3NTg=",
114  "reviewUrl": "https://www.facebook.com/carolyn.fourte/posts/pfbid04J5SH2KrpubdgDppJByXUqwnofscnr92vvYKnpm7ZdSzGQh4p3AxzPgAhocqETbLl",
115  "reviewTitle": null,
116  "reviewText": "seasoned just right! Quick service!",
117  "reviewDate": "2022-03-30T22:09:38.000Z",
118  "reviewRating": null,
119  "authorName": "Carolyn Diane FourtƩ"
120},
121 {
122    "googleMapsPlaceId": "ChIJUd2L8trND4gRJZ9gTYiBhIQ",
123    "placeName": "Los Asadores Mexican Grill",
124    "placeAlternateNames": [],
125    "placeUrl": "https://www.ubereats.com/store/los-asadores-mexican-grill/U27Ry8M7SHGBaNJRHM0sqw?srsltid=AfmBOooqXiCCl2sgEMHNoNWexoV-fYCI_69_7Ut5_maKwKxvIYg4WnE2",
126    "placeAddress": "3312 W Foster Ave, Chicago, IL 60625",
127    "provider": "uber-eats",
128    "reviewId": null,
129    "reviewUrl": null,
130    "reviewTitle": null,
131    "reviewText": "great tasting food!",
132    "reviewDate": "2024-08-10T00:00:00.000Z",
133    "reviewRating": null,
134    "authorName": "Paola R."
135  },
136  {
137    "googleMapsPlaceId": "ChIJUd2L8trND4gRJZ9gTYiBhIQ",
138    "placeName": "Los Asadores Mexican Grill",
139    "placeAlternateNames": [],
140    "placeUrl": "https://www.ubereats.com/store/los-asadores-mexican-grill/U27Ry8M7SHGBaNJRHM0sqw?srsltid=AfmBOooqXiCCl2sgEMHNoNWexoV-fYCI_69_7Ut5_maKwKxvIYg4WnE2",
141    "placeAddress": "3312 W Foster Ave, Chicago, IL 60625",
142    "provider": "uber-eats",
143    "reviewId": null,
144    "reviewUrl": null,
145    "reviewTitle": null,
146    "reviewText": "they're salsa and their chips as well as the food is awesome they fix it just the way I like it and they take a special care to the fact that I'm allergic to certain foods and they take care and understanding that I like that most restaurants don't c",
147    "reviewDate": "2024-06-18T00:00:00.000Z",
148    "reviewRating": null,
149    "authorName": "Ramona S."
150  },
151  {
152    "googleMapsPlaceId": "ChIJ0VfBS10tDogR93VPEGTyeek",
153    "placeName": "Uncle Ben's Grill",
154    "placeAlternateNames": [],
155    "placeUrl": "https://www.ubereats.com/store/uncle-bens-grill/0w04aYotQMWip0_qt-gNbg?srsltid=AfmBOooNBelKsg3R17iPiLKBW2NY_pi59W2p0XKAIsA_0jif8_YEk-q_",
156    "placeAddress": "456 North Damen Avenue, Chicago, IL 60622",
157    "provider": "uber-eats",
158    "reviewId": null,
159    "reviewUrl": null,
160    "reviewTitle": null,
161    "reviewText": "amazing breakfast sandwiches",
162    "reviewDate": "2024-07-20T00:00:00.000Z",
163    "reviewRating": null,
164    "authorName": "Chris D."
165  },
166  {
167    "googleMapsPlaceId": "ChIJ0VfBS10tDogR93VPEGTyeek",
168    "placeName": "Uncle Ben's Grill",
169    "placeAlternateNames": [],
170    "placeUrl": "https://www.ubereats.com/store/uncle-bens-grill/0w04aYotQMWip0_qt-gNbg?srsltid=AfmBOooNBelKsg3R17iPiLKBW2NY_pi59W2p0XKAIsA_0jif8_YEk-q_",
171    "placeAddress": "456 North Damen Avenue, Chicago, IL 60622",
172    "provider": "uber-eats",
173    "reviewId": null,
174    "reviewUrl": null,
175    "reviewTitle": null,
176    "reviewText": "wonderful server and lovely person",
177    "reviewDate": "2024-05-17T00:00:00.000Z",
178    "reviewRating": null,
179    "authorName": "Vondale M."
180  },
181  ...

Some additional information is saved in theĀ KeyValueStore, for instance:

  • the external Actors' run IDs;
  • the places scraped from each provider;
  • the addresses' geocodes.

šŸ“ Want more tools for scraping restaurant reviews?

This scraper is an Actor bundle, named so because it combines six different Actors into one. You can of course scrape each restaurant review site separately using a designated Actor. Restaurant Review Aggregator combines the results of scrapers from the following websites:

Reviews siteScraper
šŸ„‚ YelpYelp Scraper
šŸ“ Google MapsGoogle Maps Reviews Scraper
šŸ” UberEatsUberEats Reviews Scraper
šŸŒ“ TripadvisorTripadvisor Reviews Scraper
šŸ“˜ FacebookFacebook Reviews Scraper
šŸ½ļø DoorDashDoorDash Reviews Scraper

If you want to check out more Actor bundles, you might be interested in šŸ¤”Ā Social Media Sentiment Analysis ToolĀ and šŸ“±Ā Social Media Finder.

ā“FAQ

How does Restaurant Review Aggregator work?

First, it identifies places from Google Maps according to your input. The scraper takes places found Google Maps as the source of truth: therefore, each extracted review will refer to a place found on Google Maps, at the very least. Then, the Aggregator takes the places found on Google Maps as the new input and scrapes their reviews on other review sites.

How does the Aggregator extract restaurant reviews from Facebook?

Scraping restaurant reviews from Facebook in particular has a special approach:

  1. Once the Aggregator finds each place on Google Maps, it then searches for their respective Facebook Pages using Google Search.
  2. The Aggregator scrapes the Facebook URLs it found to get the necessary information from each page, such as the place address.
  3. The addresses from Google Maps and the Facebook Pages are then geocoded (using their coordinates on Google Maps) and compared.
  4. The places with the matching addresses are eventually scraped for reviews.

OurĀ scrapers are ethical andĀ do not extract any private user data. They only extract what the user has chosen to share publicly. However, you should be aware that your results could contain personal data such as names. You should not scrape personal data unless you have a legitimate reason to do so.

If you're unsure whether your reason is legitimate, consult your lawyers. You can also read our blog post on theĀ legality of web scrapingĀ andĀ ethical scraping.

Can I use this Review Aggregator as a Restaurant Review API?

Yes, you can use the Apify API to access data scraped by Restaurant Review Aggregator programmatically. The API allows you to manage, schedule, and run Apify Actors, access datasets, monitor performance, get results, create and update Actor versions, and more.

To access the API using Node.js or Python, you can use the apify-client in the NPM package or PyPI package. There are also API endpoints available for extracting data without a client. For detailed information and code examples, see the API tab or refer to the Apify API documentation.

Can I integrate Restaurant Reviews Aggregator with other apps?

Yes. Restaurant Reviews Aggregator can be connected with almost any cloud service or web app thanks to the integrations available on the Apify platform. You can integrate your data with Zapier, Slack, Make, Airbyte, GitHub, Google Drive, LangChain, and more.

You can also use webhooks to carry out an action whenever an event occurs, e.g., get a notification whenever Restaurant Reviews Aggregator successfully finishes a run.

Your feedback

Weā€™re always working on improving the performance of our Actors. So if youā€™ve got any technical feedback for this Review Aggregator or simply found a bug, please create an issue on the Actorā€™s Issues tab.

Developer
Maintained by Apify
Actor metrics
  • 18 monthly users
  • 5 stars
  • 77.4% runs succeeded
  • Created in Apr 2024
  • Modified 3 days ago