# 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 Old Mill Tavern | Cozy spot with great service | 4.5 | Lovely atmosphere, friendly staff and the fish pie was excellent. Busy on Friday night but worth the wait. | £15-£30 | 2026-02-03 | No | Cambridge, UK | Hannah M. | 42

2 | yelp.co.uk | Brookside Burgers | Fantastic burgers and quick delivery | 4.0 | Ordered via the app — burger arrived hot, fries were crispy. Cheese was perfect. Would order again. | £8-£16 | 2026-02-02 | Yes | Bristol, UK | Liam P. | 128

3 | just-eat.co.uk | Saffron Spice | Authentic flavours, generous portions | 4.7 | Curry selection is spot on. Rice portion was plentiful and naan was fluffy. Delivery driver polite. | £10-£25 | 2026-02-04 | Yes | Leeds, UK | Priya K. | 204

4 | deliveroo.co.uk | Green Plate Vegan | Fresh, creative plant dishes | 4.3 | Great variety of bowls and salads. Packaging keeps food intact for delivery. Slightly pricey. | £9-£18 | 2026-02-01 | Yes | Manchester, UK | Ethan R. | 67

5 | google.com | Seabreeze Oyster Bar | Excellent seafood and views | 4.8 | Amazing oysters and seabass. Staff were attentive and the terrace view was stunning at sunset. | £25-£50 | 2026-02-03 | No | Brighton, UK | Sophie A. | 312

6 | zomato.com | Casa di Roma | Homemade pasta — very authentic | 4.2 | Pasta cooked al dente, sauces rich. Tiramisu could be sweeter. Cozy interior. | £18-£35 | 2026-02-02 | No | London, UK | Marco G. | 89

7 | facebook.com | The Corner Tap | Great pub quiz night | 4.6 | Brilliant quiz, good pub grub and friendly regulars. Book ahead on quiz nights. | £6-£20 | 2026-02-04 | No | Cardiff, UK | Olivia S. | 56

8 | time-out.com | Skyline Rooftop | Stylish rooftop, pricey cocktails | 4.0 | Fantastic skyline views and well-made cocktails. Small plates are tasty but expensive. | £12-£40 | 2026-01-31 | No | London, UK | Daniel F. | 142

9 | thefork.co.uk | Bistro Lumière | Romantic and refined | 4.9 | Exceptional tasting menu and attentive sommelier. Perfect for anniversaries. | £45-£90 | 2026-02-02 | No | Edinburgh, UK | Claire B. | 58

10 | squaremeal.co.uk | Harbourside Grill | Business lunch done right | 4.4 | Efficient service and stellar grilled cod. Quiet atmosphere ideal for meetings. | £20-£40 | 2026-02-03 | No | Newcastle, UK | Gareth L. | 73

11 | foodhub.co.uk | Pizza Piazza | Reliable family pizza | 4.1 | Good value pizzas, toppings generous. Dough slightly uneven but tasty overall. | £7-£18 | 2026-02-01 | Yes | Southampton, UK | Maya D. | 95

12 | tripadvisor.co.uk | The Lantern Chinese | Delicious dim sum | 4.6 | Steamed dumplings were fresh and flavourful. Service was prompt and friendly. | £10-£22 | 2026-02-04 | Yes | Birmingham, UK | Jason W. | 167

13 | yelp.co.uk | Cafe Riviera | Brilliant brunch spot | 4.7 | Avocado toast with poached eggs was perfect. Coffee was strong and great customer service. | £6-£14 | 2026-02-03 | No | Nottingham, UK | Amelia H. | 218

14 | just-eat.co.uk | Kebab King | Late-night lifesaver | 3.9 | Great for a late-night feed. Meat a little fatty but overall satisfying and quick delivery. | £5-£12 | 2026-02-02 | Yes | Sheffield, UK | Connor S. | 34

15 | deliveroo.co.uk | Sushi Atelier | Artful sushi, well presented | 4.5 | Beautiful presentation and fresh fish. Was slightly delayed but quality made up for it. | £20-£45 | 2026-02-01 | Yes | Belfast, UK | Nina C. | 121

16 | google.com | The Vegan Jar | Creative plant-based menu | 4.4 | Innovative dishes and tasty desserts. Friendly staff and relaxed vibe. | £10-£22 | 2026-02-03 | Yes | Glasgow, UK | Owen T. | 76

17 | zomato.com | La Baguette | Fresh bakery — wonderful pastries | 4.8 | Croissants were flaky and buttery. Staff were welcoming and shop smelled amazing. | £2-£8 | 2026-02-04 | No | Oxford, UK | Saskia R. | 310

18 | facebook.com | The Drayman Pub | Friendly locals and cracking roast | 4.3 | Sunday roast with all the trimmings. Portion sizes generous and ales on tap. | £10-£25 | 2026-02-01 | No | Winchester, UK | Mark E. | 49

19 | time-out.com | Modern Mezze | Shareable plates, lively ambience | 4.1 | Great for groups; mezze boards are tasty. Music a bit loud for conversation. | £15-£35 | 2026-02-02 | No | Liverpool, UK | Zara N. | 96

20 | thefork.co.uk | Chez Antoine | Exceptional French cuisine | 4.9 | Perfectly cooked duck and delightful soufflé. Service felt personalised and knowledgeable. | £40-£80 | 2026-02-03 | No | Bath, UK | Eleanor V. | 134

21 | squaremeal.co.uk | Craft & Cork | Impressive wine list | 4.5 | Extensive wine selection and knowledgeable staff. Small plates paired perfectly. | £18-£45 | 2026-02-04 | No | Cambridge, UK | James K. | 85

22 | foodhub.co.uk | Taco Town | Tasty tacos, quick service | 4.0 | Good flavours and affordable. Salsa was fresh but could use more heat. | £6-£14 | 2026-02-02 | Yes | Leicester, UK | Rita P. | 58

23 | tripadvisor.co.uk | The Garden Pantry | Charming café with great salads | 4.6 | Perfect spot for a light lunch. Ingredients tasted fresh and service was cheerful. | £7-£15 | 2026-02-01 | No | York, UK | Hector M. | 77

24 | yelp.co.uk | Wok Street | Fast and flavourful takeaway | 4.2 | Noodles had a good wok char. Portions generous and online ordering simple. | £7-£14 | 2026-02-03 | Yes | Milton Keynes, UK | Fiona L. | 63

25 | just-eat.co.uk | Mama's Kitchen | Home-cooked favourites delivered | 4.4 | Comfort food that tastes homemade. Packaging kept everything warm and intact. | £9-£20 | 2026-02-04 | Yes | Plymouth, UK | Samir D. | 152

26 | deliveroo.co.uk | Piri Piri Palace | Spicy and satisfying chicken | 4.0 | Great flame-grilled flavour. Chips were a bit soggy but overall a solid meal. | £8-£18 | 2026-02-02 | Yes | Swansea, UK | Tara B. | 44

27 | google.com | The Smithfield Brasserie | Reliable classic British menu | 4.3 | Good for groups, large menu and decent value. Sticky toffee pudding was a highlight. | £15-£35 | 2026-02-01 | No | Coventry, UK | Oliver N. | 201

28 | zomato.com | Spice Route | Bold and aromatic dishes | 4.5 | Complex spices and generous portions. Booking recommended on weekends. | £18-£36 | 2026-02-03 | No | Norwich, UK | Leila S. | 98

29 | facebook.com | The Little Deli | Perfect sandwiches and coffee | 4.7 | Warm, friendly staff and outstanding sandwiches. Great spot to work remotely for a bit. | £4-£12 | 2026-02-04 | No | Cheltenham, UK | Ben H. | 173

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