# 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 Copper Kettle | Cosy evening, great service | 4.5 | Lovely cosy pub atmosphere, friendly staff and a solid steak pie. Portions generous and real ale was on point. Could improve dessert options. | £15-£30 | 2026-02-02 | No | Bristol, UK | Hannah M. | 42

2 | yelp.co.uk | Saffron Spice | Authentic flavours, quick service | 4.0 | Great curry, well spiced and fragrant rice. Service was efficient for a busy Friday night. A bit noisy but expected. Will return. | £10-£25 | 2026-02-03 | Yes | Manchester, UK | Ali R. | 128

3 | just-eat.co.uk | Bella Pizzeria | Fast delivery but pizza slightly soggy | 3.5 | Ordered Margherita and Diavola. Arrived warm and fast, base was a little soggy near toppings. Tasty but not as crisp as dining in. | £8-£20 | 2026-02-04 | Yes | Leeds, UK | Sophie L. | 56

4 | deliveroo.co.uk | Green Fork Vegan | Fresh and vibrant bowls | 5.0 | Excellent plant-based bowls, bright flavours and generous portions. Packaging kept everything intact for delivery. Highly recommend. | £9-£18 | 2026-02-03 | Yes | London, UK | Tom B. | 342

5 | google.com | Harbour Lights | Stunning waterfront brunch | 4.7 | Beautiful views and great brunch menu. Eggs Benedict perfectly runny. Service attentive though wait for a table was 30 mins. | £18-£35 | 2026-02-01 | No | Brighton, UK | Emma K. | 214

6 | zomato.com | Sushi Hana | Fresh sushi, elegant plating | 4.3 | Sashimi was fresh and melt-in-mouth. Nigiri nicely seasoned. Portions modest but worth the price for quality. | £20-£45 | 2026-02-02 | Yes | Edinburgh, UK | Kenji S. | 89

7 | facebook.com | The Old Mill Bar | Great live music nights | 4.2 | Friendly crowd and good playlist. Drinks slightly overpriced but atmosphere made up for it. Staff welcoming to locals. | £5-£25 | 2026-02-03 | No | Cardiff, UK | Laura P. | 63

8 | time-out.com | Fusion Lab | Creative tasting menu | 4.8 | Imaginative dishes and excellent wine pairings. Small portions but each course packed with flavour. A bit pricey but special occasion worthy. | £45-£85 | 2026-02-04 | No | London, UK | Marcus D. | 12

9 | thefork.co.uk | La Trattoria Bella | Authentic Italian, great tiramisu | 4.6 | Homely feel and excellent pasta. Tiramisu is a must. Staff gave a complimentary limoncello which was a lovely touch. | £20-£40 | 2026-02-02 | No | Oxford, UK | Sofia G. | 176

10 | squaremeal.co.uk | The Botanist | Stylish venue, reliable food | 4.0 | Nicely presented dishes and good cocktail list. Busy weekends get loud but overall dependable for mid-range dining. | £25-£45 | 2026-02-01 | No | Birmingham, UK | Chris N. | 97

11 | foodhub.co.uk | Kebab King | Tasty late-night kebabs | 4.1 | Perfect for late-night cravings. Meat well seasoned and sauces tasty. Fries could be crisper but overall very satisfying. | £6-£12 | 2026-02-03 | Yes | Liverpool, UK | Zara H. | 204

12 | tripadvisor.co.uk | Seaview Brasserie | Excellent seafood selection | 4.4 | Fresh mussels and seabass cooked to perfection. Friendly staff and comfortable seating. Parking limited nearby. | £22-£50 | 2026-02-02 | No | Scarborough, UK | Peter L. | 58

13 | yelp.co.uk | Barrel & Oak | Great beer garden | 4.3 | Sunny spot with a wide selection of craft beers. Food menu simple but solid. Dog-friendly which we loved. | £8-£30 | 2026-02-04 | No | Bath, UK | Nina Q. | 74

14 | just-eat.co.uk | Curry Corner | Hearty portions, strong flavours | 4.2 | Spicy lamb curry packed with flavour. Rice fluffy and naan warm. Delivery arrived within promised window. | £9-£22 | 2026-02-04 | Yes | Leicester, UK | Omar T. | 311

15 | deliveroo.co.uk | Pasta Pronto | Comforting carbonara | 4.0 | Creamy carbonara, good texture and not too salty. Portion size perfect for one. Would prefer a bit more pancetta next time. | £7-£16 | 2026-02-03 | Yes | Newcastle, UK | Maya S. | 142

16 | google.com | The Pantry | Quaint cafe with brilliant cakes | 4.9 | Best lemon drizzle I've had in ages. Coffee strong and staff warm. Small but charming spot for weekend brunch. | £4-£12 | 2026-02-02 | No | Cambridge, UK | Oliver W. | 521

17 | zomato.com | Tandoori Nights | Rich sauces, nice heat | 4.1 | Outstanding butter chicken, depth of flavour and good spice level. Rice could be more fragrant. Friendly takeaway staff. | £10-£24 | 2026-02-01 | Yes | Coventry, UK | Priya K. | 67

18 | facebook.com | The Vinyl Diner | Nostalgic vibe, friendly crew | 4.5 | Retro decor and classic burgers done well. Service speedy and staff engaged with customers. Milkshakes rich and creamy. | £6-£18 | 2026-02-03 | No | Glasgow, UK | Ethan J. | 84

19 | time-out.com | Sky Rooftop | Cocktails with a view | 4.6 | Panoramic skyline and expertly mixed cocktails. Small plates good for sharing; booking recommended for weekends. | £30-£60 | 2026-02-04 | No | London, UK | Rachel V. | 221

20 | thefork.co.uk | Le Petit Jardin | Romantic spot, seasonal menu | 4.7 | Intimate setting and beautifully presented seasonal dishes. Service attentive without being intrusive. Ideal for dates. | £35-£70 | 2026-02-01 | No | Bath, UK | Marc A. | 49

21 | squaremeal.co.uk | The Grain House | Great for business lunches | 4.2 | Reliable menu, quick service and quiet atmosphere for meetings. Lunch specials offer good value. | £15-£30 | 2026-02-02 | No | Bristol, UK | Samantha Y. | 134

22 | foodhub.co.uk | Southern Comforts | Homely fried chicken | 4.0 | Crispy coating and juicy meat. Sides generous and gravy tasty. Delivery packaging kept things warm. | £7-£15 | 2026-02-04 | Yes | Sheffield, UK | Daniel F. | 189

23 | tripadvisor.co.uk | Mountain View Cafe | Perfect pitstop after hike | 4.6 | Simple menu but hearty soups and great coffee. Staff helpful with directions and local tips. Outdoor seating scenic. | £5-£14 | 2026-02-03 | No | Lake District, UK | Ivy R. | 34

24 | yelp.co.uk | Noodle Nest | Comforting ramen, rich broth | 4.4 | Deep, savoury broth and springy noodles. Toppings generous and chilli oil packs a punch. Queue moves fast. | £9-£16 | 2026-02-02 | Yes | Bristol, UK | Ken L. | 256

25 | just-eat.co.uk | Fish & Fork | Classic fish and chips | 3.9 | Crispy batter and fluffy chips. Tartar sauce homemade. A bit heavy on salt but overall satisfying takeaway. | £6-£13 | 2026-02-04 | Yes | Hull, UK | Denise P. | 78

26 | deliveroo.co.uk | Bao Brothers | Soft bao, inventive fillings | 4.5 | Steamed buns pillowy and fillings well seasoned. Great for sharing; perfect balance of sweet and savoury. | £6-£20 | 2026-02-03 | Yes | Leeds, UK | Arjun V. | 155

27 | google.com | Cornerstone Bistro | Weekend brunch favourite | 4.3 | Good avocado toast and strong espresso. Friendly staff and quick turnaround. Could use more vegetarian mains. | £8-£20 | 2026-02-01 | No | Norwich, UK | Fiona S. | 306

28 | zomato.com | La Cocina Tapas | Vibrant tapas selection | 4.6 | Extensive small plates with bold flavours. Perfect for groups and sharing; sangria was refreshing. | £18-£40 | 2026-02-02 | No | Liverpool, UK | Diego M. | 92

29 | facebook.com | The Botanica Cafe | Plant-forward menu delights | 4.4 | Innovative vegetarian dishes and great matcha latte. Relaxed setting and helpful menu notes for allergies. | £6-£15 | 2026-02-03 | Yes | Brighton, UK | Lucy T. | 58

30 | time-out.com | Midtown Grill | Solid steaks, attentive staff | 4.1 | Steak cooked to order and well seasoned sides. Ambience lively; ideal for groups celebrating. | £30-£60 | 2026-02-04 | No | Manchester, UK | Gareth P. | 177

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