# 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 Old Mill Tavern | Great pub grub and atmosphere | 4.0 | Visited for Sunday roast — excellent portions, crisp roast potatoes and friendly staff. Slightly noisy but that adds to the charm. Would return. | £10-£25 | 2026-02-02 | No | Sheffield, UK | Anna M | 42

2 | yelp.co.uk | Miso & Matcha | Lovely sushi, fresh fish | 4.5 | Beautiful presentation and melt-in-the-mouth nigiri. Service was efficient. A little pricey for portion sizes but worth it for a treat. | £15-£35 | 2026-02-03 | Yes | Manchester, UK | Samir K | 128

3 | just-eat.co.uk | Pizza Pronto | Hot and on time | 4.0 | Ordered Margherita and Calabrese, arrived hot and packaging was secure. Base could be crispier but overall tasty and good value for delivery. | £6-£18 | 2026-02-04 | Yes | Bristol, UK | L. Thompson | 256

4 | deliveroo.co.uk | Sunflower Vegan Kitchen | Fantastic vegan options | 5.0 | Amazing flavours, creative dishes and generous portions. The jackfruit tacos were a highlight. Delivery was quick and still warm. | £8-£20 | 2026-02-04 | Yes | London, UK | Rachel P | 89

5 | google.com | Côte Rivièra | Romantic spot with great wine list | 4.0 | Excellent wine selection and intimate setting. Small issues with wait time between courses but food was high quality. | £25-£50 | 2026-01-31 | No | Edinburgh, UK | David L | 314

6 | zomato.com | Spice Route Curry House | Classic flavours, generous portions | 4.0 | Tried the lamb rogan josh and garlic naan. Very well spiced and aromatic. Service could be friendlier but solid meal. | £10-£22 | 2026-02-02 | Yes | Leeds, UK | Priya S | 67

7 | facebook.com | Harbour Lights Cafe | Lovely breakfast by the pier | 4.5 | Great full English with sea views. Staff welcomed our dog and provided water bowl. Coffee was excellent. | £6-£14 | 2026-02-03 | No | Brighton, UK | Evan J | 54

8 | time-out.com | Bistro Nouveau | Trendy bistro with seasonal menu | 4.0 | Creative seasonal dishes and modern interior. Portions a bit small for the price but flavours were interesting. | £20-£40 | 2026-02-01 | No | Birmingham, UK | Olivia H | 190

9 | thefork.co.uk | La Trattoria Roma | Authentic Italian, lovely tiramisu | 4.5 | Warm atmosphere and classic pasta dishes done well. Tiramisu was light and not overly sweet. Good value on weekday menu. | £12-£30 | 2026-02-04 | No | Covent Garden, London | Marco D | 143

10 | squaremeal.co.uk | The Conservatory | Business lunch hit | 4.0 | Reliable set menu for corporate lunches. Efficient service and quiet environment conducive to meetings. | £18-£30 | 2026-02-02 | No | Canary Wharf, London | Helen R | 78

11 | foodhub.co.uk | Kebab King | Tasty late-night kebab | 3.5 | Good for a late-night bite — generous meat and fresh salad. Bread slightly doughy but overall satisfying. | £4-£9 | 2026-02-03 | Yes | Newcastle, UK | Omar N | 36

12 | tripadvisor.co.uk | Seaside Fish Bar | Classic fish and chips | 4.0 | Crispy batter, fluffy chips and friendly staff. Long queue on weekend but turnover is quick. | £8-£18 | 2026-02-01 | No | Blackpool, UK | Grace W | 210

13 | yelp.co.uk | The Spice Bazaar | Bold flavours, fun cocktails | 4.5 | Great tapas-style menu with punchy spices and inventive cocktails. Lively atmosphere for groups. | £20-£45 | 2026-02-03 | No | Nottingham, UK | Ben C | 97

14 | just-eat.co.uk | Curry Corner | Reliable takeaway favourites | 4.0 | Always consistent — good curries and friendly delivery drivers. Could add more vegetarian mains. | £7-£20 | 2026-02-04 | Yes | Liverpool, UK | Fiona G | 312

15 | deliveroo.co.uk | Bao & Bun | Soft buns and punchy sauces | 4.5 | Genuine Taiwanese bao, fluffy buns and bold fillings. Arrived warm and well-packed for delivery. | £6-£16 | 2026-02-04 | Yes | Bristol, UK | Tom S | 156

16 | google.com | The Green Fork | Healthy bowls and friendly staff | 4.0 | Great selection of nutrient-packed bowls and smoothies. Portions are modest but fresh ingredients. | £7-£14 | 2026-02-02 | Yes | Oxford, UK | Maya L | 62

17 | zomato.com | El Toro Tapas | Authentic tapas and sangria | 4.0 | Wide tapas menu and lively service. Sangria was refreshing; recommend booking at weekends. | £12-£28 | 2026-02-01 | No | Cambridge, UK | Alejandro P | 121

18 | facebook.com | Cornerstone Bakery | Best sourdough in town | 5.0 | Beautiful crust, airy crumb and friendly barista. The almond croissant is addictive. | £2-£8 | 2026-02-03 | No | St Albans, UK | Hannah S | 204

19 | time-out.com | Noodle House | Comforting ramen bowls | 4.5 | Rich broth and tender chashu. Generous toppings and quick service. Great winter meal. | £10-£18 | 2026-02-02 | Yes | Leicester, UK | Chris Y | 134

20 | thefork.co.uk | Garde Manger | Excellent tasting menu | 5.0 | Exceptional multi-course tasting menu with thoughtful wine pairings. Flawless execution and service. | £60-£95 | 2026-01-31 | No | Bath, UK | Sophie N | 48

21 | squaremeal.co.uk | The Brass Lantern | Solid gastropub | 4.0 | Well-cooked mains and good selection of ales. Family-friendly and decent value on Sunday roast. | £12-£28 | 2026-02-03 | No | Bournemouth, UK | Martin K | 88

22 | foodhub.co.uk | Sushi Express | Good sushi combos for lunch | 4.0 | Fresh fish and quick delivery. Portion sizes suitable for lunch; add-on miso soup was good value. | £6-£15 | 2026-02-04 | Yes | Guildford, UK | Emily Z | 59

23 | tripadvisor.co.uk | Highland Steakhouse | Quality steaks, cosy interior | 4.5 | Perfectly cooked rib-eye and friendly sommelier. Slight wait for table but worth it for the meat quality. | £30-£60 | 2026-02-02 | No | Aberdeen, UK | Gordon F | 275

24 | yelp.co.uk | The Flower Pot Cafe | Charming cafe with great brunch | 4.5 | Fantastic eggs Benedict and warmly decorated space. Staff attentive and happy to accommodate allergies. | £7-£16 | 2026-02-03 | No | Winchester, UK | Liza T | 71

25 | just-eat.co.uk | Thai Taste | Spicy and authentic takeaway | 4.0 | Good balance of heat and flavour. Rice portion generous. Packaging kept food separate and intact. | £8-£20 | 2026-02-04 | Yes | Hull, UK | Nikhil R | 144

26 | deliveroo.co.uk | Pasta Fresca | Homemade pasta delivered well | 4.5 | Freshly made pasta and rich sauces. Delivery was punctual and temperature was perfect on arrival. | £9-£22 | 2026-02-04 | Yes | Bristol, UK | Caroline M | 101

27 | google.com | The Pavilion | Nice place for afternoon tea | 4.0 | Lovely selection of sandwiches and scones. Tea selection extensive; service a touch slow on busy days. | £15-£30 | 2026-02-01 | No | York, UK | Benita O | 220

28 | zomato.com | Grill & Barrel | Good burgers and craft beers | 4.0 | Burgers cooked to order with inventive toppings. Beer list varied. Noise level high during matches. | £11-£25 | 2026-02-02 | No | Swansea, UK | Jordan P | 132

29 | facebook.com | Poppy's Diner | Retro vibes and hearty portions | 4.5 | Great milkshakes and generous breakfasts. Friendly staff and nostalgic decor make it fun. | £5-£14 | 2026-02-03 | No | Blackburn, UK | Phoebe A | 65

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