# 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 Stag & Hounds | Lovely gastropub meal | 4.5 | Great Sunday roast, perfectly cooked beef and crispy potatoes. Friendly staff and cosy atmosphere. Slight wait for a table but worth it. | £15-£30 | 2026-02-02 | No | Bristol, UK | Emily R. | 132

2 | yelp.co.uk | La Bella Trattoria | Authentic Italian — highly recommend | 5.0 | Fresh pasta and the tiramisu was outstanding. Wine list good value. Staff were attentive and knowledgeable. | £20-£40 | 2026-02-03 | No | Manchester, UK | Marco S. | 48

3 | just-eat.co.uk | Curry House Express | Fast and tasty takeout | 4.0 | Delivered piping hot, generous portion sizes. Slightly salty for my taste but overall excellent value for a weeknight. | £6-£15 | 2026-02-04 | Yes | Leeds, UK | S. Patel | 204

4 | deliveroo.co.uk | Saffron Deli | Reliable Deliveroo favourite | 4.2 | Food arrived on time and still hot. Great flavours but rice portion was small. Would order again for lunch. | £8-£18 | 2026-02-03 | Yes | London W1 | Dan T. | 89

5 | google.com | The Harbour Grill | Top-notch steaks | 4.7 | Perfect char and generous sides. Service was professional and dessert was the highlight. A bit pricey but justified. | £30-£60 | 2026-02-01 | No | Brighton, UK | Olivia K. | 321

6 | zomato.com | Green Fork Vegan | Creative plant-based dishes | 4.3 | Innovative menu with exciting flavours. Portions moderate; friendly servers. Will return for brunch. | £10-£25 | 2026-02-04 | Yes | Bristol, UK | A. Morgan | 67

7 | facebook.com | The Old Post Office Cafe | Charming spot for coffee | 4.6 | Lovely interior and excellent espresso. Homemade cakes are a must-try. Busy on weekends so best to book. | £3-£12 | 2026-02-02 | No | Oxford, UK | Hannah P. | 58

8 | time-out.com | Skyline Rooftop | Great views, solid cocktails | 4.0 | Stunning skyline views and inventive cocktails. Small food menu but everything we tried was tasty. Expect a premium bill. | £20-£45 | 2026-02-03 | No | London SE1 | Tom F. | 143

9 | thefork.co.uk | Bistro Lumière | Excellent French bistro | 4.8 | Classic dishes done extremely well. Pleasant ambience and helpful sommelier. Ideal for a special occasion. | £25-£50 | 2026-02-01 | No | Edinburgh, UK | Claire D. | 214

10 | squaremeal.co.uk | The Food Hall | Brunch perfection | 4.4 | Wide brunch menu and high-quality produce. Service efficient; seating a bit cramped at peak times. | £8-£22 | 2026-02-04 | No | Cardiff, UK | Liam J. | 76

11 | foodhub.co.uk | Pizza Napoli | Great value family pizza | 4.1 | Crispy base and lots of toppings. Delivery was late but they offered a discount. Will order again. | £8-£20 | 2026-02-02 | Yes | Newcastle, UK | Sophie L. | 112

12 | tripadvisor.co.uk | Seaside Brasserie | Brilliant seafood dinner | 4.6 | Fresh fish and creative dishes. Friendly staff and relaxed atmosphere. Book for sunset seats. | £18-£45 | 2026-02-03 | No | Portsmouth, UK | George W. | 197

13 | yelp.co.uk | Kebab King | Late-night lifesaver | 3.9 | Open late and decent kebabs. Not gourmet, but fills the gap after a night out. Chips a little greasy. | £4-£10 | 2026-02-04 | Yes | Leicester, UK | Nina V. | 64

14 | just-eat.co.uk | Mama's Kitchen | Comfort food at home | 4.7 | Homely dishes, generous portions and fast delivery. Chicken pie was authentic and delicious. | £7-£18 | 2026-02-02 | Yes | Hull, UK | Peter H. | 256

15 | deliveroo.co.uk | Sushi Zen | Fresh sushi, elegant packaging | 4.9 | Nigiri and sashimi were melt-in-the-mouth. Delivery kept everything cool and intact. Slightly higher price point. | £12-£35 | 2026-02-03 | Yes | Cambridge, UK | Yuki M. | 91

16 | google.com | The Pancake Shack | Family-friendly brunch spot | 4.2 | Huge pancakes and friendly staff. Coffee could be stronger but kids loved it. Reasonably priced. | £5-£15 | 2026-02-01 | No | Southampton, UK | Rachel S. | 54

17 | zomato.com | Naan & Beyond | Bold flavours, great naan | 4.5 | Rich curries and fresh naans straight from the tandoor. Staff gave good spice recommendations. | £10-£22 | 2026-02-04 | Yes | Leicester, UK | Arjun K. | 128

18 | facebook.com | Cornerstone Bakery | Delicious artisan bread | 4.8 | Sourdough was excellent and pastries flaky. Friendly bakers who explain ingredients. Very popular in the morning. | £2-£10 | 2026-02-02 | No | Bath, UK | Maya L. | 39

19 | time-out.com | Midtown Tapas | Vibrant tapas bar | 4.3 | Great variety of small plates and excellent cocktail pairings. Lively atmosphere makes it a fun night out. | £15-£35 | 2026-02-03 | No | Birmingham, UK | Carlos R. | 154

20 | thefork.co.uk | Oak & Vine | Seasonal tasting menu | 4.9 | Beautifully presented tasting menu showcasing local produce. Attentive service and excellent wine pairing. | £55-£95 | 2026-02-01 | No | York, UK | Isabel M. | 88

21 | squaremeal.co.uk | The Conservatory | Perfect for celebrations | 4.6 | Elegant dining room and consistent service. Dishes are well executed and flavours balanced. | £30-£60 | 2026-02-04 | No | Manchester, UK | Daniel P. | 121

22 | foodhub.co.uk | Burger Barn | Classic burgers, good value | 4.0 | Juicy patties and generous toppings. Homemade sauces stood out. Fries were crisp and hot. | £7-£14 | 2026-02-02 | Yes | Bournemouth, UK | Keisha B. | 73

23 | tripadvisor.co.uk | Tea & Tattle | Quaint afternoon tea | 4.4 | Lovely selection of sandwiches and scones. Tea selection impressive; seating a bit tight but charming overall. | £18-£30 | 2026-02-03 | No | Cambridge, UK | Eleanor G. | 165

24 | yelp.co.uk | Dim Sum House | Authentic dim sum | 4.5 | Wide range of dumplings and buns, steamed perfectly. Busy weekends recommend booking ahead. | £12-£28 | 2026-02-04 | No | Coventry, UK | Kevin L. | 98

25 | just-eat.co.uk | Falafel Corner | Fresh and flavourful | 4.3 | Crispy falafel and fresh salads. Great for vegetarians and quick delivery times. | £5-£12 | 2026-02-01 | Yes | Nottingham, UK | Leila A. | 141

26 | deliveroo.co.uk | Mamma Mia Pizzeria | Wood-fired perfection | 4.7 | Authentic wood-fired pizzas with blistered crusts. Excellent toppings and speedy delivery. | £10-£22 | 2026-02-03 | Yes | Glasgow, UK | Ross C. | 176

27 | google.com | The Green Spoon | Healthy and hearty | 4.1 | Large salads and grain bowls. Good vegan options; portions could be larger for the price. | £9-£20 | 2026-02-02 | Yes | Ipswich, UK | Priya N. | 52

28 | zomato.com | The Spice Route | Bold pan-Asian flavours | 4.6 | Well-balanced dishes with layers of flavour. Great selection of small plates to share. | £18-£40 | 2026-02-04 | No | Leeds, UK | Owen H. | 137

29 | facebook.com | Moonlight Diner | Retro diner done right | 4.2 | Friendly staff and classic menu. Milkshakes were excellent; service a little slow at peak times. | £6-£15 | 2026-02-01 | No | Sheffield, UK | Beth C. | 29

30 | time-out.com | Artisan Smokehouse | Fantastic BBQ experience | 4.7 | Smoky brisket and soft buns. Great sides and a relaxed vibe. Portions generous for sharing. | £14-£35 | 2026-02-03 | No | Newcastle, UK | Alex G. | 190

## 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
