# 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 Crown & Kitchen | Charming pub grub, quick service | 4.0 | Lovely atmosphere and friendly staff. Fish and chips were crisp and well seasoned. Portion size generous. Waiting time was under 15 minutes on a busy Friday. | £10-20 | 2026-02-02 | No | Bristol, BS1 | Hannah M | 128

2 | yelp.co.uk | Saffron Spice House | Great flavours but a bit too oily | 3.0 | Authentic spices and bold flavours. Chicken tikka was excellent but the biryani was slightly oily. Service attentive. Would return for mains. | £15-25 | 2026-02-03 | Yes | Leeds, LS2 | Raj P. | 42

3 | just-eat.co.uk | Pizza Roma | Delivered hot and on time | 4.5 | Margherita pizza was simple and delicious. Delivery arrived in 30 minutes and packaging kept pizza intact. Garlic dip a nice touch. | £8-15 | 2026-02-04 | Yes | Manchester, M1 | Claire S | 309

4 | deliveroo.co.uk | Green Bowl Salad Bar | Fresh, fast and healthy | 4.5 | Everything tasted fresh. Custom bowl built quickly, avocado ripe, dressing well balanced. Perfect for a work lunch. | £6-12 | 2026-02-04 | Yes | London, SE1 | Tom L | 214

5 | google.com | Harbourview Steakhouse | Excellent steak, pricey wine list | 4.0 | Steak cooked to order, sides well executed. Ambience great for date night. Wine prices steep but quality matches. | £30-60 | 2026-02-01 | No | Portsmouth, PO1 | Emily R | 517

6 | zomato.com | Bao & Roll | Fantastic baos, small portions | 4.2 | Fluffy baos with inventive fillings. Ideal for sharing. Portions small if very hungry. Friendly counter staff. | £6-12 | 2026-02-03 | Yes | Birmingham, B5 | Marcus D | 89

7 | facebook.com | Seaside Fish Bar | Local favourite, consistent quality | 4.3 | Cod was flaky and batter crunchy. Chips properly done. Staff always polite. Popular so expect a queue on weekends. | £7-14 | 2026-02-02 | Yes | Brighton, BN1 | Olivia K | 76

8 | time-out.com | The Upper Deck Rooftop | Stylish rooftop with great cocktails | 4.6 | Cocktails inventive and skyline views impressive. Small plates delicious but pricey. Reservation recommended for sunset. | £20-45 | 2026-02-04 | No | London, W1 | Time Out Reviewer | 214

9 | thefork.co.uk | Le Petit Marché | Intimate bistro, superb tasting menu | 4.8 | Tasting menu delivered a journey of flavours. Excellent wine pairing and attentive sommelier. Memorable experience. | £45-80 | 2026-02-01 | No | Edinburgh, EH1 | Sophie T | 64

10 | squaremeal.co.uk | Oak & Ember | Refined dining, excellent service | 4.7 | Seasonal menu highlights local produce. Service knowledgeable and unobtrusive. Not cheap but worth it for special occasions. | £40-70 | 2026-02-03 | No | Cambridge, CB2 | George A | 152

11 | foodhub.co.uk | Mama Lucia's | Homely Italian delivered well | 4.1 | Lasagne tasted homemade and arrived piping hot. Garlic bread a bit soft from steam but overall very satisfying. | £10-20 | 2026-02-02 | Yes | Leicester, LE1 | Anna V | 98

12 | tripadvisor.co.uk | The Old Mill Cafe | Cosy spot with great brunch | 4.4 | Full English cooked perfectly, beans tasty, coffee top notch. Friendly staff and quick turnaround on a busy Saturday morning. | £8-15 | 2026-02-04 | No | Bath, BA1 | Liam K | 233

13 | yelp.co.uk | Ramen Republic | Broth packed with depth | 4.5 | Rich tonkotsu broth and springy noodles. Pork chashu melt-in-mouth. Long queues but worth the wait. | £12-18 | 2026-02-03 | Yes | London, E2 | Yuki N | 341

14 | just-eat.co.uk | Curry Corner | Reliable takeaway, big portions | 4.0 | Curries flavorful and generous. Delivery slightly later than estimated but warm. Good value for groups. | £10-25 | 2026-02-01 | Yes | Newcastle, NE1 | Omar H | 178

15 | deliveroo.co.uk | The Vegan Deli | Impressive plant-based options | 4.6 | Creative plant-based dishes with satisfying textures. Delivery neatly packaged and labeled. Will order again. | £7-14 | 2026-02-04 | Yes | Bristol, BS2 | Maya P | 64

16 | google.com | La Trattoria Napoli | Authentic pizza, family run | 4.4 | Wood-fired pizza with great char and flavour. Family-run feel and warm service. Booking advised Fridays. | £12-22 | 2026-02-02 | No | Newcastle, NE2 | Peter S | 412

17 | zomato.com | Sushi Hana | Fresh sashimi, neat presentation | 4.3 | Fish extremely fresh and cuts precise. Nigiri were excellent. Small dining room, intimate setting. | £20-35 | 2026-02-04 | Yes | Oxford, OX1 | Naomi I | 199

18 | facebook.com | The Duck & Waffle | Late-night treat with view | 4.2 | Unique setting and fun menu. Some dishes overpriced but overall fun experience. Service could be quicker at peak. | £25-50 | 2026-02-03 | No | London, EC3 | Alex G | 904

19 | time-out.com | Flour & Fable | Baker's paradise for sourdough lovers | 4.5 | Exceptional bread and pastries. Croissant flaky and buttery. Small cafe seating, take-away popular. | £3-8 | 2026-02-02 | No | Brighton, BN2 | Time Out Reviewer | 88

20 | thefork.co.uk | Marina Brasserie | Perfect for seafood lovers | 4.6 | Fresh seafood, oysters excellent. Scenic harbour views. Slightly slow service at peak times but food compensates. | £25-55 | 2026-02-03 | No | Swansea, SA1 | Caroline B | 121

21 | squaremeal.co.uk | Arbor & Vine | Seasonal tasting, elegant plating | 4.9 | One of the best tasting menus this year. Each course well thought out, technical execution immaculate. | £65-120 | 2026-02-01 | No | York, YO1 | Nigel R | 37

22 | foodhub.co.uk | Spice Route | Reliable family meals | 3.9 | Good flavours but a touch heavy on salt. Generous portion sizes and quick delivery for a family order. | £12-30 | 2026-02-04 | Yes | Sheffield, S1 | Fiona W | 54

23 | tripadvisor.co.uk | Baker Street Brasserie | Elegant lunch with quick service | 4.3 | Set lunch menu excellent value. Staff attentive and courses arrived promptly. Interior stylish and comfortable. | £18-35 | 2026-02-03 | No | Manchester, M2 | James H | 276

24 | yelp.co.uk | Taco Cantina | Bold flavours, great margaritas | 4.4 | Tacos packed with flavour, fresh salsas. Margaritas balanced and lively. Casual vibe, loud music on weekends. | £8-18 | 2026-02-02 | Yes | Liverpool, L1 | Sofia R | 153

25 | just-eat.co.uk | Burger Barn | Solid burgers, messy but tasty | 4.0 | Burgers juicy and generous toppings. Fries a bit greasy but overall a satisfying takeaway. | £7-14 | 2026-02-04 | Yes | Cardiff, CF10 | Evan D | 401

26 | deliveroo.co.uk | Pasta Fresca | Fresh pasta, delicate sauces | 4.7 | Handmade pasta with refined sauces. Delivery insulated bag kept dishes warm. Portion sizes fair. | £10-22 | 2026-02-03 | Yes | Bournemouth, BH1 | Isabel F | 128

27 | google.com | The Garden Tea Room | Lovely afternoon tea experience | 4.5 | Scones warm with clotted cream and jam. Selection of teas impressive and staff kindly explained blends. | £18-30 | 2026-02-01 | No | St Albans, AL1 | Margaret L | 212

28 | zomato.com | Kebab Central | Quick and tasty late-night option | 4.1 | Doner meat well seasoned and sauces plentiful. Good for late cravings. Clean premises for a kebab shop. | £4-9 | 2026-02-04 | Yes | Nottingham, NG1 | Ozan K | 67

29 | facebook.com | The Green Lantern | Cosy dinner with live music | 4.0 | Live acoustic set created a warm vibe. Food hearty and well cooked. Could improve ventilation on busy nights. | £15-30 | 2026-02-02 | No | Belfast, BT1 | Nora T | 88

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