# 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 Ivy Chelsea Garden | Lovely ambience, excellent service | 5 | Beautiful setting and attentive staff. Food was superb—steak cooked perfectly and sides well seasoned. Dessert was the highlight. Would return. | £35-£60 | 2026-02-03 | No | Chelsea, London | Emma R. | 142

2 | yelp.co.uk | Frank's Kitchen | Great value for brunch | 4 | Brilliant full English with great coffee. Slight wait on a Saturday but staff were friendly. Portion sizes generous. | £8-£16 | 2026-02-02 | No | Brixton, London | Mark T. | 86

3 | just-eat.co.uk | Pasta Fresca | Hot and fresh, arrived on time | 5 | Authentic pasta dishes and garlic bread. Delivery arrived within quoted time and packaging kept food hot. | £10-£20 | 2026-02-04 | Yes | Manchester City Centre | S. Ahmed | 214

4 | deliveroo.co.uk | Bao Street | Tasty baos but portions small | 3 | Flavours were nice but felt slightly overpriced for portion sizes. Fries were soggy on arrival. | £6-£14 | 2026-02-01 | Yes | Shoreditch, London | Liam F. | 57

5 | google.com | The Blackfriar | Historic pub with character | 4 | Lovely Art Nouveau interior. Beers on tap were good and pub food solid. Busy at peak times so book ahead. | £12-£25 | 2026-02-03 | No | Blackfriars, London | Olivia W. | 378

6 | zomato.com | Saffron Curry House | Rich flavours, authentic spice | 5 | Curry had depth and heat without being overpowering. Naan was freshly baked. Service attentive. | £9-£22 | 2026-02-04 | Yes | Leicester | Raj P. | 129

7 | facebook.com | The Riverside Grill | Family friendly and tasty | 4 | Kids menu had good options. Fish was fresh and grilled perfectly. Outdoor seating nice for afternoon. | £15-£30 | 2026-02-02 | No | Cambridge | Hannah G. | 64

8 | time-out.com | Skyline Tapas Bar | Perfect for date night | 5 | Intimate venue with inventive tapas. Drinks list excellent. Prices are premium but worth it for special occasions. | £25-£45 | 2026-02-03 | No | Belfast | Carlos M. | 48

9 | thefork.co.uk | Maison Blanche | Exceptional tasting menu | 5 | Five-course tasting menu was beautifully balanced. Sommelier recommendations excellent. Will book again. | £60-£95 | 2026-02-01 | No | Edinburgh Old Town | Fiona S. | 203

10 | squaremeal.co.uk | Harbour Lights | Great seafood with harbour views | 4 | Seafood platters fresh and well presented. Staff helpful with allergies. Slight delay between courses. | £30-£55 | 2026-02-04 | No | Brighton Marina | George P. | 91

11 | foodhub.co.uk | The Vegan Spoon | Excellent vegan options | 5 | Creative plant-based dishes that even meat-eaters enjoyed. Smoothies were fresh. Prompt delivery. | £7-£18 | 2026-02-02 | Yes | Bristol City Centre | Maya L. | 73

12 | tripadvisor.co.uk | Pavilion Bistro | Good value, friendly staff | 4 | Three-course set menu offered great value. Portions generous and staff were warm. Cozy atmosphere. | £18-£30 | 2026-02-03 | No | Oxford | Daniel K. | 58

13 | yelp.co.uk | Sizzle & Smoke | Smoky BBQ, lively vibe | 4 | Ribs were tender and smoky. Lively music made for a fun night, though a bit loud for conversation. | £20-£35 | 2026-02-01 | No | Birmingham Jewellery Quarter | Aisha B. | 164

14 | just-eat.co.uk | Sushi Hana | Fresh sushi, neat presentation | 5 | Sushi rolls were fresh and beautifully presented. Soy and wasabi included. Delivery was prompt. | £12-£28 | 2026-02-04 | Yes | Leeds City Centre | Tom H. | 312

15 | deliveroo.co.uk | Mamma Mia Pizzeria | Classic Neapolitan pizza | 5 | Thin crust, blistered edges and great tomato sauce. Arrived warm with correct toppings. | £9-£18 | 2026-02-02 | Yes | Nottingham | Giulia R. | 278

16 | google.com | Green Fork Café | Healthy and fresh options | 4 | Good range of salads and bowls. Portions a bit small but ingredients clearly high quality. | £6-£14 | 2026-02-03 | Yes | Glasgow West End | Noah C. | 49

17 | zomato.com | Taste of Kerala | Homely South Indian food | 5 | Thali was excellent with varied curries and perfectly steamed rice. Service friendly and quick. | £10-£22 | 2026-02-01 | Yes | Southall | Priya N. | 134

18 | facebook.com | Old Mill Tearoom | Charming spot for tea | 4 | Scones were homemade and jam delicious. Quiet setting ideal for catch-ups. Staff very polite. | £5-£12 | 2026-02-04 | No | York | Eleanor V. | 36

19 | time-out.com | Neon Ramen | Bold flavours, late-night hit | 5 | Rich broth and springy noodles. Great option for late dinners. Portions generous and well priced. | £9-£16 | 2026-02-02 | No | Camden, London | Jason K. | 210

20 | thefork.co.uk | Le Petit Jardin | Romantic garden dining | 5 | Intimate courtyard and delicate French dishes. Perfect for anniversaries. Booking recommended on weekends. | £40-£70 | 2026-02-03 | No | Bath | Sophie L. | 122

21 | squaremeal.co.uk | The Guildhall | Solid modern British menu | 4 | Well-executed seasonal dishes. Service professional. Wine list could be broader. | £22-£40 | 2026-02-01 | No | Newcastle | Owen M. | 85

22 | foodhub.co.uk | Curry Cottage | Comforting classic curries | 4 | Good spice balance and generous portions. Rice arrived slightly clumped but overall very satisfying. | £8-£19 | 2026-02-04 | Yes | Slough | Farah Z. | 198

23 | tripadvisor.co.uk | The Old Lamp | Cosy pub with great roast | 5 | Sunday roast was outstanding—perfectly cooked meat and crisp veg. Lovely fireplace made it cosy. | £14-£28 | 2026-02-02 | No | Stratford-upon-Avon | Nigel D. | 167

24 | yelp.co.uk | Chai & Chat | Authentic chai and snacks | 5 | Spiced chai was spot on and samosas freshly fried. Small place but excellent for takeout. | £2-£7 | 2026-02-03 | Yes | Wembley | A. Khan | 53

25 | just-eat.co.uk | Burger Barn | Juicy burgers, crispy fries | 4 | Burgers were juicy and fries perfectly seasoned. Sauce packet missing but overall tasty and quick delivery. | £6-£15 | 2026-02-01 | Yes | Cardiff | Sian P. | 245

26 | deliveroo.co.uk | Falafel King | Fresh and flavourful | 5 | Falafel crisp outside, soft inside. Tahini sauce creamy and fresh salad included. On time delivery. | £5-£11 | 2026-02-04 | Yes | Leicester | Yousef A. | 102

27 | google.com | The Conservatory | Lovely brunch spot | 4 | Bright space and reliable brunch classics. Coffee excellent, pancakes fluffy. | £7-£20 | 2026-02-02 | No | Brighton | Megan S. | 77

28 | zomato.com | El Mariachi | Vibrant Mexican flavours | 4 | Tacos packed with flavour and fresh salsa. Margaritas on point though a bit sweet for my taste. | £12-£25 | 2026-02-03 | Yes | Oxford | Diego R. | 141

29 | facebook.com | Station House Bistro | Neighbourhood favourite | 4 | Warm atmosphere and dependable menu. Portions generous and service friendly. Parking nearby. | £11-£24 | 2026-02-01 | No | Guildford | Laura H. | 66

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