# 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 Gilded Fork | Lovely neighbourhood find | 4.5 | Warm service, inventive seasonal menu. Small plates perfect for sharing; chocolate tart a highlight. Busy on Saturday evening but not overly noisy. | £25-£45 | 2026-02-02 | No | Brixton, London | Sophie M. | 128

2 | yelp.co.uk | Harbour Smokehouse | Great seafood and views | 4.0 | Excellent smoked mackerel and friendly staff. Portions generous. Long weekend wait but worth it. Cocktails were slightly overpriced. | £20-£40 | 2026-02-03 | Yes | Brighton | Tom R. | 54

3 | just-eat.co.uk | Bella Pasta | Perfect take-away on a rainy night | 4.2 | Arrived hot and on time. Fresh pasta and rich sauce. Garlic bread soggy but edible. Would order again. | £10-£18 | 2026-02-01 | Yes | Manchester | Aisha K. | 342

4 | deliveroo.co.uk | Dragon Wok | Speedy delivery, tasty flavours | 4.1 | Delivery was under 30 minutes. Noodles had good wok hei, but veg a bit undercooked. Generous chilli oil. | £8-£15 | 2026-02-04 | Yes | Sheffield | Liam G. | 89

5 | google.com | The Copper Spoon | Exceptional Sunday roast | 4.7 | Roast beef cooked to perfection with crisp potatoes and a silky gravy. Friendly team and cosy atmosphere. Book ahead for weekends. | £18-£35 | 2026-02-02 | No | Bath | Emily P. | 214

6 | zomato.com | Khana Express | Quick, flavorful curries | 3.9 | Affordable and quick service. Spice levels well-balanced. Rice portions small for the price. | £7-£14 | 2026-02-03 | Yes | Leeds | Arjun S. | 47

7 | facebook.com | The Old Lantern | Cosy pub with live music | 4.3 | Great selection of craft ales and a friendly landlord. Live folk band on Friday was brilliant. Food menu limited but tasty. | £12-£25 | 2026-01-31 | No | Oxford | Claire D. | 76

8 | time-out.com | Saffron & Sage | Top modern Indian | 4.6 | Modern take on classic dishes; innovative plating and deep flavours. Service knowledgeable and attentive. Splurge-worthy for special occasions. | £30-£55 | 2026-02-01 | No | London | Marcus H. | 165

9 | thefork.co.uk | La Petite Rue | Charming bistro | 4.4 | Intimate setting and well-executed French classics. Duck confit outstanding. Wine pairings recommended by staff were spot on. | £22-£40 | 2026-02-04 | No | Cambridge | Nora L. | 98

10 | squaremeal.co.uk | Grain & Barrel | Excellent tasting menu | 4.8 | Memorable tasting menu with clever flavour combinations and excellent service. Slightly pricey but justified by quality. | £45-£75 | 2026-02-03 | No | Edinburgh | Daniel W. | 56

11 | foodhub.co.uk | Pizza Via Roma | Authentic Neapolitan pizza | 4.2 | Crust blistered perfectly, fresh toppings and fragrant basil. Delivery packaging kept it intact. Would prefer more topping options. | £9-£16 | 2026-02-02 | Yes | Glasgow | Fiona B. | 203

12 | tripadvisor.co.uk | Seaside Brasserie | Lovely coastal lunch | 4.0 | Fresh fish and bright salads; staff attentive. Patio seating nice on a clear day. Portions a bit small for mains. | £15-£30 | 2026-02-01 | No | Whitley Bay | Peter J. | 134

13 | yelp.co.uk | Bao & Co | Great for quick bites | 4.1 | Soft bao buns and inventive fillings. Service rapid and friendly. Limited seating at peak times. | £6-£12 | 2026-02-03 | Yes | Bristol | Maya T. | 68

14 | just-eat.co.uk | Curry Corner | Reliable curry takeaway | 3.8 | Good value and consistent flavour. Some items arrived a little greasy but overall satisfying. Generous naan portions. | £8-£20 | 2026-02-04 | Yes | Newcastle | Omar Z. | 415

15 | deliveroo.co.uk | Green Bowl Salad Bar | Fresh and fast | 4.5 | Customisable bowls with crisp produce. Avocado ripeness varied but dressing tasty. Perfect for a healthy lunch. | £6-£11 | 2026-02-02 | Yes | Birmingham | Hannah C. | 91

16 | google.com | The Lantern & Vine | Fantastic vegetarian options | 4.6 | Creative veggie mains that impressed meat-eating friends. Outstanding dessert menu. Booked for anniversary and service nailed it. | £18-£32 | 2026-02-01 | No | York | Sam T. | 187

17 | zomato.com | Sizzle Steakhouse | Good steaks, noisy room | 4.0 | Steaks cooked well; sides decent. Dining room quite loud which detracted from conversation. Decent wine list. | £28-£50 | 2026-02-03 | No | Leicester | Graham P. | 122

18 | facebook.com | The Village Deli | Lovely brunch spot | 4.4 | Great coffee and avocado toast. Friendly baristas and relaxed vibe. Can get busy at weekend mornings. | £6-£14 | 2026-02-04 | No | St Albans | Leah W. | 64

19 | time-out.com | Oceana Grill | Stylish seafood dining | 4.5 | Modern seafood dishes with theatrical presentation. Service polished. Worth trying the tasting flight. | £35-£60 | 2026-02-02 | No | Manchester | Ibrahim E. | 142

20 | thefork.co.uk | Terrace 45 | Wedding rehearsal dinner success | 4.7 | Private dining well-organised, menu flexible and staff attentive. Guests praised flavours and presentation. | £40-£70 | 2026-01-31 | No | Reading | Clara S. | 39

21 | squaremeal.co.uk | Vault & Vine | Impressive wine list | 4.6 | Exceptional wine selection and small plates designed to share. Ambient setting for a date night. | £30-£55 | 2026-02-04 | No | Bournemouth | Owen K. | 77

22 | foodhub.co.uk | Express Kebabs | Late-night lifesaver | 3.9 | Greasy but satisfying kebabs served late. Good value after a night out. Sauces plentiful. | £4-£9 | 2026-02-03 | Yes | Liverpool | Zara N. | 256

23 | tripadvisor.co.uk | Riverside Tea Rooms | Delightful cakes and view | 4.3 | Homemade scones and a scenic river view. Tea selection broad. Slightly slow service when busy. | £5-£12 | 2026-02-01 | No | Henley-on-Thames | Margaret H. | 190

24 | yelp.co.uk | Miso & Matcha | Authentic Japanese cafe | 4.2 | Excellent matcha drinks and delicate sushi rolls. Minimalist decor and friendly staff. Portions small but fresh. | £7-£18 | 2026-02-02 | Yes | Coventry | Kenji Y. | 58

25 | just-eat.co.uk | Taco Town | Fast and flavourful tacos | 4.0 | Tacos packed with flavour and fresh slaw. Salsas had a nice kick. Tortillas a bit chewy from delivery. | £6-£13 | 2026-02-04 | Yes | Portsmouth | Ruth B. | 131

26 | deliveroo.co.uk | Sunrise Breakfast Co. | Brilliant weekend pancakes | 4.5 | Fluffy pancakes and excellent coffee. Staff friendly and efficient. Queue moved quickly. | £5-£12 | 2026-02-03 | No | Milton Keynes | Connor F. | 88

27 | google.com | The Red Lantern | Authentic Cantonese flavours | 4.4 | Dim sum fresh and delicate; roast pork succulent. Atmosphere bustling but welcoming. | £16-£30 | 2026-02-02 | Yes | Cardiff | Yvonne L. | 163

28 | zomato.com | Piadina Street | Delicious Italian street food | 4.1 | Crispy piadina with inventive fillings and fresh ingredients. Great for a quick lunch. | £5-£10 | 2026-02-01 | Yes | Norwich | Marco R. | 49

29 | facebook.com | The Botanist Cafe | Perfect stop after a walk | 4.3 | Warm soups and hearty sandwiches. Dog-friendly and welcoming staff. Could use more vegan options. | £7-£15 | 2026-02-03 | No | Dorking | Patricia O. | 71

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