# 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 Brewery Tap | Great Sunday roast and atmosphere | 4.5 | Lovely roast with generous portions, staff were friendly though service slowed during peak. Cosy interior and good beer selection. | £15-£25 | 2026-02-02 | No | Bath, UK | Sophie M. | 132

2 | yelp.co.uk | Spice Harbor | Bold flavours, small portions | 3.5 | The curries were well seasoned and aromatic, but portions were smaller than expected. Friendly staff and quick service. | £10-£18 | 2026-02-03 | Yes | Manchester, UK | Liam R. | 48

3 | just-eat.co.uk | Bella Pizzeria | Hot and fast - tasty crust | 4.0 | Pizza arrived piping hot and crust had a good char. Toppings plentiful. Delivery was on time and driver courteous. | £8-£16 | 2026-02-04 | Yes | Leeds, UK | Hannah G. | 256

4 | deliveroo.co.uk | Green Spoon Cafe | Fresh salads, superb vegan options | 4.8 | Excellent variety of plant-based dishes, everything tasted fresh and vibrant. Packaging was eco-friendly. | £7-£13 | 2026-02-04 | Yes | Bristol, UK | Aisha K. | 89

5 | google.com | Harbour Lights | Perfect anniversary dinner | 5.0 | Stunning waterfront view and impeccable service. Tasting menu was a highlight — highly recommended for special occasions. | £45-£75 | 2026-02-01 | No | Brighton, UK | Daniel P. | 341

6 | zomato.com | Bao & Brew | Cute spot for quick bites | 4.2 | Steamed bao were fluffy and inventive fillings. Drinks menu good. Can be noisy at lunchtime but worth a visit. | £6-£12 | 2026-02-03 | Yes | London, UK | Maya S. | 154

7 | facebook.com | The Garden Shed | Family-friendly with playground | 4.0 | Nice outdoor area and kids loved the play space. Food was hearty pub fare; portions generous but service a little slow. | £12-£20 | 2026-02-02 | No | Glasgow, UK | Tom H. | 67

8 | time-out.com | Saffron Alley | Trendy spot with rich biryanis | 4.6 | Contemporary setting and the biryani had depth of flavour. Cocktails were enjoyable. Expect a wait on weekends. | £18-£30 | 2026-02-03 | No | Leicester, UK | Priya N. | 210

9 | thefork.co.uk | Maison Luc | French classics executed well | 4.7 | Impeccable service and beautifully plated dishes. Wine pairings were thoughtful. A bit pricey but worth it for a treat. | £30-£60 | 2026-02-01 | No | Oxford, UK | Oliver W. | 178

10 | squaremeal.co.uk | Glasshouse Brasserie | Reliable business lunch option | 4.1 | Efficient service and consistent quality — great for lunchtime meetings. Menu offers several light and hearty options. | £14-£25 | 2026-02-02 | No | Cardiff, UK | Fiona L. | 94

11 | foodhub.co.uk | Curry Corner | Great value takeaway | 4.0 | Spicy, well-cooked dishes and generous portions for the price. Delivery arrived slightly late but still hot. | £6-£13 | 2026-02-04 | Yes | Sheffield, UK | Adam B. | 301

12 | tripadvisor.co.uk | Seaside Grill | Fresh seafood, busy service | 4.3 | Fish and chips were crisp and light, seafood platter good for two. Staff were stretched but polite during a busy evening. | £20-£35 | 2026-02-03 | No | Newcastle, UK | Rachel T. | 219

13 | yelp.co.uk | Urban Dumplings | Best dumplings in town | 4.9 | Perfectly pleated dumplings with punchy dipping sauces. Friendly staff and quick turnover. Small venue but great food. | £5-£11 | 2026-02-04 | Yes | Birmingham, UK | Kevin S. | 412

14 | just-eat.co.uk | Mama Rosa | Authentic pasta at home | 4.4 | Pasta delivered hot with fresh basil and good sauce balance. Garlic bread could be crispier but overall very satisfying. | £8-£16 | 2026-02-02 | Yes | Nottingham, UK | Ella C. | 132

15 | deliveroo.co.uk | Falafel Brothers | Crispy falafel and creamy hummus | 4.5 | Great vegan options and clean flavours. Portions generous and packaging kept everything neat during delivery. | £6-£10 | 2026-02-03 | Yes | London, UK | Omar A. | 223

16 | google.com | The Velvet Room | Stylish bar with inventive cocktails | 4.6 | Cocktails were creative and well balanced. Bar snacks complemented drinks. Music a touch loud for conversation. | £10-£20 | 2026-02-01 | No | Edinburgh, UK | Claire D. | 289

17 | zomato.com | Sushi Nori | Fresh nigiri, attentive chefs | 4.7 | Sushi rice seasoned perfectly and fish tasted fresh. Intimate dining with skilled chefs preparing orders to spec. | £20-£40 | 2026-02-04 | Yes | Manchester, UK | Kenji T. | 165

18 | facebook.com | Poppy's Brunch Bar | Sunday brunch favourite | 4.3 | Great coffee and inventive brunch dishes. Long waits on Sundays but atmosphere is lively and fun. | £9-£18 | 2026-02-02 | No | Bristol, UK | Nina V. | 98

19 | time-out.com | La Cantina Moderna | Modern tapas with a twist | 4.4 | Small plates designed to share, interesting flavour combinations and a lively vibe. Book in advance on weekends. | £20-£35 | 2026-02-03 | No | Liverpool, UK | Marco R. | 143

20 | thefork.co.uk | The Harbour Table | Seafood tasting impressed | 4.8 | Seasonal seafood prepared with care. Dessert selection rounded off the meal perfectly. Friendly sommelier recommendations. | £40-£70 | 2026-02-01 | No | Plymouth, UK | Sian E. | 201

21 | squaremeal.co.uk | The Oak Room | Refined dining, quiet evening | 4.2 | Elegant setting and attentive staff. Food was well executed though portions small for the price point. | £28-£50 | 2026-02-02 | No | Cambridge, UK | Henry B. | 76

22 | foodhub.co.uk | The Pie Stop | Comfort food delivered | 4.1 | Pies were hearty and flaky, mash creamy. Packaging kept gravies separate which helped. Great comfort takeaway. | £6-£12 | 2026-02-04 | Yes | Stoke-on-Trent, UK | Rachel F. | 59

23 | tripadvisor.co.uk | Mountain View Inn | Cosy pub with great views | 4.6 | Location is stunning and food was warming after a long walk. Beer selection strong and staff very welcoming. | £12-£22 | 2026-02-03 | No | Lake District, UK | Oliver J. | 186

24 | yelp.co.uk | Tandoori Nights | Rich flavours but oily | 3.8 | Flavours authentic and aromatic, though some dishes were greasier than expected. Friendly staff and decent portion sizes. | £10-£20 | 2026-02-01 | Yes | Southampton, UK | Amina H. | 64

25 | just-eat.co.uk | Chop & Noodle | Family favourite for takeout | 4.2 | Classic dishes hit the mark, kids loved the noodles. Generous portions and sauces well balanced. | £7-£14 | 2026-02-02 | Yes | Derby, UK | Graham P. | 278

26 | deliveroo.co.uk | Roast & Co. | Sunday classics, delivered well | 4.0 | Roast dinner tasted homemade and arrived warm. Yorkshire puds retained shape despite delivery — impressive. | £10-£18 | 2026-02-03 | Yes | Norwich, UK | Lucy M. | 121

27 | google.com | Bistro Lumiere | Intimate bistro with seasonal menu | 4.5 | Menu changes frequently and highlights local produce. Portion sizes modest but flavours are memorable. | £25-£45 | 2026-02-04 | No | York, UK | Ethan C. | 199

28 | zomato.com | Kebab King | Late-night go-to | 3.9 | Perfect for late cravings — juicy doner and good sauces. Not fine dining but consistent and convenient. | £4-£9 | 2026-02-02 | Yes | Birmingham, UK | Samir V. | 412

29 | facebook.com | The Lantern | Date night turned memorable | 4.7 | Soft lighting and thoughtful menu choices. Staff helped with wine selection and service was unobtrusive. | £35-£60 | 2026-02-01 | No | Winchester, UK | Becky R. | 258

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