# 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 | Cozy spot with great pies | 4 | Friendly service, classic British pies and a good ale selection. Slight wait on a busy Friday but worth it. Dessert portion generous. | £15-£30 | 2026-02-02 | No | Camden, London | Oliver T. | 152

2 | yelp.co.uk | La Petite Crêperie | Authentic crepes, lively atmosphere | 5 | Fresh buckwheat crepes and a lovely cider list. Staff made recommendations and were attentive. Perfect for a casual lunch. | £8-£20 | 2026-02-03 | Yes | Brixton, London | Sophie M. | 48

3 | just-eat.co.uk | Spice Route Takeaway | Great flavours, on-time delivery | 4 | Strong, well-balanced curries and generous portion sizes. Rice was a little clumped but overall very good value. | £10-£25 | 2026-02-01 | Yes | Leeds | A. Patel | 321

4 | deliveroo.co.uk | Nori & Co Sushi | Fresh sushi, fast delivery | 5 | Sushi arrived chilled and beautifully presented. Quality fish and neat packaging. Wasabi had a real kick. | £12-£35 | 2026-02-04 | Yes | Manchester | Hannah J. | 214

5 | google.com | The Brick Oven | Wood-fired pizzas, family favourite | 4 | Excellent sourdough base and good vegetarian options. Busy but atmosphere makes up for the short wait. | £10-£22 | 2026-02-03 | Yes | Bristol | Mark L. | 586

6 | zomato.com | Bombay Brasserie | Elegant dining with rich flavours | 5 | Beautifully spiced dishes and polite staff. The lamb rogan josh was outstanding. Ideal for special occasions. | £25-£45 | 2026-02-02 | No | Mayfair, London | Priya S. | 137

7 | facebook.com | The Green Fork | Brilliant plant-based options | 5 | Varied vegan menu and inventive cocktails. Staff very knowledgeable about allergens. | £12-£28 | 2026-02-04 | Yes | Brighton | Emily R. | 92

8 | time-out.com | Harbour Grill | Perfect for date night | 4 | Seafood was fresh and cooked to perfection. Service calm and composed. Slightly pricier than expected but fine for occasion dining. | £30-£60 | 2026-02-01 | No | Portsmouth | Darren K. | 74

9 | thefork.co.uk | Bistro Lumière | Charming French bistro | 5 | Classic bistro dishes done impeccably — steak frites excellent, wine list curated. Book ahead for weekend slots. | £20-£40 | 2026-02-03 | No | Oxford | Claire B. | 256

10 | squaremeal.co.uk | Station Taproom | Great pub grub and taps | 4 | Huge selection of craft beers and solid burgers. Loud on weekends but fun vibe. | £10-£25 | 2026-02-02 | No | Leicester | Tom H. | 61

11 | foodhub.co.uk | Mama Rosa's Pizza | Family favourite pizza takeaway | 4 | Thin crust and generous toppings. Garlic dip was a winner. Delivery slightly delayed due to weather. | £8-£18 | 2026-01-31 | Yes | Newcastle | Grace P. | 198

12 | tripadvisor.co.uk | The Old Lantern | Traditional pub with character | 3 | Cosy interior but food was hit-and-miss. Roast was a bit dry though the gravy was tasty. | £12-£25 | 2026-02-02 | No | York | Simon R. | 89

13 | yelp.co.uk | Mamma Lucia | Homely Italian, generous portions | 5 | Authentic sauces and friendly service. Good wine by the glass and excellent tiramisu. | £14-£30 | 2026-02-03 | Yes | Sheffield | Luca F. | 203

14 | just-eat.co.uk | Katsu King | Reliable Japanese takeaway | 4 | Crispy chicken katsu and perfectly steamed rice. Portion sizes generous for price. | £9-£20 | 2026-02-01 | Yes | Glasgow | Ewan M. | 412

15 | deliveroo.co.uk | Green Dragon Vegan | Tasty vegan comfort food | 5 | Creative dishes that don't feel like substitutes. Delivery packaging was environmentally friendly. | £10-£22 | 2026-02-04 | Yes | Bristol | Zara W. | 134

16 | google.com | Seaside Fish Bar | Classic fish and chips | 4 | Crispy batter and fluffy chips. Beachside queues but worth the wait on a sunny day. | £7-£15 | 2026-02-02 | No | Blackpool | Rachel D. | 678

17 | zomato.com | Tapas del Sol | Vibrant tapas and great sangria | 5 | Small plates bursting with flavour. Great for sharing and lively evenings. | £18-£35 | 2026-02-03 | No | Manchester | Carlos V. | 146

18 | facebook.com | The Noodle Bar | Comforting bowls and friendly staff | 4 | Broth had depth and noodles were springy. Generous portions and child-friendly options. | £8-£16 | 2026-02-04 | Yes | Coventry | Maya L. | 57

19 | time-out.com | Skyline Rooftop | Amazing view, decent food | 4 | Skyline cocktails are inventive. Food is good though some dishes lean on presentation over substance. | £25-£50 | 2026-02-01 | No | Leeds | Ben O. | 88

20 | thefork.co.uk | Garden Terrace | Seasonal ingredients shine | 5 | Seasonal tasting menu showed creativity and balance. Service attentive without being intrusive. | £40-£80 | 2026-02-02 | No | Cambridge | Felicity N. | 39

21 | squaremeal.co.uk | Bengali Spice House | Authentic regional curries | 5 | Complex flavours and perfect heat. Bread selection excellent and staff explained dishes well. | £15-£30 | 2026-02-03 | Yes | Birmingham | Rahul K. | 174

22 | foodhub.co.uk | Burger Barn | Juicy burgers, great sides | 4 | Patty cooked medium as requested; onion rings were crisp. Milkshakes huge and tasty. | £9-£20 | 2026-02-04 | Yes | Southampton | Jodie W. | 260

23 | tripadvisor.co.uk | The Tea Merchant | Afternoon tea delight | 5 | Elegant presentation and a wide tea selection. Scones warm with quality clotted cream. | £22-£35 | 2026-02-02 | No | Bath | Alice H. | 321

24 | yelp.co.uk | Falafel House | Best falafel in town | 5 | Crisp falafel and fresh salads. Great vegetarian and halal options. Quick service. | £6-£12 | 2026-02-03 | Yes | Nottingham | Omar A. | 129

25 | just-eat.co.uk | Sweet Tooth Bakery | Delicious cakes delivered warm | 5 | Cakes arrived in perfect condition and tasted fresh. Friendly rider and prompt delivery. | £4-£15 | 2026-02-01 | Yes | Reading | Holly K. | 87

26 | deliveroo.co.uk | Pita Place | Wraps full of flavour | 4 | Fresh ingredients and generous sauces. Would order again, maybe add more salad options. | £6-£12 | 2026-02-04 | Yes | Milton Keynes | Liam S. | 53

27 | google.com | The Pasta Pantry | Comforting homemade pasta | 5 | Rich sauces and perfectly al dente pasta. Staff recommended a great wine pairing. | £12-£28 | 2026-02-03 | Yes | Bournemouth | Nina G. | 402

28 | zomato.com | Smokestack BBQ | Rich smoked meats, bold flavours | 4 | Brisket tender and smoky. Sides a little underseasoned but overall highly satisfying. | £18-£40 | 2026-02-02 | No | Glasgow | Ethan C. | 199

29 | facebook.com | Little Hanoi | Vibrant Vietnamese dishes | 5 | Pho had deep broth and fresh herbs; spring rolls crisp. Cozy interior and quick service. | £9-£20 | 2026-02-04 | Yes | Cardiff | Linh P. | 66

30 | time-out.com | Curry Lane | Bold and authentic flavours | 4 | Great range of regional dishes and impressive spice levels. Portions generous, service efficient. | £14-£30 | 2026-02-01 | Yes | Leicester | Anita S. | 143

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