# 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 | Excellent Sunday roast | 5 | Fantastic roast with perfectly crisp potatoes. Friendly service and cosy atmosphere. Will return. | £15-£30 | 2026-02-02 | No | Birmingham, UK | Olivia M. | 42

2 | yelp.co.uk | Riverside Tapas | Lovely small plates, great vibe | 4 | Tapas were fresh and well-seasoned. Drinks a bit pricey but worth it for the riverside view. | £8-£25 | 2026-02-03 | No | Manchester, UK | Daniel R. | 18

3 | just-eat.co.uk | Mama Rosa Pizza | Quick delivery, tasty pizza | 4 | Margherita was classic and arrived hot. Garlic bread soggy from steam but overall good value for delivery. | £6-£18 | 2026-02-04 | Yes | Leeds, UK | Sophie L. | 129

4 | deliveroo.co.uk | Green Bowl Salad Bar | Fresh and fast | 5 | Salad was crisp, dressing on side was appreciated. Delivered within 25 minutes. Perfect for lunch. | £5-£12 | 2026-02-04 | Yes | London, UK | Amit K. | 64

5 | google.com | The Copper Kettle | Charming café with great scones | 4 | Warm service, scones were buttery. Coffee slightly weak but overall a pleasant stop. | £4-£10 | 2026-02-01 | No | Brighton, UK | Hannah P. | 237

6 | zomato.com | Saffron Spices | Authentic flavours, generous portions | 5 | Curry packed with flavour; staff helpful with spice levels. Rice portion could be larger. | £10-£22 | 2026-02-03 | Yes | Bristol, UK | Karan S. | 87

7 | facebook.com | Blue Anchor Bistro | Perfect anniversary dinner | 5 | Set menu was excellent, surprise dessert made the evening special. Staff attentive all night. | £25-£60 | 2026-02-02 | No | Oxford, UK | Emma & James | 15

8 | time-out.com | Neon Noodles | Fun late-night noodles | 4 | Bold flavours and neon décor. Portions ideal for sharing. Slight wait but worth it. | £7-£14 | 2026-02-03 | No | Leeds, UK | Harper T. | 9

9 | thefork.co.uk | Harbour View Grill | Great steak, harbour views | 5 | Steak cooked exactly as ordered; sides delicious. Booking via app seamless. | £20-£45 | 2026-02-01 | No | Portsmouth, UK | Liam G. | 56

10 | squaremeal.co.uk | Olive & Oak | Stylish spot for sharing plates | 4 | Creative menu and solid wine list. Service a touch slow on busy night. | £18-£40 | 2026-02-02 | No | Manchester, UK | Rachel V. | 34

11 | foodhub.co.uk | Curry Corner | Reliable takeout favourites | 4 | Good spiced dishes, generous sauces. Packaging kept food intact for takeaway. | £7-£20 | 2026-02-04 | Yes | Newcastle, UK | Owen H. | 72

12 | tripadvisor.co.uk | Station House Café | Friendly local café | 4 | Breakfast options plentiful and service friendly. Eggs could be cooked firmer to suit preference. | £3-£12 | 2026-02-03 | No | Cambridge, UK | Maya S. | 51

13 | yelp.co.uk | Skyline Rooftop | Great cocktails, stunning view | 5 | Service efficient despite busy evening. Cocktails expertly balanced; booking recommended. | £10-£30 | 2026-02-01 | No | London, UK | Chris N. | 94

14 | just-eat.co.uk | Bento Express | Consistent sushi delivery | 5 | Rolls fresh and well-packed. Soy and wasabi included. Fast courier. | £6-£22 | 2026-02-04 | Yes | Birmingham, UK | Yuki A. | 210

15 | deliveroo.co.uk | The Vegan Table | Delicious plant-based comfort food | 5 | Hearty portions and rich flavours. Delivery arrived warm and bags eco-friendly. | £8-£18 | 2026-02-02 | Yes | Leeds, UK | Nia W. | 38

16 | google.com | Old Mill Inn | Cosy pub with good ales | 4 | Selection of local ales and a welcoming atmosphere. Food decent pub fare. | £10-£25 | 2026-02-03 | No | York, UK | Gareth P. | 146

17 | zomato.com | Pho House | Warm broth on a cold day | 5 | Pho rich and aromatic, noodles perfectly cooked. Quick table turnover but friendly staff. | £8-£14 | 2026-02-02 | Yes | Leicester, UK | Minh T. | 61

18 | facebook.com | Copper & Rye | Brunch hit with the family | 4 | Kids menu big hit. Brunch cocktails strong. Parking limited nearby. | £12-£28 | 2026-02-01 | No | Guildford, UK | Sasha R. | 27

19 | time-out.com | Burger Lab | Top-notch gourmet burger | 5 | Creative toppings and juicy patties. Fries crisp. Expect a queue at peak times. | £9-£16 | 2026-02-04 | No | Bristol, UK | Ethan B. | 112

20 | thefork.co.uk | La Petite Table | Intimate fine dining | 5 | Tasting menu was exceptional, wine pairing very well chosen. Reservation recommended. | £45-£95 | 2026-02-02 | No | Edinburgh, UK | Claire D. | 63

21 | squaremeal.co.uk | Market Street Deli | Great sandwiches and coffee | 4 | Fresh ingredients and speedy service. Coffee hit the mark for takeaway. | £4-£9 | 2026-02-03 | No | Sheffield, UK | Ben K. | 40

22 | foodhub.co.uk | Sizzle & Smoke | BBQ feast delivered hot | 5 | Smoky flavours and generous sides. Delivery packaging impressive to retain heat. | £12-£35 | 2026-02-04 | Yes | Nottingham, UK | Leah F. | 95

23 | tripadvisor.co.uk | The Lanes Bistro | Weekend treat | 4 | Great small plates and friendly service. Slightly noisy on Saturday night. | £15-£35 | 2026-02-01 | No | Brighton, UK | Tom S. | 78

24 | yelp.co.uk | Spice Route | Vibrant flavours, friendly staff | 5 | Excellent spice balance and fast service. Dessert was a highlight. | £11-£26 | 2026-02-03 | Yes | Coventry, UK | Priya M. | 36

25 | just-eat.co.uk | Café Van Gogh | Lovely pastries, quick pickup | 4 | Croissants buttery and flaky. Pickup queue moved quickly. Coffee good. | £2-£8 | 2026-02-02 | No | Cambridge, UK | Ethan L. | 54

26 | deliveroo.co.uk | Mama's Kitchen | Comfort food delivered | 4 | Hearty portions, perfect for a cold evening. Chips a bit greasy but overall satisfying. | £7-£20 | 2026-02-04 | Yes | Liverpool, UK | Zara H. | 148

27 | google.com | Sunset Sushi | Reliable sushi spot | 5 | Fresh fish and neat presentation. Staff polite and helpful with special requests. | £10-£30 | 2026-02-03 | Yes | Glasgow, UK | Ian M. | 182

28 | zomato.com | Pasta Fresca | Handmade pasta heaven | 5 | Pasta had a great bite and sauce was balanced. Cozy atmosphere and charming owner. | £12-£28 | 2026-02-02 | No | Bath, UK | Laura G. | 69

29 | facebook.com | The Alley Cat | Live music and good food | 4 | Music added to ambience; mains solid and well-seasoned. Could improve dessert options. | £12-£30 | 2026-02-01 | No | Bournemouth, UK | Marcus W. | 21

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