# 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 Gilded Fork | Lovely neighbourhood gem | 5 | Warm welcome, excellent tapas-style plates and an impressive wine list. Service attentive and relaxed. Will be back. | £20-£40 | 2026-02-03 | No | Manchester, UK | Emma T. | 142

2 | yelp.co.uk | Harbour Lights Bistro | Great views, slightly slow service | 4 | Food was delicious — try the seabass — but our main took longer than expected. Staff apologetic and offered drinks on the house. | £25-£45 | 2026-02-02 | Yes | Brighton, UK | Mark L. | 87

3 | just-eat.co.uk | Spice House Express | Fast delivery, very tasty | 5 | Order arrived hot and on time. Generous portions and authentic flavours. Garlic naan especially good. | £8-£18 | 2026-02-04 | Yes | Leeds, UK | Aisha K. | 359

4 | deliveroo.co.uk | Green Spoon Salad Bar | Fresh and healthy | 4 | Great variety of toppings. Avocado was ripe. Packaging eco-friendly. Could use more protein options. | £6-£12 | 2026-02-01 | Yes | Bristol, UK | James R. | 64

5 | google.com | La Trattoria Roma | Warm atmosphere, authentic pasta | 5 | Homemade ricotta ravioli was outstanding. Staff recommended a lovely local wine. Cozy interior. | £18-£35 | 2026-02-03 | No | London, UK | Sofia P. | 512

6 | zomato.com | Kebab City | Quick bite, solid flavours | 3 | Good value for money, but meat slightly over-salted. Friendly counter staff and late hours are a plus. | £4-£10 | 2026-02-02 | Yes | Sheffield, UK | Omar H. | 221

7 | facebook.com | The Oak & Barrel | Birthday dinner success | 5 | They decorated our table and the tasting menu was superb. Live acoustic in the evening made it memorable. | £40-£70 | 2026-02-01 | No | Oxford, UK | Rebecca S. | 98

8 | time-out.com | Pan-Asian Alley | Trendy spot with bold flavours | 4 | Stylish decor and inventive small plates. Some dishes are hit-and-miss but overall highly recommended for groups. | £20-£45 | 2026-02-03 | No | Manchester, UK | Time Out Reviewer | 12

9 | thefork.co.uk | Riverside Grill | Fantastic steak and service | 5 | Perfectly cooked steak and stellar sommelier recommendations. Reservation timed perfectly and staff attentive. | £30-£60 | 2026-02-04 | No | Cambridge, UK | Oliver M. | 276

10 | squaremeal.co.uk | Urban Pantry | Reliable business lunch venue | 4 | Quiet midweek and efficient service. Sandwiches and salads were fresh. Good Wi‑Fi for working lunches. | £10-£22 | 2026-02-02 | No | London, UK | Corporate D. | 34

11 | foodhub.co.uk | Curry Corner | Value curry and punctual delivery | 5 | Excellent spice balance, huge portions and arrived within 30 minutes. Frequent promos make it great value. | £7-£15 | 2026-02-04 | Yes | Birmingham, UK | Neel P. | 410

12 | tripadvisor.co.uk | Seasons Brasserie | Elegant dining, seasonal menu | 5 | Seasonal tasting menu showcased local produce beautifully. Service professional and knowledgeable. | £45-£80 | 2026-02-03 | No | Edinburgh, UK | Claire D. | 198

13 | yelp.co.uk | Craft Coffee & Kitchen | Perfect brunch spot | 5 | Great espresso and avocado toast. Friendly baristas and plenty of plug sockets for remote work. | £4-£12 | 2026-02-02 | No | Bristol, UK | Hannah W. | 153

14 | just-eat.co.uk | Mama's Pizza | Thin crust, generous toppings | 4 | Pizza arrived hot with crisp base. Might need a touch more seasoning but overall family favourite. | £6-£18 | 2026-02-01 | Yes | Newcastle, UK | Liam G. | 522

15 | deliveroo.co.uk | Sushi Studio | Fresh sushi, neat presentation | 5 | Nigiri was melt-in-mouth. Rolls balanced and box arrived intact. Great for date night at home. | £12-£30 | 2026-02-04 | Yes | London, UK | Mai N. | 289

16 | google.com | The Garden Terrace | Lovely outdoor seating | 4 | Sunlit terrace and inventive cocktails. Food portion sizes a bit small but flavours good. | £15-£30 | 2026-02-02 | No | Cardiff, UK | Dylan F. | 74

17 | zomato.com | Veggie Delight | Great plant-based options | 5 | Imaginative vegan menu with bold flavours. Friendly staff explained allergens clearly. | £8-£20 | 2026-02-03 | Yes | Glasgow, UK | Priya S. | 134

18 | facebook.com | Stables Taproom | Cosy pub with craft ales | 4 | Excellent beer selection and warming shepherd's pie. Live quiz nights are fun but it gets busy. | £8-£20 | 2026-02-01 | No | Norwich, UK | Gareth P. | 61

19 | time-out.com | Retro Diner | Fun retro vibe | 3 | Nostalgic decor and decent burgers. Milkshakes a highlight but service was patchy during peak. | £7-£16 | 2026-02-04 | No | Liverpool, UK | Time Out Staff | 21

20 | thefork.co.uk | Bamboo Garden | Delicious dim sum selection | 5 | Dim sum platter perfect for sharing. Steamed buns were a standout. Manager checked in frequently. | £20-£40 | 2026-02-03 | No | London, UK | Wei L. | 347

21 | squaremeal.co.uk | Chef's Table | Fine dining, exceptional skill | 5 | Impeccable presentation and tasting menu that changes with ingredients. Perfect for special occasions. | £85-£150 | 2026-02-02 | No | Bath, UK | G. Harris | 29

22 | foodhub.co.uk | Fish & Chips HQ | Classic seaside flavour | 4 | Crispy batter and fluffy chips. Order was slightly delayed due to busy period but still hot on arrival. | £5-£12 | 2026-02-01 | Yes | Blackpool, UK | Sonia M. | 279

23 | tripadvisor.co.uk | The Greenhouse Café | Great for families | 4 | Kids menu varied and colouring packs kept the little ones busy. Healthy adult options available too. | £6-£18 | 2026-02-03 | No | Bournemouth, UK | Karen J. | 203

24 | yelp.co.uk | Bistro 27 | Creative menu, friendly staff | 5 | Tasting menu offered fantastic value. Staff explained each course with enthusiasm. | £35-£60 | 2026-02-04 | No | Edinburgh, UK | Tom S. | 112

25 | just-eat.co.uk | Tandoori Nights | Consistent favourite | 5 | Reliable favourite for curry nights. Generous sauces and fragrant rice. Always delivers on time. | £9-£20 | 2026-02-02 | Yes | Leicester, UK | Fatima R. | 688

26 | deliveroo.co.uk | Pasta Fresca | Handmade pasta at home | 5 | Pasta held up well in transit and sauce was rich and balanced. Portion generous for dinner. | £10-£25 | 2026-02-03 | Yes | London, UK | Nicola B. | 241

27 | google.com | Smokestack BBQ | Big flavours, relaxed vibe | 4 | Brisket was smoky and tender. Sides could be improved but overall great value for meat lovers. | £12-£28 | 2026-02-04 | No | Manchester, UK | Dan H. | 166

28 | zomato.com | Midtown Noodles | Comforting bowls of goodness | 4 | Broth deeply flavoured and noodles cooked perfectly. Could use more veg in portions. | £9-£16 | 2026-02-01 | Yes | Coventry, UK | Lina K. | 93

29 | facebook.com | The Lighthouse Café | Coastal breakfast spot | 5 | Freshly baked pastries and friendly service. Great spot for morning coffee with sea views. | £3-£12 | 2026-02-02 | No | Scarborough, UK | Oliver T. | 47

30 | time-out.com | Neon Tapas | Small plates, big personality | 4 | Fun cocktail menu and bold small plates. Best for sharing and late-night tapas hopping. | £18-£40 | 2026-02-03 | No | Leeds, UK | Time Out Reviewer | 15

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