# 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 Plough | Charming pub meal | 4 | Great atmosphere and friendly staff. Steak was cooked perfectly, chips a bit greasy but overall very good. Would visit again for Sunday roast. | £15-£30 | 2026-02-02 | No | Cambridge, UK | Emma T | 128

2 | yelp.co.uk | Saffron Kitchen | Delicious biryani, quick service | 5 | Authentic flavours and generous portion. Staff were helpful and the takeaway arrived hot. Highly recommend the lamb biryani. | £8-£20 | 2026-02-03 | Yes | Bristol, UK | Ravi P | 54

3 | just-eat.co.uk | Bella Pizza | Good pizza but late | 3 | Pizza quality was decent with fresh toppings, but delivery arrived 40 minutes late and the crust was slightly soggy. | £6-£18 | 2026-02-04 | Yes | Manchester, UK | L. Morgan | 342

4 | deliveroo.co.uk | Green Fork | Fresh vegetarian bowls | 5 | Picked the halloumi bowl and it was vibrant and fresh. Packaging kept everything separate. Delivery on time. | £7-£13 | 2026-02-01 | Yes | London WC1 | Sophie K | 89

5 | google.com | Seabreeze Fish Bar | Classic seaside chips | 4 | Perfect batter and fluffy chips. Service friendly. Would have given 5 but portion sizes varied between visits. | £4-£12 | 2026-02-02 | No | Brighton, UK | Tom H | 211

6 | zomato.com | Maya Tapas | Lovely tapas selection | 4 | Great sharing plates, good wine list. Slightly noisy on weekend but food quality is consistent. | £20-£35 | 2026-02-03 | No | Leeds, UK | Ana G | 67

7 | facebook.com | The Garden Café | Perfect brunch spot | 5 | Amazing avocado toast and excellent coffee. Child-friendly and pleasant outdoor seating. | £6-£14 | 2026-02-04 | No | Edinburgh, UK | Hannah R | 193

8 | time-out.com | Fuego Taqueria | Best tacos in town | 5 | Small plates but big on flavour. Vibrant atmosphere and creative cocktails. A must-visit for taco lovers. | £10-£25 | 2026-02-01 | No | London SE1 | Time Out Reviewer | 12

9 | thefork.co.uk | La Trattoria Rosa | Romantic dinner spot | 4 | Atmosphere was intimate, pasta was excellent. Service attentive though a little slow between courses. | £25-£50 | 2026-02-03 | No | Oxford, UK | Marco L | 78

10 | squaremeal.co.uk | The Coal Kitchen | Impressive tasting menu | 5 | Outstanding tasting menu with thoughtful wine pairings. Excellent technical cooking and presentation. | £55-£95 | 2026-02-02 | No | Birmingham, UK | Giles M | 34

11 | foodhub.co.uk | Pasta Fresca | Great value takeaway | 4 | Fresh pasta and good portion sizes. Affordable family meals and reliable delivery partner. | £5-£16 | 2026-02-04 | Yes | Liverpool, UK | Nadia S | 156

12 | tripadvisor.co.uk | Harbour View Restaurant | Lovely views, mixed food | 3 | The view was spectacular but mains were average. Service was friendly but long wait times during peak hours. | £18-£40 | 2026-02-01 | No | Scarborough, UK | Oliver W | 402

13 | yelp.co.uk | Bean & Bloom | Cozy café, great pastries | 5 | Fantastic sourdough and pastries baked daily. Coffee excellent, staff remembered regulars' orders. | £3-£8 | 2026-02-03 | No | Brighton, UK | Maya S | 221

14 | just-eat.co.uk | Curry Corner | Flavourful but salty | 3 | Curries full of flavour but slightly over-salted for our taste. Rice portions generous and naan soft. | £6-£20 | 2026-02-02 | Yes | Leicester, UK | A. Khan | 268

15 | deliveroo.co.uk | Fish & Fork | Quick lunch delivery | 4 | Salmon salad was fresh and crisp. Packaging sustainable and delivery within promised time. | £8-£15 | 2026-02-04 | Yes | Cardiff, UK | James P | 47

16 | google.com | The Noodle Bar | Comfort food hit or miss | 3 | Broth was deep and comforting but noodles occasionally overcooked. Affordable and convenient location. | £6-£12 | 2026-02-01 | No | Glasgow, UK | Fiona M | 134

17 | zomato.com | Spice Route | Excellent regional dishes | 5 | Regional specialities prepared with care. Bold flavours and professional service. Portions just right. | £15-£30 | 2026-02-03 | No | Bristol, UK | R. Singh | 91

18 | facebook.com | Urban Grill | Lively evening out | 4 | Steaks cooked to order and good cocktail menu. Loud at weekends but great for groups. | £20-£45 | 2026-02-02 | No | Newcastle, UK | Chris D | 164

19 | time-out.com | Mizu Sushi | Refined sushi experience | 5 | Beautifully presented nigiri and expertly balanced flavours. Reservation recommended. | £30-£60 | 2026-02-04 | No | London W1 | Time Out Critic | 18

20 | thefork.co.uk | Olive & Thyme | Weekend brunch perfection | 5 | Excellent eggs Benedict and friendly staff. Relaxed vibe and quick service for brunch crowd. | £10-£22 | 2026-02-03 | No | Bath, UK | Laura B | 58

21 | squaremeal.co.uk | Maison Blanche | Exceptional modern cuisine | 5 | Creative dishes, impeccable service and elegant dining room. One of the best in the region. | £60-£120 | 2026-02-02 | No | York, UK | Editorial Team | 27

22 | foodhub.co.uk | Burger Barn | Family favourite | 4 | Juicy burgers and good value combo deals. Fries were crisp and portion sizes generous. | £5-£14 | 2026-02-01 | Yes | Milton Keynes, UK | Dan S | 312

23 | tripadvisor.co.uk | Pavilion Tea Rooms | Traditional afternoon tea | 4 | Lovely scones and dainty sandwiches. Tea selection excellent; service could be slightly quicker. | £18-£28 | 2026-02-03 | No | York, UK | Eleanor P | 146

24 | yelp.co.uk | The Vegan Spoon | Impressive plant-based menu | 5 | Innovative dishes with bold flavours. Even non-vegans in our group were impressed. | £8-£20 | 2026-02-04 | Yes | Leeds, UK | Tom B | 76

25 | just-eat.co.uk | Kebab King | Late-night lifesaver | 4 | Perfect for late nights; kebabs well-seasoned and generous. Not gourmet, but reliable and tasty. | £4-£9 | 2026-02-02 | Yes | Sheffield, UK | Maddie L | 422

26 | deliveroo.co.uk | Pan Asian Express | Speedy and satisfying | 4 | Pad Thai was balanced and delivery packed neatly. Won't replace sit-down but great for quick meals. | £7-£14 | 2026-02-01 | Yes | Bristol, UK | Aaron K | 98

27 | google.com | Corner Bistro | Reliable neighbourhood spot | 4 | Consistent quality and friendly service. Good for casual dinners and meetups with friends. | £10-£25 | 2026-02-03 | No | Oxford, UK | Melanie C | 259

28 | zomato.com | Le Petit Café | Charming and cosy | 5 | Intimate café with superb coffee and croissants. Staff attentive and atmosphere relaxed. | £3-£10 | 2026-02-04 | No | Cambridge, UK | Julien R | 64

29 | facebook.com | The Spice Box | Takeaway perfection | 5 | Order arrived piping hot and packed perfectly. Curries tasted homemade with good heat levels. | £6-£18 | 2026-02-01 | Yes | Slough, UK | Priya N | 139

30 | time-out.com | The Rooftop Bar | Stunning skyline views | 4 | Cocktails exceptional and views unbeatable. Table service a bit slow when busy but overall a great experience. | £12-£25 | 2026-02-02 | No | Manchester, UK | Time Out Guide | 21

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