# 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 Lantern Pub & Kitchen | Great pub food and cosy atmosphere | 5 | Visited for a weekend dinner — steak cooked perfectly, large portion of seasonal veg and very helpful staff. Cozy fire in the bar. Will return. | £20-£35 | 2026-02-03 | No | Cambridge, UK | Emma G. | 142

2 | yelp.co.uk | Little Napoli Pizzeria | Authentic Neapolitan pizza | 4 | Dough was light and blistered, margherita was simple and delicious. Service a little slow at peak time but worth the wait. | £8-£18 | 2026-02-02 | Yes | Manchester, UK | Liam K. | 87

3 | just-eat.co.uk | Curry Bazaar | Reliable takeaway, flavourful curries | 4 | Order arrived on time and piping hot. Mango chutney was excellent. Portion sizes generous. | £7-£25 | 2026-02-04 | Yes | Birmingham, UK | S. Patel | 326

4 | deliveroo.co.uk | Green Fork Cafe | Fresh salads and quick delivery | 5 | Amazing quinoa salad and avocado dressing. Delivery rider was friendly and food arrived chilled as requested. | £6-£14 | 2026-02-01 | Yes | London, UK | Oliver R. | 64

5 | google.com | Seabreeze Fish Bar | Classic fish and chips | 3 | Battered cod was okay but a bit greasy. Chips were crispy. Friendly staff but long queue on Sunday. | £6-£15 | 2026-02-04 | No | Brighton, UK | Hannah J. | 214

6 | zomato.com | Saffron Street | Lovely flavours, attentive service | 5 | Butter chicken had the perfect balance of spice and cream. Naan was fresh. Ambience was comfortable for a date night. | £15-£30 | 2026-02-03 | Yes | Leeds, UK | Aisha M. | 58

7 | facebook.com | The Riverside Brasserie | Fantastic Sunday roast | 5 | Roast beef was tender with excellent gravy. Kids menu kept the little ones happy. Staff went the extra mile. | £18-£30 | 2026-02-02 | No | Oxford, UK | Mark S. | 98

8 | time-out.com | Neon Bao | Punchy flavours, great cocktails | 4 | Bao buns were fluffy, fillings inventive. Cocktails slightly overpriced but expertly mixed. | £12-£28 | 2026-02-01 | No | London, UK | Time Out Reviewer | 12

9 | thefork.co.uk | La Trattoria Moderna | Romantic setting, delicious pasta | 5 | Homemade tagliatelle and tiramisu were highlights. Waitstaff recommended great wine pairing. | £20-£40 | 2026-02-03 | No | Bristol, UK | Sophie L. | 203

10 | squaremeal.co.uk | The Brass Rail | Business lunch spot | 4 | Efficient service and reliable seasonal menu. Empanadas starter stood out. | £16-£30 | 2026-02-02 | No | Cardiff, UK | Daniel P. | 45

11 | foodhub.co.uk | Mama's Kitchen | Home-cooked comfort food delivered | 5 | Stew and dumplings tasted like homemade. Friendly owner left extra pickles. Delivery crisp and warm. | £5-£12 | 2026-02-04 | Yes | Newcastle, UK | Grace T. | 74

12 | tripadvisor.co.uk | Skyline Rooftop Bar | Amazing views, pricey drinks | 4 | Panoramic skyline views are worth it. Cocktails were good but on the expensive side. | £10-£18 | 2026-02-01 | No | Birmingham, UK | Alex W. | 311

13 | yelp.co.uk | Bao & Brew | Trendy spot with tasty buns | 4 | Unique flavour combinations and quick service. Small portions for the price. | £6-£14 | 2026-02-03 | Yes | Glasgow, UK | Maya R. | 52

14 | just-eat.co.uk | Pasta Pronto | Good pasta and garlic bread | 4 | Penne arrabiata had the right kick. Garlic bread was crunchy. Delivery driver very polite. | £7-£20 | 2026-02-02 | Yes | Leicester, UK | Tom H. | 140

15 | deliveroo.co.uk | The Vegan Orchard | Great plant-based options | 5 | Jackfruit burger was superb. Sides were creative and filling. Arrived on time in compostable packaging. | £8-£16 | 2026-02-04 | Yes | Bristol, UK | Nora C. | 88

16 | google.com | Caffè Roma | Solid espresso and pastries | 4 | Cappuccino was strong and smooth. Croissant was buttery. Small seating but cosy for a quick stop. | £3-£8 | 2026-02-03 | No | Cambridge, UK | Ben F. | 189

17 | zomato.com | Spice Route | Bold flavours, generous portions | 5 | Tandoori platter was full of flavour and perfect char. Service attentive and helpful with spice levels. | £14-£35 | 2026-02-02 | Yes | Manchester, UK | Priya S. | 146

18 | facebook.com | The Garden Bistro | Lovely vegetarian brunch | 5 | Brunch board was varied and tasty, perfect for a relaxed weekend. Staff made us feel welcome. | £10-£22 | 2026-02-01 | No | Brighton, UK | Clara N. | 67

19 | time-out.com | Midnight Taco | Late-night tacos done right | 4 | Spicy al pastor and fresh salsa. Great for night owls, a bit noisy inside. | £4-£12 | 2026-02-04 | No | London, UK | Time Out Reviewer | 29

20 | thefork.co.uk | Bistro du Parc | Elegant bistro experience | 5 | Duck confit was crisp and rich, desserts were decadent. Perfect for celebrations. | £25-£50 | 2026-02-02 | No | Edinburgh, UK | Helen M. | 257

21 | squaremeal.co.uk | Harbour Grill | Great for client dinners | 4 | Sea bass was fresh and well-presented. Wine list comprehensive. Slight wait between courses. | £22-£45 | 2026-02-03 | No | Southampton, UK | Richard A. | 33

22 | foodhub.co.uk | Falafel King | Tasty and affordable | 5 | Falafel wrap packed with flavour and tahini. Fast delivery and very good value. | £4-£8 | 2026-02-01 | Yes | Leeds, UK | Yusuf B. | 121

23 | tripadvisor.co.uk | Hilltop Tea Rooms | Charming tea experience | 5 | Scones were warm with jam and clotted cream. Lovely staff and countryside views. | £6-£12 | 2026-02-04 | No | Cotswolds, UK | June P. | 412

24 | yelp.co.uk | The Brew Loft | Great craft beers and small plates | 4 | Selection of local ales was impressive. Small plates perfect for sharing. | £6-£20 | 2026-02-02 | No | Bristol, UK | Chris D. | 90

25 | just-eat.co.uk | Sushi Express | Fresh sushi and good value | 4 | Maki rolls were fresh and neatly packed. Soy and wasabi provided. Delivery was prompt. | £6-£22 | 2026-02-03 | Yes | Coventry, UK | Naoko H. | 59

26 | deliveroo.co.uk | Pollo Loco | Succulent rotisserie chicken | 5 | Herb-marinated chicken juicy and served with crispy potatoes. Great value for a family meal. | £10-£25 | 2026-02-01 | Yes | Nottingham, UK | Ethan B. | 177

27 | google.com | The Coffee Nook | Warm and welcoming cafe | 5 | Friendly barista and excellent flat white. Vegan cake was moist and tasty. | £3-£7 | 2026-02-02 | No | York, UK | Megan L. | 230

28 | zomato.com | Bengal Spice | Consistently good Indian | 4 | Balti was rich and flavoursome. Good portion sizes and friendly staff. | £12-£30 | 2026-02-04 | Yes | Sheffield, UK | Arjun R. | 101

29 | facebook.com | The Local Deli | Quick lunch stop | 4 | Paninis freshly made and excellent coffee. Helpful staff during busy lunch rush. | £4-£10 | 2026-02-01 | No | Milton Keynes, UK | Samantha Y. | 49

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