# 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 Copper Kettle | Charming pub with great food | 5 | Lovely atmosphere, the beef pie was excellent and portions generous. Friendly staff and cosy interior. Will return. | £15-£30 | 2026-01-31 | No | Cambridge, UK | Sophie L. | 48

2 | yelp.co.uk | Saffron & Sage | Fantastic flavours, slow service | 4 | Food was aromatic and beautifully plated. Service took longer than expected but chefs compensated with complimentary bread. | £20-£35 | 2026-02-02 | Yes | Bristol, UK | Mark J. | 112

3 | just-eat.co.uk | Bella Pizza | Great takeaway pizza | 5 | Hot on arrival, crust perfect, generous toppings. Delivered within promised time. Frequent orders from us. | £8-£18 | 2026-02-03 | Yes | Leeds, UK | Ayesha K. | 356

4 | deliveroo.co.uk | Little Szechuan | Authentic and spicy | 4 | Spicy dishes pack a punch and arrive piping hot. Portion sizes are good but packaging could be improved. | £10-£25 | 2026-02-03 | Yes | Manchester, UK | Tom R. | 89

5 | google.com | The Garden Brasserie | Relaxed spot, great brunch | 5 | Brunch menu is creative — eggs were perfect and coffee excellent. Outdoor seating pleasant on sunny days. | £12-£22 | 2026-02-01 | No | Brighton, UK | Ella P. | 214

6 | zomato.com | Mumbai Masala | Tasty curries, generous portions | 4 | Rich flavours and authentic spices. A bit noisy inside, but delivers on taste. Good vegetarian options. | £10-£20 | 2026-02-02 | Yes | London, UK | Rahul S. | 173

7 | facebook.com | Harbour Fish & Chips | Classic seaside meal | 5 | Crispy batter and fresh fish. Friendly counter staff and quick service. Kids loved it. | £6-£12 | 2026-02-03 | No | Whitby, UK | Claire M. | 47

8 | time-out.com | Modern Eatery | Trendy spot with seasonal menu | 4 | Interesting tasting menu and inventive cocktails. Slightly pricey but worth it for a special occasion. | £30-£60 | 2026-01-30 | No | Liverpool, UK | Gavin H. | 58

9 | thefork.co.uk | Le Petit Bistro | Romantic evening out | 5 | Attentive service and beautifully cooked duck. Excellent wine pairings suggested by sommelier. | £25-£45 | 2026-02-01 | No | Oxford, UK | Isabella D. | 129

10 | squaremeal.co.uk | The Brickhouse | Solid mains and cosy bar | 4 | Great steaks and a good selection of craft beers. Busy at weekends — recommend booking. | £22-£40 | 2026-02-02 | No | Sheffield, UK | Oliver K. | 66

11 | foodhub.co.uk | Tasty Kebabs | Reliable late-night option | 4 | Flavourful kebabs and quick delivery. Sauce packaging can be messy but overall good value. | £5-£12 | 2026-02-03 | Yes | Newcastle, UK | Hannah W. | 201

12 | tripadvisor.co.uk | The Olive Tree | Mediterranean delights | 5 | Fresh ingredients, generous mezze and lovely ambience. Staff were knowledgeable about dishes. | £18-£35 | 2026-02-01 | No | Bath, UK | George F. | 87

13 | yelp.co.uk | Vegan Roots | Creative plant-based menu | 5 | Impressed by the range and textures. Even non-vegans in our group were delighted. | £10-£22 | 2026-02-03 | Yes | Leeds, UK | Maya T. | 94

14 | just-eat.co.uk | Curry House Express | Reliable curry delivery | 4 | Consistent flavours and kept warm. Rice sometimes a little clumpy but overall very good for delivery. | £7-£18 | 2026-02-02 | Yes | Coventry, UK | Nick P. | 412

15 | deliveroo.co.uk | La Cantina | Authentic tacos delivered well | 5 | Tacos arrived with fresh salsa and good tortillas. Portions better than expected for delivery. | £9-£20 | 2026-02-03 | Yes | London, UK | Carla M. | 165

16 | google.com | Station Café | Quick stop with home-cooked food | 4 | Perfect for a midday bite. Roast dinner tasted homemade and service was friendly. | £8-£15 | 2026-01-31 | No | York, UK | Ben S. | 73

17 | zomato.com | Pho & Co | Comforting bowls of pho | 5 | Broth was rich and balanced, lots of fresh herbs and choice of proteins. Great for cold evenings. | £9-£16 | 2026-02-02 | Yes | Birmingham, UK | Linh N. | 128

18 | facebook.com | The Old Bakery | Homely pies and tea | 5 | Warm welcome and excellent steak and ale pie. Lovely selection of cakes too. | £6-£14 | 2026-02-01 | No | Norwich, UK | Patricia R. | 39

19 | time-out.com | Skyline Rooftop | Views and small plates | 4 | Stunning city views and well-crafted small plates. Cocktails strong and inventive. | £20-£45 | 2026-01-30 | No | Birmingham, UK | Alex V. | 141

20 | thefork.co.uk | Harbour Lights | Seafood perfection | 5 | Simply cooked, top quality fish. Perfect for a celebratory meal with attentive staff. | £30-£70 | 2026-02-02 | No | Southampton, UK | Renee B. | 92

21 | squaremeal.co.uk | The Vault | Business lunch done right | 4 | Efficient service and well-executed dishes. Good private dining options for meetings. | £18-£35 | 2026-02-01 | No | Manchester, UK | Daniel C. | 55

22 | foodhub.co.uk | Burger Barn | Good burgers at a bargain | 4 | Flavourful patties and crisp fries. Could be hotter on arrival but value is excellent. | £6-£14 | 2026-02-03 | Yes | Plymouth, UK | Rita S. | 278

23 | tripadvisor.co.uk | Rustic Table | Warm service and seasonal dishes | 5 | Menu changes with the seasons and everything tasted fresh. Lovely countryside setting. | £22-£40 | 2026-01-31 | No | Cotswolds, UK | Hugo M. | 63

24 | yelp.co.uk | Spice Market | Busy but worth the wait | 4 | Bold flavours and inventive cocktails. Service under pressure on peak nights but food arrives excellent. | £18-£33 | 2026-02-02 | No | London, UK | Nora F. | 137

25 | just-eat.co.uk | Falafel King | Fresh and filling | 5 | Crisp falafels and generous salad. Delivered quickly and still warm. Great vegetarian takeaway. | £5-£11 | 2026-02-03 | Yes | Birmingham, UK | Omar A. | 244

26 | deliveroo.co.uk | Sushi Corner | Consistent sushi sets | 4 | Fresh fish and neat presentation. Some rolls slighty smaller than in-restaurant portions. | £12-£28 | 2026-02-03 | Yes | London, UK | Yuki H. | 199

27 | google.com | The Nook | Cosy coffee and pastries | 5 | Excellent flat white and flaky croissants. Friendly local café with a loyal following. | £3-£8 | 2026-02-01 | No | Exeter, UK | Fiona G. | 34

28 | zomato.com | Burger & Barrel | Juicy burgers, great sides | 5 | Burgers cooked to order and onion rings perfectly crisp. Good selection of craft beers. | £10-£22 | 2026-02-02 | Yes | Newcastle, UK | Liam D. | 156

29 | facebook.com | Pasta Fresca | Handmade pasta heaven | 5 | Fresh pasta with delicate sauces. Staff were welcoming and recommended the perfect wine. | £14-£28 | 2026-02-03 | No | Nottingham, UK | Sienna K. | 121

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