# 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 atmosphere, great cocktails | 4.5 | Cosy interior, attentive staff and inventive cocktails. Small plates were delicious though a touch pricey. Would return for a date night. | £25-£45 | 2026-02-02 | No | Bristol, BS1 | Olivia H. | 68

2 | yelp.co.uk | North Street Deli | Quick lunch, fresh ingredients | 4.0 | Sandwiches made to order, generous fillings and speedy service. Seating is limited but perfect for a lunchtime bite. | £6-£12 | 2026-02-03 | No | Manchester, M1 | Samir P. | 142

3 | just-eat.co.uk | Mumbai Express | Spicy and satisfying curry | 4.0 | Delivery arrived hot and on time. Butter chicken was rich and flavourful; naan a little chewy. Reasonable portions. | £10-£20 | 2026-02-04 | Yes | Leicester, LE1 | Hannah T. | 284

4 | deliveroo.co.uk | Bella Pasta | Authentic pasta, fast delivery | 4.2 | Tagliatelle al ragù tasted homemade. Packaging kept everything intact and warm. Would like more salad on the side. | £8-£18 | 2026-02-04 | Yes | London, WC2 | Marcus L. | 512

5 | google.com | The Harbour Bistro | Stunning seaside views | 4.7 | Perfect for a special occasion. Fresh seafood and friendly sommelier. Prices reflect the view but worth it for the experience. | £30-£60 | 2026-02-01 | No | Brighton, BN1 | Claire S. | 391

6 | zomato.com | Green Spoon Vegan | Tasty vegan comfort food | 4.3 | Wide menu of creative vegan dishes. Burger was juicy and fries seasoned well. Dessert selection impressive. | £10-£22 | 2026-02-02 | Yes | Birmingham, B3 | Aiden K. | 223

7 | facebook.com | The Local Tap | Great beer selection | 4.6 | Huge variety of craft beers and friendly bartenders. Live music on weekends adds to the vibe. | £5-£20 | 2026-02-03 | No | Leeds, LS1 | Rachel M. | 157

8 | time-out.com | Skyline Rooftop | Breathtaking skyline, pricey menu | 4.1 | Cocktails are excellent and the view unbeatable. Small portions for price so better for drinks than dinner. | £20-£50 | 2026-02-02 | No | London, EC2 | Tom W. | 89

9 | thefork.co.uk | Maison de Pierre | Exceptional tasting menu | 4.8 | Flawless service and creative courses. Wine pairings elevated the experience. Book well in advance. | £55-£95 | 2026-02-01 | No | Edinburgh, EH1 | Isabella R. | 76

10 | squaremeal.co.uk | Brasserie Lumière | Reliable French classics | 4.0 | Solid boeuf bourguignon and attentive staff. Not groundbreaking but consistently good. | £25-£40 | 2026-02-03 | No | Oxford, OX1 | Daniel F. | 132

11 | foodhub.co.uk | Pizza Canal | Huge pizza, family favourite | 4.4 | Generous toppings and thin crust. Delivery driver was friendly and quick. Great for family nights. | £9-£20 | 2026-02-04 | Yes | Southampton, SO15 | Leah G. | 201

12 | tripadvisor.co.uk | The Anchor Inn | Traditional pub, great Sunday roast | 4.5 | Perfect roast with crisp potatoes and rich gravy. Cosy fireplace and helpful staff made the afternoon special. | £12-£25 | 2026-02-02 | No | York, YO1 | Peter B. | 248

13 | yelp.co.uk | Saffron Lounge | Flavours packed in every bite | 4.7 | Elegant setting and subtle spice blends. Portions well balanced and service polished. | £18-£35 | 2026-02-03 | No | Nottingham, NG1 | Maya V. | 95

14 | just-eat.co.uk | Fish & Fry Takeaway | Classic fish and chips | 3.9 | Battered fish was crispy but a bit greasy. Chips were solid, came with mushy peas. Fast delivery. | £7-£14 | 2026-02-04 | Yes | Newcastle, NE1 | Jordan C. | 67

15 | deliveroo.co.uk | Sushi Wave | Fresh sashimi, neat presentation | 4.6 | Beautifully cut sashimi and delicate nigiri. Packaging secure for delivery; soy and wasabi included. | £12-£30 | 2026-02-04 | Yes | Cambridge, CB2 | Aya N. | 359

16 | google.com | Cedar & Stone | Comfort food with a twist | 4.2 | Creative dishes inspired by British classics. Friendly staff, slightly slow on a busy night. | £15-£30 | 2026-02-02 | No | Bath, BA1 | Liam H. | 84

17 | zomato.com | La Taquería | Authentic tacos and vibrant salsas | 4.5 | Corn tortillas, smoky meats and punchy sauces. Great casual spot for a group. | £8-£18 | 2026-02-03 | Yes | Liverpool, L1 | Sofia R. | 176

18 | facebook.com | The Old Bakery | Charming brunch spot | 4.3 | Lovely decor and excellent coffee. Avocado toast generous but slightly overpriced for location. | £7-£15 | 2026-02-01 | No | Norwich, NR1 | Ethan J. | 58

19 | time-out.com | Midtown Grill | Solid steaks, buzzing atmosphere | 4.4 | Well cooked steaks and large sides. Busy on weekends; reservation recommended. | £25-£50 | 2026-02-03 | No | Glasgow, G1 | Fiona K. | 210

20 | thefork.co.uk | Olive & Thyme | Romantic and refined | 4.6 | Intimate restaurant with inventive Mediterranean dishes. Staff recommended excellent wine. | £30-£55 | 2026-02-02 | No | Guildford, GU1 | Marco S. | 64

21 | squaremeal.co.uk | The Spice Room | Bold flavours, attentive service | 4.1 | Curries full of depth and spices; rice a little dry. Service compensated with helpful suggestions. | £12-£28 | 2026-02-04 | No | Reading, RG1 | Nora P. | 145

22 | foodhub.co.uk | Burger Barn | Juicy burgers, great value | 4.0 | Tasty patties and crunchy buns. Sweet potato fries a highlight. Quick delivery option available. | £6-£14 | 2026-02-04 | Yes | Milton Keynes, MK9 | Connor D. | 324

23 | tripadvisor.co.uk | The Lavender Tea Room | Quaint spot for afternoon tea | 4.5 | Delicate sandwiches and fresh scones. Service charming though the tea selection could be broader. | £18-£32 | 2026-02-01 | No | Canterbury, CT1 | Beatrice L. | 47

24 | yelp.co.uk | Pho Real | Comforting pho, fragrant broth | 4.4 | Broth simmered for hours with generous herb plate. Portions large and warming on a cold day. | £8-£16 | 2026-02-03 | Yes | Cardiff, CF10 | Dylan M. | 198

25 | just-eat.co.uk | Kebab King | Late-night lifesaver | 3.8 | Meat was properly seasoned but bread a bit soggy from sauce. Quick delivery and friendly driver. | £5-£12 | 2026-02-04 | Yes | Sunderland, SR1 | Fatima Z. | 89

26 | deliveroo.co.uk | Plant Plate | Excellent plant-based bowls | 4.5 | Colourful bowls packed with grains and roasted veg. Great meal prep option with healthy portions. | £9-£17 | 2026-02-04 | Yes | Leicester, LE2 | Grace Y. | 260

27 | google.com | Seasons Brasserie | Seasonal produce shines | 4.3 | Menu changes often with great local produce. Dessert menu was outstanding. | £20-£40 | 2026-02-02 | No | Exeter, EX1 | Oliver N. | 103

28 | zomato.com | Curry Corner | Reliable takeout classics | 4.0 | Tandoori chicken had great char, rice fluffy. Packaging kept flavours intact for delivery. | £10-£22 | 2026-02-03 | Yes | Plymouth, PL1 | Neha S. | 214

29 | facebook.com | The Birdhouse Café | Friendly staff and hearty breakfasts | 4.2 | Full English done well and excellent filter coffee. Busy mornings but turnover quick. | £6-£12 | 2026-02-01 | No | Newport, NP20 | Harry E. | 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