# 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 Fox & Finch | Charming local with great pub food | 4.0 | Friendly staff, cosy atmosphere and the burger was cooked perfectly. Sunday roast portions generous. A bit noisy on weekend evenings but overall excellent value. | £10-£25 | 2026-02-03 | No | Bristol, BS8 | Emma R. | 142

2 | yelp.co.uk | Cielo Tapas Bar | Authentic tapas, busy but worth it | 4.5 | Small plates packed with flavour. Service was attentive despite a full house. Recommend the patatas bravas and chorizo. | £15-£35 | 2026-02-02 | No | Manchester M1 | Liam K. | 58

3 | just-eat.co.uk | Mama Mia Pizzeria | Great takeaway, arrived hot | 4.2 | Ordered a family pizza and garlic bread. Good crust and cheese, driver polite. Packaging was secure. | £8-£25 | 2026-02-01 | Yes | Leeds LS6 | Sophie N. | 321

4 | deliveroo.co.uk | Green Bowl Salad Co. | Fresh bowls, fast delivery | 4.8 | Salads tasted very fresh and vibrant. Avocado perfectly ripe. Delivery under 25 minutes as promised. | £6-£12 | 2026-02-04 | Yes | London SW1 | Omar H. | 204

5 | google.com | The Harbour Grill | Seafood excellence | 4.6 | Excellent grilled seabass and scallops. Pleasant view of the marina. Slightly pricey but portions justify it. | £25-£50 | 2026-02-03 | No | Brighton BN1 | Ava P. | 478

6 | zomato.com | Spice Route | Bold flavours, great for groups | 4.1 | Rich curries and generous naan. Service improved since last visit. Some dishes a touch oily. | £12-£30 | 2026-02-02 | Yes | Birmingham B4 | Rohit S. | 132

7 | facebook.com | The Old Orchard Café | Perfect brunch spot | 4.4 | Lovely eggs Benedict and friendly barista. Outdoor seating pleasant on sunny days. Busy Saturdays. | £7-£18 | 2026-02-04 | No | Cambridge CB2 | Hannah T. | 89

8 | time-out.com | Neon Sushi | Stylish sushi, inventive menu | 4.7 | Beautiful presentation and creative rolls. Fresh fish and interesting cocktails. Booking recommended. | £20-£45 | 2026-02-01 | No | London EC1 | Marcus L. | 256

9 | thefork.co.uk | Maison Rouge | Elegant dining, attentive staff | 4.3 | Three-course set menu was well curated. Wine pairing suggested by sommelier was a highlight. | £30-£60 | 2026-02-02 | No | Oxford OX1 | Claire B. | 176

10 | squaremeal.co.uk | Bamboo House | Reliable Chinese favourites | 3.9 | Good value and quick service. Some dishes lacked the depth of flavour we expected but overall decent for group dinners. | £10-£25 | 2026-02-03 | Yes | Leicester LE1 | Daniel W. | 64

11 | foodhub.co.uk | Pizza Republic | Family pizza deal excellent | 4.0 | Large pizza, generous toppings and free sides with promo. Delivery slightly delayed but food still warm. | £7-£20 | 2026-02-04 | Yes | Newcastle NE1 | Maya G. | 98

12 | tripadvisor.co.uk | Seasons Brasserie | Relaxed atmosphere, seasonal menu | 4.2 | Ingredients felt seasonal and fresh. Service friendly, desserts were the standout. | £18-£40 | 2026-01-31 | No | Bath BA1 | Peter J. | 211

13 | yelp.co.uk | The Copper Kettle | Cosy café with great pastries | 4.6 | Home-baked pastries and excellent coffee. Staff remembered regulars which felt welcoming. | £3-£12 | 2026-02-02 | No | Edinburgh EH2 | Fiona M. | 147

14 | just-eat.co.uk | Curry Corner | Spicy and satisfying | 4.3 | Good balance of heat and flavour. Rice perfectly cooked. Portion sizes generous for the price. | £6-£18 | 2026-02-03 | Yes | Wolverhampton WV1 | Aisha K. | 289

15 | deliveroo.co.uk | Wrap & Roll | Tasty wraps, lots of options | 4.5 | Wide choice of fillings and sauces. Healthy options available and fast delivery to the office. | £5-£10 | 2026-02-04 | Yes | Birmingham B2 | George P. | 156

16 | google.com | La Belle Bistro | Romantic spot for dinner | 4.4 | Intimate atmosphere and excellent duck confit. Reservation advised on weekends. | £22-£48 | 2026-02-02 | No | York YO1 | Natalie S. | 399

17 | zomato.com | Burger Lab | Creative burgers, decent sides | 4.0 | Unique toppings and house sauces. Fries a little over-salted but overall enjoyable meal. | £8-£16 | 2026-02-01 | Yes | Sheffield S1 | Tom H. | 210

18 | facebook.com | The Green Gecko | Vegan-friendly and vibrant | 4.7 | Excellent plant-based dishes with bold flavours. Staff happy to adapt dishes for allergies. | £9-£22 | 2026-02-03 | Yes | Brighton BN2 | Leah C. | 134

19 | time-out.com | Skyline Rooftop | Amazing views, cocktails top notch | 4.5 | Cocktail menu inventive and the view across the city is stunning at sunset. Small plates good for sharing. | £15-£45 | 2026-02-04 | No | Belfast BT1 | Connor D. | 312

20 | thefork.co.uk | Le Petit Marche | Charming French bistro | 4.1 | Classic French dishes done well. Service polite though a little slow during rush hour. | £18-£35 | 2026-02-02 | No | Cambridge CB1 | Isabelle R. | 87

21 | squaremeal.co.uk | The Station House | Great for business lunches | 4.0 | Quiet dining area and efficient service. Set lunch menu represents good value. | £12-£28 | 2026-02-03 | No | Reading RG1 | Alan S. | 64

22 | foodhub.co.uk | Saffron Express | Reliable Indian takeaway | 4.2 | Consistent flavours and prompt delivery. Packaging keeps food warm and separate. | £7-£20 | 2026-02-01 | Yes | Portsmouth PO1 | Nadia P. | 176

23 | tripadvisor.co.uk | The Lantern | Homely food in a quiet lane | 4.3 | Comforting mains and friendly service. Nice selection of local ales. | £11-£26 | 2026-02-02 | No | Exeter EX4 | Chris M. | 98

24 | yelp.co.uk | Kebab King | Late-night lifesaver | 3.8 | Open late with generous portions. Meat well-seasoned though some pieces a bit fatty. | £4-£9 | 2026-02-04 | Yes | Liverpool L1 | Zoe A. | 223

25 | just-eat.co.uk | Sweet & Savoury Desserts | Decadent cakes, reliable delivery | 4.6 | Birthday cake arrived intact and tasted delicious. Great communication from the shop. | £3-£30 | 2026-02-03 | Yes | Norwich NR1 | Janet L. | 54

26 | deliveroo.co.uk | Noodle House | Comforting soups and stir-fries | 4.4 | Broth was rich and aromatic. Portion sizes generous for solo diners. Delivery on time. | £6-£14 | 2026-02-02 | Yes | Coventry CV1 | Ravi M. | 187

27 | google.com | The Garden Table | Healthy, seasonal and bright | 4.5 | Plenty of vegetarian options and the superfood bowl was excellent. Pleasant staff and quick service. | £8-£20 | 2026-02-01 | No | Glasgow G1 | Fiona L. | 268

28 | zomato.com | La Taqueria | Tasty tacos with punchy salsas | 4.3 | Good range of fillings and fresh tortillas. Salsa selection had real heat and flavour. | £6-£14 | 2026-02-04 | Yes | Bristol BS1 | Miguel V. | 143

29 | facebook.com | The Coal Shed | Steaks cooked to perfection | 4.6 | Fantastic steaks and a solid wine list. Service knowledgeable and friendly. Book ahead for weekend slots. | £30-£70 | 2026-02-03 | No | Bournemouth BH2 | Samantha K. | 401

30 | time-out.com | Factory Coffee Roasters | Best coffee in town | 4.8 | Exceptional single-origin brews and friendly baristas. Light bites complement the coffee well. | £2.5-£10 | 2026-02-02 | No | Oxford OX2 | Ethan V. | 321

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