# 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 Crusty Crab Bar | Lovely sea views and great tapas | 4.5 | Lovely evening, attentive staff and a wide tapas selection. Seafood paella was a touch salty but overall highly enjoyable. Cozy terrace with harbour views. | £25-£40 | 2026-02-03 | No | Brighton, UK | Emma J | 84

2 | yelp.co.uk | Brick & Barrel | Great cocktails, busy on weekends | 4.0 | Fantastic cocktail list and wood-fired pizzas. Service slowed during the Saturday rush but bartenders were excellent. Book ahead for weekend tables. | £15-£35 | 2026-02-02 | No | Manchester, UK | Owen K | 192

3 | just-eat.co.uk | Curry Corner | Reliable takeout, flavours spot on | 4.2 | Order arrived hot and on time. Chicken tikka masala was well seasoned, naan was fresh. Would prefer slightly larger portions but good value. | £8-£18 | 2026-02-04 | Yes | Leeds, UK | Saira P | 567

4 | deliveroo.co.uk | Mama Lucia Pizzeria | Authentic Neapolitan pizza | 4.8 | Crust was blistered perfectly, fresh basil and buffalo mozzarella. Delivery time was under 30 minutes and pizza arrived piping hot. Will reorder. | £10-£22 | 2026-02-04 | Yes | London, UK | Mark T | 421

5 | google.com | The Ivy Garden | Chic spot, excellent service | 4.6 | Beautiful dining room and knowledgeable servers. Food is inventive; portion sizes are generous. Pricey but great for special occasions. | £40-£80 | 2026-02-01 | No | London, UK | Priya R | 1432

6 | zomato.com | Sushi Sora | Fresh sashimi, friendly staff | 4.4 | Sashimi platter was fresh and artfully presented. Waiting time was short on a weekday. Good sake selection too. | £20-£45 | 2026-02-03 | Yes | Bristol, UK | Liam G | 98

7 | facebook.com | The Dog & Duck | Warm pub with great Sunday roast | 4.3 | Cosy atmosphere and generous roast. Gravy could be richer but veg was perfectly cooked. Kids menu available. | £12-£25 | 2026-02-02 | No | Oxford, UK | Hannah W | 276

8 | time-out.com | Skyline Rooftop | Rooftop vibes and late-night DJs | 4.1 | Stunning skyline views and solid DJ sets. Drinks are expensive but the ambience is worth it for a date night or group event. | £12-£30 | 2026-02-01 | No | Birmingham, UK | Diego M | 64

9 | thefork.co.uk | Le Petit Marché | Romantic bistro, seasonal menu | 4.7 | Perfect for anniversaries. Tasting menu showcased local produce and each course was beautifully plated. Service attentive without being intrusive. | £50-£90 | 2026-02-03 | No | Edinburgh, UK | Aoife L | 211

10 | squaremeal.co.uk | Warehouse Kitchen | Industrial chic and robust flavours | 4.0 | Great for groups; sharing platters are generous. Sound levels get high during busy nights. Good craft beer selection. | £20-£40 | 2026-01-31 | No | Liverpool, UK | Callum R | 129

11 | foodhub.co.uk | Green Bowl | Healthy bowls, fast delivery | 4.5 | Fresh ingredients and lots of vegan options. Delivery was timely and packaging eco-friendly. Would like more hot options. | £7-£14 | 2026-02-04 | Yes | Glasgow, UK | Tess N | 54

12 | tripadvisor.co.uk | Harbour Lights | Special birthday dinner success | 5.0 | Celebrated a birthday and staff surprised us with a small dessert. Food, ambience and service were all top-notch. Highly recommend the seabass. | £35-£65 | 2026-02-02 | No | Southampton, UK | Rupert H | 318

13 | yelp.co.uk | Bao & Co | Delicious bao and quick service | 4.6 | Street-food style but very polished. Pork belly bao melts in your mouth, and service is friendly. Small seating area though. | £6-£14 | 2026-02-03 | Yes | Cambridge, UK | Maya S | 87

14 | just-eat.co.uk | Fish Fry Express | Classic fish and chips, reliable delivery | 4.0 | Crispy batter and generous chips. Tartare sauce tasted homemade. Driver was polite and timely. | £6-£15 | 2026-02-04 | Yes | Hull, UK | George L | 402

15 | deliveroo.co.uk | Vegan Vibes | Creative plant-based dishes | 4.7 | Innovative flavours and satisfying textures. Portobello burger was excellent. Delivery packaging kept food intact and warm. | £9-£18 | 2026-02-02 | Yes | Leicester, UK | Nora C | 156

16 | google.com | Old Mill Inn | Charming pub, attentive landlords | 4.2 | Quaint setting and well-kept ales. Sunday roast portions are generous. Parking can be tricky on market days. | £10-£22 | 2026-02-01 | No | Bath, UK | Simon K | 389

17 | zomato.com | Tandoori Nights | Classic flavours done well | 4.3 | Rich sauces and fragrant rice. Naan was slightly oily but fresh. Good family-friendly menu and fast service. | £12-£28 | 2026-02-03 | Yes | Newcastle, UK | Alisha M | 233

18 | facebook.com | The Garden Table | Brunch heaven with bottomless coffee | 4.6 | Amazing brunch options and excellent coffee refills. Staff were lovely and accommodated a dietary request easily. | £8-£20 | 2026-02-02 | No | Brighton, UK | Laura P | 315

19 | time-out.com | Neon Noodles | Vibrant, modern Asian fusion | 4.1 | Colourful plates and inventive noodle bowls. Portions are moderate; good spot for a casual dinner with friends. | £10-£25 | 2026-02-03 | Yes | Nottingham, UK | Ethan S | 48

20 | thefork.co.uk | Maison Blanche | Elegant dining, precise cooking | 4.8 | Flawless execution of flavours and textures. Wine pairing recommended by a knowledgeable sommelier. Perfect for celebrations. | £60-£120 | 2026-01-31 | No | York, UK | Clara V | 76

21 | squaremeal.co.uk | Chef's Table | Tasting menu excellence | 4.9 | An exceptional tasting menu with excellent pacing and inventive courses. Staff explained each dish and sourced ingredients locally. | £75-£150 | 2026-02-02 | No | Edinburgh, UK | Daniel F | 39

22 | foodhub.co.uk | Pasta Pronto | Comforting pasta, great family portions | 4.2 | Homely pasta dishes and generous portions. Carbonara could be creamier but overall very satisfying. Value for families. | £9-£20 | 2026-02-04 | Yes | Milton Keynes, UK | Fiona H | 64

23 | tripadvisor.co.uk | The Wharf Grill | Steaks cooked perfectly | 4.5 | Steakhouse with a reliable grill. Sides were tasty and steaks came as ordered. Wine list is comprehensive but prices are steep. | £30-£55 | 2026-02-03 | No | Portsmouth, UK | Ben S | 241

24 | yelp.co.uk | La Taqueria | Authentic tacos, vibrant flavours | 4.4 | Tacos were punchy and fresh. Salsa bar is a nice touch. Seating is limited so peak times are crowded. | £6-£12 | 2026-02-04 | Yes | Bristol, UK | Isabel R | 158

25 | just-eat.co.uk | Noodle Nest | Quick, tasty midweek dinner | 4.0 | Good value and flavoursome broth. Portion sizes generous for the price. Delivery driver was friendly. | £7-£13 | 2026-02-03 | Yes | Reading, UK | Adeel Z | 279

26 | deliveroo.co.uk | Chop House | Premium meats, good sides | 4.3 | High-quality cuts and inventive side dishes. Delivery was on time; temperature was good. Reservations recommended for evenings. | £28-£60 | 2026-02-02 | Yes | Sheffield, UK | Nikki P | 193

27 | google.com | Café Montmartre | Cosy French café feel | 4.2 | Perfect croissants and strong coffee. Lunch menu has interesting quiche options. Service was relaxed and friendly. | £6-£18 | 2026-02-01 | No | Oxford, UK | Gareth D | 521

28 | zomato.com | Bao House | Great value street eats | 4.0 | Fast service and tasty baos. Sides could be improved but overall good for a quick bite. Affordable prices. | £5-£12 | 2026-02-04 | Yes | London, UK | Sofia N | 134

29 | facebook.com | The Lighthouse Café | Perfect brunch by the sea | 4.7 | Brilliant food and friendly staff. Eggs Benedict was cooked perfectly; sea views add to the experience. Will return. | £9-£22 | 2026-02-03 | No | Scarborough, UK | Tom B | 201

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