# 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 Harbour Grill | Lovely riverside dinner | 5 | Fantastic steaks and friendly staff. Booking at sunset was perfect — attentive service and prompt drinks. Will return for special occasions. | £35-£60 | 2026-02-02 | No | Bristol, UK | Emma S. | 142

2 | yelp.co.uk | Green Fork Vegan Kitchen | Great plant-based brunch | 4 | Delicious avocado toast and excellent coffee. A bit noisy at peak times but food arrives quickly. Highly recommend waffles. | £8-£18 | 2026-02-03 | Yes | Manchester, UK | Liam P. | 58

3 | just-eat.co.uk | Pasta & Co | Hot and fast delivery | 5 | Penne arrabbiata delivered piping hot, portion sizes generous. Driver friendly and on time. Coupon applied without issues. | £6-£14 | 2026-02-04 | Yes | London, UK | Sofia G. | 211

4 | deliveroo.co.uk | Seaside Tapas Bar | Tasty tapas, quick delivery | 4 | Variety of small plates were authentic and flavourful. The garlic prawns stood out. Packaging kept things intact. | £12-£28 | 2026-02-03 | Yes | Brighton, UK | Owen M. | 87

5 | google.com | Cedar Lebanese | Consistently good mezze | 5 | Fresh ingredients and warm service. The hummus is silky; lamb kofta had great seasoning. Cozy atmosphere for families. | £15-£30 | 2026-02-01 | No | Leeds, UK | Nadia R. | 324

6 | zomato.com | Saffron Spice | Full-flavoured curry dishes | 4 | Spice levels well-balanced and aromatic. Naan a little oily but overall a satisfying meal. Friendly staff at the counter. | £10-£25 | 2026-02-04 | Yes | Birmingham, UK | Arjun K. | 64

7 | facebook.com | The Old Bakery | Charming cafe with great pastries | 5 | Homemade sourdough and pastries are outstanding. Staff remembered our order. Perfect spot for remote work with good wifi. | £3-£12 | 2026-02-02 | No | Oxford, UK | Hannah T. | 198

8 | time-out.com | Skyline Rooftop | Stunning views, mixed food | 3 | Cocktails and view excellent, but mains were overpriced for portion size. Good for drinks rather than dinner. | £20-£50 | 2026-02-03 | No | London, UK | Marcus V. | 45

9 | thefork.co.uk | La Petite Maison | Romantic evening, excellent wine list | 5 | Impeccable service and beautifully presented dishes. Perfect spot for anniversaries; reservations recommended. | £40-£85 | 2026-02-01 | No | Edinburgh, UK | Claire D. | 129

10 | squaremeal.co.uk | Station House Bistro | Reliable pub classics | 4 | Hearty Sunday roast with crispy potatoes. Decent ale selection and family-friendly. Slight wait at peak times. | £12-£28 | 2026-02-02 | No | York, UK | Gareth H. | 76

11 | foodhub.co.uk | The Kebab Shop | Great late-night option | 4 | Generous doner kebab and tasty homemade sauces. Arrived warm; good value for money. Opens late for post-event eats. | £4-£9 | 2026-02-03 | Yes | Newcastle, UK | Imran S. | 53

12 | tripadvisor.co.uk | Fisherman's Catch | Fresh seafood and friendly crew | 5 | Outstanding fish platter and crisp chips. Servers recommended the day’s catch which was perfect. Salt-baked seabass recommended. | £18-£45 | 2026-02-02 | No | Cornwall, UK | Patricia L. | 301

13 | yelp.co.uk | Bao & Broth | Amazing bao buns | 5 | Soft, fluffy bao with bold fillings. Quick counter service and modern interior. Great choice for a casual lunch. | £5-£12 | 2026-02-04 | Yes | Bristol, UK | Daniel K. | 92

14 | just-eat.co.uk | Mumbai Express | Reliable curry and sides | 4 | Flavoursome curry, rice portion generous. Delivery was on time and packaging prevented spills. Would order again. | £7-£20 | 2026-02-03 | Yes | Leicester, UK | Priya N. | 174

15 | deliveroo.co.uk | Sushi Karu | Fresh sushi, neat bento | 5 | Excellent quality fish and clean presentation. Bento boxes kept cold and included wasabi/ginger sachets. Prompt delivery. | £10-£30 | 2026-02-04 | Yes | Cardiff, UK | Tom B. | 142

16 | google.com | The Botanist | Lovely cocktails and atmosphere | 4 | Creative cocktail menu and botanical decor. Food is good though slightly pricey. Great for after-work drinks. | £15-£40 | 2026-02-01 | No | Sheffield, UK | Aisha Y. | 256

17 | zomato.com | Naan Republic | Solid takeout Indian | 4 | Paratha and butter chicken tasted homemade. Sauce a touch sweet for my palate but overall enjoyable. On-time pickup. | £6-£18 | 2026-02-02 | Yes | Coventry, UK | Mohammed R. | 69

18 | facebook.com | Sunny Side Cafe | Brunch favourite | 5 | Perfect eggs benedict and friendly baristas. Bright space and kid-friendly menu. Always busy on weekends. | £6-£15 | 2026-02-03 | No | Cambridge, UK | Lucy F. | 215

19 | time-out.com | Midtown Taproom | Great new craft beers | 4 | Impressive rotating taps and good pub grub. Service was efficient; table booking recommended on Fridays. | £8-£22 | 2026-02-04 | No | Glasgow, UK | Ewan C. | 38

20 | thefork.co.uk | Olive Tree | Authentic Greek flavours | 5 | Exceptional moussaka and fresh tzatziki. Warm welcome from host and excellent wine pairing suggestions. | £20-£45 | 2026-02-02 | No | Brighton, UK | Sofia L. | 114

21 | squaremeal.co.uk | The Screening Room | Good food before the show | 4 | Pre-theatre menu is great value with tasty starters. Service is brisk to accommodate showtimes. | £18-£35 | 2026-02-03 | No | Leeds, UK | Henry W. | 61

22 | foodhub.co.uk | Pizza Alvo | Crispy base, gooey cheese | 5 | Perfect thin crust pizza with generous toppings. Family deal offers excellent value. Driver polite and quick. | £7-£22 | 2026-02-01 | Yes | Southampton, UK | Maya P. | 198

23 | tripadvisor.co.uk | Mountain Lodge | Cosy dinner after hiking | 5 | Hearty stews and friendly service. Great selection of local ales and home-baked desserts. Perfect end to a day out. | £14-£35 | 2026-02-03 | No | Lake District, UK | Robert F. | 256

24 | yelp.co.uk | The Noodle Bar | Comforting ramen | 4 | Rich broth and springy noodles. Portion slightly small for price but flavour makes up for it. Fast table turnover. | £9-£16 | 2026-02-04 | Yes | Bristol, UK | Keiko S. | 73

25 | just-eat.co.uk | Burger Barn | Classic burger done well | 4 | Juicy patties and crisp fries. Milkshakes well-blended. Packaging kept condiments separated which helped presentation. | £5-£15 | 2026-02-02 | Yes | Milton Keynes, UK | Connor J. | 144

26 | deliveroo.co.uk | Falafel House | Great vegetarian options | 5 | Fresh falafel wraps and generous salad. Healthy and satisfying — perfect for lunch. Delivery was under 30 minutes. | £6-£12 | 2026-02-03 | Yes | Nottingham, UK | Zara B. | 88

27 | google.com | Bistro Verdi | Elegant plates, attentive service | 5 | Seasonal menu with well-balanced flavours. Sommelier suggested superb wine pairing. Great for celebrations. | £35-£70 | 2026-02-01 | No | Bath, UK | Oliver N. | 309

28 | zomato.com | The Spice Hut | Family favourite takeaway | 4 | Reliable midweek curry with consistent quality. Rice portion generous and naan freshly baked. | £8-£20 | 2026-02-04 | Yes | Reading, UK | Farah K. | 101

29 | facebook.com | Grain & Greens | Healthy bowls and great juices | 5 | Superfood bowls packed with flavour and texture. Friendly checkout staff and speedy service for lunchtime rush. | £7-£13 | 2026-02-02 | No | Oxford, UK | Becky R. | 162

30 | time-out.com | Late Night Diner | Open late and reliable | 4 | Perfect greasy spoon classics after a night out. Value for money and friendly staff. Seating limited at peak times. | £4-£10 | 2026-02-03 | No | Manchester, UK | Jake L. | 54

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