# 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 Bell | Cosy pub with great service | 5 | Lovely evening — friendly staff, excellent fish pie and real ales. Warm atmosphere and quick seating despite busy night. | £15-£30 | 2026-02-03 | No | Bath, UK | Hannah M | 42

2 | yelp.co.uk | Saffron Spice | Authentic flavours, generous portions | 4 | Good biryani and the lamb rogan josh had depth. Service a bit slow but friendly. Would return. | £10-£25 | 2026-02-02 | Yes | Manchester, UK | Olivier T | 128

3 | just-eat.co.uk | Bella Pasta | Punctual and tasty | 4 | Pasta arrived hot and well packaged. Carbonara was creamy though a touch salty. Garlic bread crisp. | £8-£18 | 2026-02-04 | Yes | Leeds, UK | S. Patel | 67

4 | deliveroo.co.uk | Green Bowl | Fresh, quick lunch option | 5 | Excellent salad bowls and fast delivery. Portions filling and dressings home-made. Perfect for work lunch. | £6-£12 | 2026-02-04 | Yes | London NW1, UK | Maya R | 231

5 | google.com | Harbourside Grill | Fantastic Sunday roast | 5 | Best roast in the area — tender beef, crispy roasties and attentive staff. Great view over the marina. | £20-£35 | 2026-02-01 | No | Brighton, UK | James K | 314

6 | zomato.com | Little Tokyo | Sushi perfection | 5 | Fresh nigiri and inventive rolls. Friendly sushi chef who recommended great pairings. Reasonable prices. | £12-£30 | 2026-02-03 | No | Bristol, UK | Keiko S | 89

7 | facebook.com | The Old Mill Café | Family-friendly gem | 4 | Kids menu and high chairs available. Homemade cakes were delicious. Slight wait for table but worth it. | £5-£20 | 2026-02-02 | No | Cambridge, UK | Liam G | 56

8 | time-out.com | Mercury Rooftop | Stylish drinks with skyline views | 4 | Cocktails well balanced and the DJ was good. Food tapas-style, flavours bold. Expensive but special occasion worthy. | £25-£50 | 2026-01-31 | No | London SE1, UK | Aisha N | 190

9 | thefork.co.uk | Bistro Lumière | Romantic dinner spot | 5 | Impeccable service and beautifully presented tasting menu. Wine pairing was excellent. Perfect anniversary dinner. | £45-£80 | 2026-02-03 | No | Edinburgh, UK | Daniel S | 142

10 | squaremeal.co.uk | Harper & Rye | Modern British done right | 4 | Seasonal menu with interesting flavour combinations. Staff knowledgeable. A touch pricey for portion size. | £30-£55 | 2026-02-02 | No | Oxford, UK | Fiona B | 74

11 | foodhub.co.uk | Pizza Piazza | Great value family pizza | 4 | Large pizzas, thin crust option worked well. Delivery slightly delayed but freebies included. Kids loved it. | £7-£22 | 2026-02-04 | Yes | Newcastle, UK | Connor P | 58

12 | tripadvisor.co.uk | La Mer Brasserie | Seafood heaven | 5 | Superb scallops and seabass. Elegant dining room and attentive sommelier. Highly recommend the tasting menu. | £35-£70 | 2026-02-01 | No | Liverpool, UK | Sonia R | 203

13 | yelp.co.uk | Bean & Board | Top-notch brunch spot | 5 | Amazing avocado toast and excellent flat white. Comfortable seats and fast Wi-Fi — ideal for remote work mornings. | £4-£12 | 2026-02-04 | No | Glasgow, UK | Ethan C | 146

14 | just-eat.co.uk | Curry Corner | Hearty takeaway curry | 3 | Flavours were okay but a bit greasy. Rice clumped together. Prompt delivery though and generous portion sizes. | £6-£18 | 2026-02-03 | Yes | Birmingham, UK | R. Khan | 99

15 | deliveroo.co.uk | Falafel King | Best falafel wrap in town | 5 | Perfectly spiced falafel, crisp salad and lovely tahini. Delivered hot in 25 minutes. Highly recommend for quick lunch. | £4-£9 | 2026-02-02 | Yes | Leicester, UK | Nina V | 77

16 | google.com | Old Harbour Fishery | Fresh and simple | 4 | Fresh catches and friendly crew-run counter. Portions generous; try the fish and chips. Outdoor seating chilly but pleasant. | £10-£20 | 2026-02-03 | No | Whitstable, UK | Tom H | 181

17 | zomato.com | Casa de Tapas | Lively atmosphere, good tapas | 4 | Sharing plates are tasty and varied. Sangria slightly weak. Table noise level high but fun for groups. | £12-£28 | 2026-02-01 | No | Cardiff, UK | Lucia P | 63

18 | facebook.com | The Green Fork | Great vegan options | 5 | Wide vegan menu with inventive dishes. Staff helpful about allergies. Lovely presentation and flavours. | £8-£18 | 2026-02-04 | Yes | Bristol, UK | H. Morgan | 88

19 | time-out.com | Neon Noodles | Street food with flair | 4 | Bold, punchy Asian flavours and fast service. Portions small for price but perfect for tasting several dishes. | £6-£15 | 2026-02-02 | No | Manchester, UK | Priya S | 112

20 | thefork.co.uk | Olive & Oak | Warm neighbourhood favourite | 5 | Consistently good food and welcoming staff. Classic mains executed well and a solid wine list. | £20-£40 | 2026-02-03 | No | York, UK | Gareth L | 156

21 | squaremeal.co.uk | The Conservatory | Splendid afternoon tea | 5 | Elegant sandwiches, delicate pastries and excellent tea selection. Service attentive and polished. | £18-£30 | 2026-02-01 | No | Winchester, UK | Emily J | 95

22 | foodhub.co.uk | Burger Barn | Juicy burgers, friendly delivery | 4 | Burgers cooked to order and fries piping hot. Delivery in insulated bag kept everything warm. | £6-£14 | 2026-02-04 | Yes | Sunderland, UK | Darren K | 134

23 | tripadvisor.co.uk | Ravi's Tandoori | Classic dishes, reliable quality | 4 | Good spice balance and generous portions. Decor dated but food hits the mark for the price. | £9-£22 | 2026-02-02 | Yes | Preston, UK | Anita P | 210

24 | yelp.co.uk | Sourdough & Co. | Bakery bliss | 5 | Freshly baked sourdough loafs and delightful pastries. Friendly barista and cosy seating area. | £2-£8 | 2026-02-03 | No | Norwich, UK | Oliver W | 54

25 | just-eat.co.uk | Thai Express | Quick and tasty takeaway | 4 | Pad Thai flavourful and noodles perfectly done. Delivery faster than estimated. Good value for lunch. | £5-£13 | 2026-02-04 | Yes | Southampton, UK | Mei L | 143

26 | deliveroo.co.uk | Momo House | Comforting dumplings | 5 | Handmade dumplings with delicate wrappers and tasty fillings. Delivered with dipping sauces intact. | £7-£16 | 2026-02-02 | Yes | Leeds, UK | Arjun V | 97

27 | google.com | The Botanical Eatery | Stylish plant-based menu | 5 | Innovative plates and excellent textures. Great for special diets and beautiful plating. | £15-£30 | 2026-02-03 | No | Brighton, UK | Sofia M | 66

28 | zomato.com | Grillsmith | Perfect steaks, smoky flavour | 5 | Steak cooked exactly as ordered with excellent sides. Service professional and knowledgeable about cuts. | £30-£60 | 2026-02-01 | No | Bournemouth, UK | Mark D | 175

29 | facebook.com | Cornerstone Deli | Friendly deli, great sandwiches | 4 | Fresh ingredients and inventive sandwich combos. Coffee decent and staff welcoming. | £3-£9 | 2026-02-04 | No | Exeter, UK | Claire H | 39

30 | time-out.com | Indigo Lounge | Chic spot for cocktails | 4 | Impressive cocktail list and creative garnishes. Music a touch loud for conversation but vibe excellent. | £12-£25 | 2026-02-02 | No | Leeds, UK | Ben R | 121

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