# Collect reviews of bars and restaurants from various websites

Gather insights from diverse reviews in one place — streamline your bar and restaurant reputation without tedious manual searches

Archived sample configuration. Sample data is illustrative, not live data.

Build this in Jsonify: https://factory.jsonify.com/setup?q=Collect+reviews+of+bars+and+restaurants+from+various+websites

## Goal

Collect reviews of bars and restaurants from various websites

## Sources

- tripadvisor.co.uk

- yelp.co.uk

- just-eat.co.uk

- deliveroo.co.uk

- google.com

- zomato.com

- facebook.com

- time-out.com

- thefork.co.uk

- squaremeal.co.uk

- foodhub.co.uk

## Sample data

id | Source | Restaurant | ReviewTitle | Rating | ReviewText | PriceRange | Date | DeliveryAvailable | Location | Reviewer | ReviewsCount

1 | tripadvisor.co.uk | The Ivy Kensington Brasserie | Lovely atmosphere, reliable food | 4.0 | Visited for dinner — service was attentive and cocktails excellent. Beef wellington was a touch overdone but tasty. Good for special occasions. | £25-£45 | 2026-02-02 | No | Kensington, London | Olivia M. | 128

2 | yelp.co.uk | Flat Iron Soho | Great steak at a fair price | 4.5 | Simple menu but the steak is consistent. Sides are generous. Long queues but turnover is quick. | £15-£30 | 2026-02-03 | No | Soho, London | Jake T. | 342

3 | just-eat.co.uk | Pizzeria Da Marco | Quick delivery, fresh base | 4.0 | Pizza arrived hot and crust was crisp. Toppings generous. Slightly late due to weather but kept updated. | £8-£20 | 2026-02-04 | Yes | Bournemouth | Sophie R. | 57

4 | deliveroo.co.uk | Bao London | Delicious baos, fast rider | 4.8 | Soft bao, punchy fillings. Delivery packaging kept everything intact. Would order again for a group sharing meal. | £6-£22 | 2026-02-04 | Yes | Covent Garden, London | Amir H. | 214

5 | google.com | Dishoom Shoreditch | Always excellent breakfast | 4.7 | Bacon naan and house chai are a treat. Busy but atmosphere is buzzing. Staff friendly and efficient. | £12-£25 | 2026-02-01 | No | Shoreditch, London | Emma L. | 1987

6 | zomato.com | Padella Borough Market | Fresh pasta, long waits | 4.6 | Handmade pasta is outstanding. Expect queues but it's worth it for the quality and price. Wine list short but good. | £10-£25 | 2026-02-03 | No | Borough, London | Marco P. | 659

7 | facebook.com | The Good Egg Stoke Newington | Brunch hit with the family | 4.3 | Large portions and inventive dishes. Slightly noisy but lively. Staff handled a big crowd well. | £10-£20 | 2026-02-02 | No | Stoke Newington, London | Hannah W. | 86

8 | time-out.com | Hutong London | Impressive skyline dining | 4.2 | Stunning views and well-presented Cantonese dishes. Prices high but perfect for a date night. | £35-£70 | 2026-02-01 | No | The Shard, London | Time Out Reviewer | 412

9 | thefork.co.uk | The Ledbury | Exceptional tasting menu | 4.9 | Flawless cooking and service. Tasting menu is a memorable experience. Worth the splurge for special occasions. | £95-£160 | 2026-02-03 | No | Notting Hill, London | Gourmet Guide | 234

10 | squaremeal.co.uk | Hoppers | Sri Lankan plates to share | 4.4 | Vibrant flavours and great cocktails. Busy nights can mean longer waits for a table but atmosphere is lively. | £15-£35 | 2026-02-02 | No | Marylebone, London | Food Critic | 145

11 | foodhub.co.uk | The Fish Shack | Reliable takeaway fish & chips | 4.1 | Crispy batter and generous portions. Fries could be hotter but overall good value for a takeaway. | £6-£15 | 2026-02-04 | Yes | Brighton | Liam S. | 63

12 | tripadvisor.co.uk | Sketch (The Lecture Room) | Artful and indulgent experience | 4.8 | Beautiful interior and creative dishes. Service polished. Reservations essential at weekends. | £85-£180 | 2026-02-02 | No | Mayfair, London | Claire N. | 512

13 | yelp.co.uk | Franco Manca Brixton | Sourdough pizza done right | 4.5 | Perfect sourdough base and bright tomato sauce. Affordable and quick — great for casual meals. | £6-£12 | 2026-02-03 | Yes | Brixton, London | Marcus Y. | 274

14 | just-eat.co.uk | Curry House Express | Comforting curry, efficient service | 3.9 | Portions large and flavours decent. Delivery bag kept it warm. Some spice levels inconsistent. | £7-£18 | 2026-02-04 | Yes | Leicester | Priya K. | 41

15 | deliveroo.co.uk | Pizza Pilgrims | Tasty slices for sharing | 4.2 | Good quality toppings and chewy crust. Fast riders and clear tracking. Great for group orders. | £5-£20 | 2026-02-04 | Yes | Camden, London | Noah B. | 150

16 | google.com | Gauthier Soho | Refined dining with friendly staff | 4.6 | Excellent execution and well paired wines. Small plates ideal for tasting. Pricey but Michelin-level quality. | £60-£120 | 2026-02-01 | No | Soho, London | Isabella G. | 321

17 | zomato.com | Burger & Lobster Mayfair | Classic surf and turf combo | 4.0 | Lobster rolls generous and burgers juicy. Not many sides but main items deliver on flavour. | £20-£45 | 2026-02-03 | No | Mayfair, London | Tom F. | 478

18 | facebook.com | Oklava Shoreditch | Modern Turkish flavours shine | 4.5 | Creative mezze and excellent service. Booking recommended on busy nights. | £20-£40 | 2026-02-02 | No | Shoreditch, London | Leyla S. | 99

19 | time-out.com | Herman Ze German Kingly Court | Fast, fun street-style hotdogs | 3.8 | Good for a quick bite; sausages well seasoned. Portion sizes modest for the price. | £5-£12 | 2026-02-01 | No | Carnaby, London | Street Eats Editor | 58

20 | thefork.co.uk | Barrafina Drury Lane | Exceptional tapas bar | 4.7 | Impeccable Spanish dishes and lively bar scene. Standby seats available but book for dinner. | £25-£55 | 2026-02-03 | No | Covent Garden, London | Tapas Lover | 286

21 | squaremeal.co.uk | Gymkhana | Top-notch Indian fine dining | 4.6 | Polished setting and refined flavours inspired by colonial clubs. Excellent service and spice balance. | £40-£90 | 2026-02-02 | No | Mayfair, London | Restaurant Tester | 210

22 | foodhub.co.uk | Mama Mia Takeaway | Family favourite pizza and sides | 4.0 | Consistent quality and friendly drivers. Garlic bread excellent, pizza could use more topping variety. | £7-£22 | 2026-02-04 | Yes | Hull | Darren P. | 34

23 | tripadvisor.co.uk | Palomar | Vibrant Israeli flavours | 4.4 | Small plates packed with flavour. Drinks list complements menu well. Expect a lively, bustling room. | £25-£50 | 2026-02-02 | No | Soho, London | Rachel A. | 402

24 | yelp.co.uk | Bao Fitzrovia |  Street-food quality in a sit-down spot | 4.3 | Excellent steamed buns and inventive fillings. Good for sharing and casual nights out. | £6-£18 | 2026-02-03 | Yes | Fitzrovia, London | Connor L. | 167

25 | just-eat.co.uk | Spice Villa | Reliable curry takeaway | 3.7 | Flavours hit the mark for comfort but can be inconsistent between orders. Good value during deals. | £6-£16 | 2026-02-04 | Yes | Manchester | Aisha N. | 72

26 | deliveroo.co.uk | Honest Burgers | Solid burger and rosemary fries | 4.4 | Really good patties and house sauces. Delivery arrived warm and condiments intact. | £10-£20 | 2026-02-04 | Yes | Brixton, London | Ethan R. | 523

27 | google.com | Skylon Southbank | Great river views, modern dishes | 4.1 | Lovely setting for lunch with river views. Portions refined and service helpful. Slightly pricey for portion sizes. | £30-£65 | 2026-02-01 | No | Southbank, London | Nina V. | 142

28 | zomato.com | Rovi | Bright vegetable-led tasting | 4.6 | Inventive vegetarian plates and great wine pairings. Booking essential for weekend service. | £45-£95 | 2026-02-03 | No | Maida Vale, London | Oliver K. | 88

29 | facebook.com | Homeslice Neal's Yard | Huge slices for sharing | 4.2 | Generous, wood-fired slices with interesting topping combos. Queue moves fast during lunch. | £6-£14 | 2026-02-02 | Yes | Covent Garden, London | Mae S. | 205

## Additional fields

## Dashboard widgets

- {"id": "256dea03", "size": "small", "type": "metric", "title": "Total Reviews Collected"}

- {"id": "c2e92696", "size": "small", "type": "metric", "title": "Average Rating Across All Sources"}

- {"id": "9a2691f5", "size": "medium", "type": "pie", "title": "Market Share by Review Source"}

- {"id": "d85815f1", "size": "medium", "type": "donut", "title": "Distribution of Ratings (1-5 Stars)"}

- {"id": "64f40e33", "size": "large", "type": "line", "title": "Reviews Trend Over Time"}

- {"id": "abd81dc7", "size": "medium", "type": "horizontal_bar", "title": "Top 10 Rated Restaurants"}

- {"id": "d17208ae", "size": "medium", "type": "bar", "title": "Most Reviewed Bars by Source"}

- {"id": "3a3f30db", "size": "large", "type": "area", "title": "Cumulative Reviews Growth"}

- {"id": "2b96abe4", "size": "large", "type": "table", "title": "Recent Reviews Details"}

- {"id": "20b51352", "size": "medium", "type": "table", "title": "Top 5 Restaurants by Source"}

- {"id": "f0ccffcf", "size": "medium", "type": "insights", "title": "Key Observations from Reviews Analysis"}

- {"id": "4505b098", "size": "small", "type": "metric", "title": "Average Delivery Time (Just Eat & Deliveroo)"}

## Alerts

- {"id": "new_review", "icon": "bi-bell-fill", "item": "The Ivy", "title": "New Review Detected", "source": "tripadvisor.co.uk", "enabled": true, "send_to": "email", "severity": "info", "subtitle": "received a new review"}

- {"id": "top_rating", "icon": "bi-star-fill", "item": "The Fat Duck", "title": "Top Rating Achieved", "source": "yelp.co.uk", "enabled": false, "send_to": "slack", "severity": "success", "subtitle": "now has a 5-star rating"}

- {"id": "price_change", "icon": "bi-tag-fill", "item": "Pizza Express", "title": "Price Change Detected", "source": "just-eat.co.uk", "enabled": false, "send_to": "teams", "severity": "warning", "subtitle": "has updated their menu prices"}

- {"id": "new_listing", "icon": "bi-plus-circle-fill", "item": "BrewDog Manchester", "title": "New Venue Detected", "source": "zomato.com", "enabled": true, "send_to": "webhook", "severity": "success", "subtitle": "has opened and listed on Zomato"}

- {"id": "removal_notice", "icon": "bi-dash-circle-fill", "item": "Bistro du Vin", "title": "Review Removed", "source": "google.com", "enabled": false, "send_to": "email", "severity": "danger", "subtitle": "a review has been taken down"}

## Integrations

- google-sheets

- powerbi