# 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 Red Lion | Cosy pub with great food | 4.5 | Warm atmosphere, friendly staff and the Sunday roast was perfectly cooked. Dessert menu limited but tasty. Would return. | £10-£25 | 2026-02-03 | No | Bath, UK | Emma J | 38

2 | yelp.co.uk | Saffron Curry House | Excellent flavours, quick service | 4.0 | Spices were well balanced and naan was freshly baked. Service was fast even at peak time. Portion sizes could be larger. | £8-£20 | 2026-02-02 | Yes | Manchester, UK | Liam R | 142

3 | just-eat.co.uk | Bella Pizza | On time and piping hot | 5.0 | Pizza base crisp, lots of toppings. Delivered within 30 minutes. Driver polite. Promo code applied correctly. | £6-£18 | 2026-02-04 | Yes | Leeds, UK | Sophie M | 256

4 | deliveroo.co.uk | Green Fork Salad Bar | Fresh and healthy option | 4.2 | Salads tasted very fresh and dressing on the side was appreciated. Packaging kept leaves crisp. A little pricey. | £5-£12 | 2026-02-03 | Yes | London SW1 | Daniel K | 87

5 | google.com | The Harbour Grill | Great seafood with a view | 4.6 | Fresh fish and attentive service. A bit noisy on weekends but the terrace is lovely. Wine list good value. | £20-£45 | 2026-02-01 | No | Brighton, UK | Olivia P | 319

6 | zomato.com | Urban Tacos | Authentic taste, fun vibe | 4.1 | Tacos had bold flavours and interesting salsas. Margaritas strong. Seating a bit cramped but lively atmosphere. | £7-£22 | 2026-02-02 | Yes | Bristol, UK | Carlos H | 58

7 | facebook.com | La Petite Boulangerie | Lovely pastries and sourdough | 4.8 | Fresh croissants and friendly bakery staff. Coffee excellent. Small venue but perfect for takeaway. | £2-£10 | 2026-02-04 | No | Cambridge, UK | Hannah S | 201

8 | time-out.com | Skyline Rooftop | Stylish bar, pricey cocktails | 3.9 | Views are spectacular, cocktails well made but expensive. Dress code enforced. Good for special occasions. | £12-£30 | 2026-02-01 | No | London EC1 | Alex T | 74

9 | thefork.co.uk | Bistro 84 | Reliable neighbourhood bistro | 4.3 | Menu seasonal and thoughtfully prepared. Staff knowledgeable about wine pairings. Reservation process simple. | £15-£35 | 2026-02-03 | No | Oxford, UK | Maya L | 129

10 | squaremeal.co.uk | The Conservatory | Refined dining, excellent service | 4.7 | Formal setting, creative tasting menu. Service attentive without being intrusive. Worth booking in advance. | £45-£80 | 2026-02-02 | No | Edinburgh, UK | Gordon M | 46

11 | foodhub.co.uk | Chicken Corner | Great value for family meals | 4.0 | Generous portions and consistent quality. Kids loved the dips. Delivery arrived warm and within estimated time. | £5-£20 | 2026-02-04 | Yes | Newcastle, UK | Priya S | 64

12 | tripadvisor.co.uk | The Old Mill | Charming location, slightly slow service | 3.8 | Beautiful setting by the river. Food was good but service lagged during busy lunch. Pricing reasonable for location. | £12-£28 | 2026-01-31 | No | York, UK | Mark B | 210

13 | yelp.co.uk | Pho Central | Comforting bowls of pho | 4.4 | Broth rich and aromatic, generous meat portions. Friendly staff and quick turnover. Would recommend for a warming meal. | £6-£14 | 2026-02-03 | Yes | Leicester, UK | Nisha K | 93

14 | just-eat.co.uk | Curry Express | Reliable takeaway, flavourful curries | 4.2 | Curries packed with flavour and rice fluffy. Packaging secure for delivery. Occasionally runs out of popular dishes. | £7-£18 | 2026-02-02 | Yes | Sheffield, UK | Owen D | 178

15 | deliveroo.co.uk | Vegan Vibes | Creative plant-based dishes | 4.5 | Inventive menu with good textures and satisfying flavours. Delivery kept food intact and warm. Great option for vegans. | £6-£16 | 2026-02-04 | Yes | Bristol, UK | Zara N | 112

16 | google.com | Station Deli | Handmade sandwiches and barista coffee | 4.0 | Fresh ingredients and quick service. Ideal for grab-and-go lunch. Seating limited during rush hour. | £3-£9 | 2026-02-01 | No | Glasgow, UK | Tom H | 58

17 | zomato.com | Ramen Republic | Hearty ramen, rich broth | 4.6 | Broth deep and complex, noodles perfectly cooked. Pork belly tender. Popular spot so expect a short queue. | £9-£18 | 2026-02-03 | No | London N1 | Yuki S | 341

18 | facebook.com | Mamma Rosa | Homely Italian cooking | 4.3 | Pasta al dente and classic tiramisu. Owners greet customers which adds charm. Menu had daily specials. | £10-£28 | 2026-02-02 | Yes | Nottingham, UK | Francesca P | 154

19 | time-out.com | Midnight Bites | Late-night street food done well | 4.0 | Great after-concert spot with gourmet burgers and loaded fries. Queue moves fast and staff friendly. | £4-£12 | 2026-02-03 | No | Birmingham, UK | Kyle W | 39

20 | thefork.co.uk | Olive & Thyme | Romantic spot for two | 4.6 | Intimate setting and delicious seasonal menu. Portion sizes modest but flavours memorable. Great wine pairings. | £30-£60 | 2026-02-04 | No | Winchester, UK | Isabel F | 67

21 | squaremeal.co.uk | Brasserie Lumiere | Consistent quality, business lunch favourite | 4.4 | Efficient for business meals. Starter and mains well executed. Comfortable dining room and quick service. | £18-£40 | 2026-02-02 | No | Cardiff, UK | George P | 88

22 | foodhub.co.uk | Pasta Pronto | Comforting classic pastas | 4.1 | Generous bowls of pasta and friendly delivery. Some dishes were saltier than expected but overall enjoyable. | £6-£16 | 2026-02-03 | Yes | Hull, UK | Lena V | 43

23 | tripadvisor.co.uk | Seafarer's Catch | Fresh catches, great chips | 4.2 | Fish fresh and batter light. Portion generous and staff helpful. Car park can be busy at weekends. | £9-£22 | 2026-02-04 | No | Scarborough, UK | Paul N | 276

24 | yelp.co.uk | Sunflower Bakery | Delicious cakes and friendly bakers | 4.7 | Wide range of cakes and gluten-free options. Staff gave samples. Coffee matched the quality of pastries. | £2-£8 | 2026-02-01 | No | Oxford, UK | Rachel C | 190

25 | just-eat.co.uk | Burger Barn | Solid takeaway burgers | 3.9 | Burgers tasty and delivered hot, but fries soggy this time. Value meal deals good for families. | £5-£15 | 2026-02-04 | Yes | Swansea, UK | Chris L | 134

26 | deliveroo.co.uk | Sushi Studio | Fresh sushi, neat presentation | 4.5 | Sushi rolls neatly packed and tasted fresh. Soy and wasabi portions adequate. Delivery was punctual. | £10-£30 | 2026-02-02 | Yes | London SE10 | Aiko N | 223

27 | google.com | The Roastery | Speciality coffee and relaxed vibe | 4.3 | Excellent single-origin coffees and knowledgeable baristas. Light bites available. Wifi steady for remote work. | £2.5-£12 | 2026-02-03 | No | Exeter, UK | Ben W | 154

28 | zomato.com | Spice Route | Bold and aromatic curries | 4.0 | Good spice balance and a varied vegetarian selection. Service sometimes distracted when busy but food delivers. | £9-£25 | 2026-02-01 | Yes | Liverpool, UK | Asha R | 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
