# 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 Drapers Arms | Charming pub with great Sunday roast | 5 | Lovely atmosphere, attentive staff and perfectly cooked roast beef. Large portions and cosy dining room. Will book again. | £15-£25 | 2026-02-02 | No | London | Emily J | 142

2 | yelp.co.uk | Spice Route Indian | Fantastic flavours, a little noisy | 4 | Authentic dishes with bold spice profiles. Service was quick though the place is loud at peak times. Tandoori starter stood out. | £12-£22 | 2026-02-03 | Yes | Birmingham | Amit P | 87

3 | just-eat.co.uk | Bella Pizza | Fast delivery, pizza still hot | 5 | Margherita with fresh basil and a crispy base. Arrived within 30 minutes and packaging kept it intact. Great value. | £8-£15 | 2026-02-04 | Yes | Manchester | Sophie L | 298

4 | deliveroo.co.uk | Green Bowl | Healthy and tasty salad bowls | 4 | Fresh ingredients and generous portions. Dressing was slightly sweet for our taste but overall excellent. Good for lunches. | £6-£11 | 2026-02-03 | Yes | Leeds | Tom R | 65

5 | google.com | La Petite Table | Intimate dining, outstanding service | 5 | Exceptional tasting menu and wine pairings. Small plates, big flavours. A special-occasion spot. | £45-£80 | 2026-02-01 | No | Oxford | Hannah K | 214

6 | zomato.com | Seaside Grill | Great seafood, scenic views | 4 | Fresh fish and excellent chips. Bit pricey but the harbour view makes it worthwhile. Friendly staff. | £20-£35 | 2026-02-02 | No | Brighton | Liam S | 129

7 | facebook.com | Mama Rosa Trattoria | Warm family-run Italian | 5 | Homely atmosphere and generous portions. The tiramisu was the highlight. Owners greeted us personally. | £10-£22 | 2026-02-04 | No | Newcastle | Olivia N | 58

8 | time-out.com | The Rooftop Social | Trendy rooftop, great cocktails | 4 | Stylish location with inventive cocktails. Small plates are shareable but service can be slow on busy nights. | £12-£30 | 2026-02-03 | No | London | Marcus V | 340

9 | thefork.co.uk | Saffron Garden | Excellent curry, good value | 5 | Rich flavours and perfectly balanced spices. Generous rice and naan servings. Would recommend the lamb bhuna. | £10-£20 | 2026-02-02 | Yes | Leicester | Priya S | 76

10 | squaremeal.co.uk | Harvest Kitchen | Modern British with seasonal menu | 4 | Creative dishes using local produce. A few items needed stronger seasoning but presentation was lovely. | £25-£45 | 2026-02-01 | No | Bristol | George H | 190

11 | foodhub.co.uk | The Kebab House | Quick, tasty late-night food | 4 | Generous portions and lots of sauces. Affordable and reliable for late meals. Garlic sauce was excellent. | £6-£10 | 2026-02-03 | Yes | Sheffield | Nora M | 54

12 | tripadvisor.co.uk | Riverside Brasserie | Lovely riverside dining | 5 | Beautiful setting and attentive staff. The seabass was cooked perfectly. Great wine list too. | £30-£50 | 2026-02-04 | No | Cambridge | Daniel F | 165

13 | yelp.co.uk | Nomad Burgers | Best burger in town | 5 | Juicy patties and creative toppings. Fries were crispy and the milkshake was thick. Friendly crew. | £9-£16 | 2026-02-02 | Yes | Liverpool | Cara B | 223

14 | just-eat.co.uk | Sushi Express | Fresh sushi, speedy delivery | 4 | Good variety and rice texture was spot on. A few pieces arrived slightly shifted but flavours were fresh. | £10-£25 | 2026-02-04 | Yes | Cardiff | Evan T | 112

15 | deliveroo.co.uk | Vegan Vibes | Delicious plant-based options | 5 | Creative menu with satisfying mains. The jackfruit tacos were a standout. Packaging eco-friendly too. | £8-£14 | 2026-02-01 | Yes | Bristol | Zara P | 91

16 | google.com | Chez Margot | Refined French cooking | 5 | Elegant courses with precise seasoning. Staff knowledgeable about the menu and wine pairings. | £50-£90 | 2026-02-02 | No | Bath | Oliver K | 321

17 | zomato.com | Taco Cartel | Fun atmosphere and tasty tacos | 4 | Street-style tacos with bold flavours. Salsa bar was a nice touch. Seating is limited though. | £6-£12 | 2026-02-03 | Yes | Manchester | Rosa C | 147

18 | facebook.com | The Old Mill Inn | Cosy spot, great pie | 5 | Traditional pub food done well. Steak and ale pie was hearty and the staff very welcoming. | £12-£20 | 2026-02-01 | No | York | Ian M | 203

19 | time-out.com | Midtown Dumplings | Genuine flavours, quick service | 4 | Handmade dumplings with a range of fillings. Perfect for a casual dinner. Portions could be bigger for sharing. | £7-£13 | 2026-02-04 | Yes | London | Sofia R | 128

20 | thefork.co.uk | Olive & Thyme | Romantic dinner spot | 5 | Perfect for anniversaries. Tasting menu was exceptional and the sommelier choices complemented each course. | £60-£100 | 2026-02-03 | No | Edinburgh | Calum D | 89

21 | squaremeal.co.uk | Brass & Cedar | Great for groups and events | 4 | Spacious interior and varied menu. Service during a private event was efficient and accommodating. | £20-£40 | 2026-02-02 | No | Glasgow | Maya L | 47

22 | foodhub.co.uk | Pasta Palazzo | Comforting home-style pasta | 5 | Generous portions and rich sauces. Carbonara was creamy without being greasy. Family favourite. | £9-£18 | 2026-02-03 | Yes | Nottingham | Ben S | 134

23 | tripadvisor.co.uk | The Boathouse Café | Perfect brunch spot by the lake | 4 | Great coffee and avocado toast. Busy at weekends but staff manage queues well. Lovely views. | £6-£14 | 2026-02-04 | No | St Albans | Fiona W | 76

24 | yelp.co.uk | Curry Corner | Affordable and flavourful | 4 | Good balance of spice and depth. Portions generous and great if you're on a budget. Recommend the bhuna. | £8-£16 | 2026-02-01 | Yes | Bolton | Harpreet K | 59

25 | just-eat.co.uk | Dragon Wok | Reliable Chinese takeout | 3 | Food was decent but arrived later than estimated. Egg fried rice was a bit oily this time. | £7-£13 | 2026-02-02 | Yes | Slough | Marcus G | 33

26 | deliveroo.co.uk | Falafel Factory | Crispy falafel, fresh salads | 5 | Great mix of flavours and generous hummus. Quick delivery and well packed to prevent sogginess. | £5-£10 | 2026-02-04 | Yes | Oxford | Leah A | 102

27 | google.com | The Cellar Steakhouse | Top-quality steakhouse experience | 5 | Perfectly aged steaks and excellent side dishes. Service professional and knowledgeable on cuts. | £35-£60 | 2026-02-03 | No | Bournemouth | Richard P | 276

28 | zomato.com | Katsu House | Comforting Japanese classics | 4 | Crispy chicken katsu and fragrant rice. Portions generous and miso soup was warming but slightly salty. | £9-£17 | 2026-02-02 | Yes | Reading | Aya M | 68

29 | facebook.com | Urban Taproom | Good beers and pub grub | 4 | Extensive craft beer selection and tasty sliders. Can get crowded on match days but staff cope well. | £6-£18 | 2026-02-01 | No | Portsmouth | Gareth L | 143

30 | time-out.com | Garden Terrace | Relaxed lunch with a view | 4 | Light, seasonal plates and good iced teas. Service friendly but slightly slow at peak lunchtime. | £10-£22 | 2026-02-03 | No | Cambridge | Nadine O | 98

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