# 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 Harbour Bistro | Excellent seafood and harbour views | 5 | Fresh oysters, attentive staff and a stunning sunset view. Portions generous and flavours well balanced. Will return. | £25-£40 | 2026-02-02 | No | Brighton | Emma T | 142

2 | yelp.co.uk | Blue Corner Pizza | Great late-night slices | 4 | Crispy base and inventive toppings. Busy on weekends but friendly service. Pepperoni slightly oily this time. | £5-£12 | 2026-02-03 | Yes | Manchester | Liam R | 68

3 | just-eat.co.uk | Spice House Indian | Consistently tasty curries | 4 | Delivery arrived hot and on time. Butter chicken creamy and naan soft. Could be a little spicier. | £10-£25 | 2026-02-04 | Yes | Leeds | Priya S | 254

4 | deliveroo.co.uk | Green Fork Salad Bar | Fresh, healthy and fast | 5 | Salads packed well, lots of crunchy toppings and great dressing choices. Perfect for a work lunch. | £6-£11 | 2026-02-03 | Yes | London | Oliver M | 89

5 | google.com | La Petite Patisserie | Perfect pastries every time | 5 | Croissants flaky and buttery, friendly staff and cosy seating. Great coffee too. | £3-£8 | 2026-02-01 | No | Bristol | Sophie H | 321

6 | zomato.com | Sakura Sushi | Fresh sushi, neat presentation | 4 | Good value lunch set. Fish tasted fresh; wait time reasonable. Would like slightly more variety. | £12-£30 | 2026-02-04 | Yes | Edinburgh | Hiro K | 56

7 | facebook.com | The Old Oak Pub | Friendly local with great roast | 5 | Sunday roast was superb — perfectly cooked beef and proper gravy. Welcoming atmosphere. | £12-£22 | 2026-02-02 | No | Oxford | Mark P | 197

8 | time-out.com | Neon Burger Co | Trendy spot, tasty burgers | 4 | Creative toppings and good fries. Can be noisy on Friday nights but food quality is solid. | £8-£15 | 2026-02-03 | No | London | Ava K | 134

9 | thefork.co.uk | Riverside Thai | Authentic flavours by the river | 5 | Pad Thai balanced perfectly, jasmine rice fragrant. Pleasant riverside seating. | £15-£30 | 2026-02-01 | Yes | Cambridge | Daniel S | 78

10 | squaremeal.co.uk | Maison du Vin | Exceptional tasting menu | 5 | Impeccable service and wine pairing. Each course thoughtfully executed. | £60-£95 | 2026-02-02 | No | London | Charlotte G | 42

11 | foodhub.co.uk | Mama Rosa's | Homely Italian, great value | 4 | Generous portions and friendly delivery driver. Lasagne slightly salty but overall satisfying. | £9-£18 | 2026-02-04 | Yes | Sheffield | Marco L | 110

12 | tripadvisor.co.uk | Coastline Café | Relaxed spot with great brunch | 4 | Avocado toast very fresh and good coffee. Service a bit slow at peak times. | £7-£14 | 2026-02-03 | No | Newquay | Rachel W | 88

13 | yelp.co.uk | The Vegan Violet | Creative plant-based dishes | 5 | Innovative menu and flavours packed in each dish. Friendly staff explained options well. | £10-£20 | 2026-02-02 | Yes | Brighton | Zoe N | 95

14 | just-eat.co.uk | Curry Leaf Express | Fast delivery, fragrant curries | 4 | Good portion sizes and heat level accurate. Rice a little clumped from delivery packaging. | £8-£20 | 2026-02-03 | Yes | Birmingham | Aamir K | 189

15 | deliveroo.co.uk | Mediterraneo Grill | Tasty kebabs and dips | 4 | Meat well seasoned and flatbreads warm. Dips generous, though salad a bit limp. | £7-£16 | 2026-02-04 | Yes | Liverpool | Hannah D | 47

16 | google.com | Café Lumen | Quiet café, excellent cakes | 5 | Homemade banana bread and polite staff. Good spot for studying. | £2-£6 | 2026-02-01 | No | Norwich | Ben C | 212

17 | zomato.com | El Taqueria | Authentic Mexican flavours | 5 | Soft tacos with smoky salsa, great drink pairing options. Lively atmosphere. | £8-£20 | 2026-02-02 | Yes | London | Miguel F | 63

18 | facebook.com | The Garden Brasserie | Lovely garden seating | 4 | Beautiful outdoor area and solid mains. Service slightly distracted during event night. | £18-£35 | 2026-02-03 | No | York | Fiona L | 53

19 | time-out.com | Saffron & Smoke | Bold flavours, stylish interior | 5 | Grilled aubergine starter was a highlight. Good cocktails and attentive bar staff. | £20-£40 | 2026-02-04 | No | Edinburgh | Connor J | 71

20 | thefork.co.uk | Brasserie du Parc | Classic French done well | 5 | Consistent quality, delicate sauces and excellent service. Ideal for special occasions. | £35-£70 | 2026-02-02 | No | Bath | Isabelle R | 38

21 | squaremeal.co.uk | The Chef's Table | Inventive tasting, excellent plating | 5 | Each course a visual and flavour success. Sommelier recommendations spot on. | £80-£120 | 2026-02-01 | No | London | Peter A | 27

22 | foodhub.co.uk | Sunrise Diner | Classic breakfasts, friendly staff | 4 | Eggs cooked perfectly and bacon crisp. Coffee refill would be welcome. | £4-£10 | 2026-02-03 | Yes | Cardiff | Nia P | 141

23 | tripadvisor.co.uk | The Spice Merchant | Vibrant menu, good service | 4 | Bold spice combinations and prompt service. A touch pricey for portion sizes. | £18-£30 | 2026-02-04 | No | Bristol | Owen H | 99

24 | yelp.co.uk | Little Seoul | Authentic Korean BBQ | 5 | Great marinated meat and attentive table-side grilling. Fun experience with friends. | £20-£45 | 2026-02-03 | No | Glasgow | Min J | 82

25 | just-eat.co.uk | Pasta Fresca | Fresh pasta delivered hot | 4 | Penne al pesto had lovely basil flavour; delivery packaging kept it intact. | £9-£16 | 2026-02-02 | Yes | Milton Keynes | Oliver B | 150

26 | deliveroo.co.uk | Falafel House | Crisp falafels, zesty sauces | 5 | Excellent textures and generous portions of hummus. Vegan-friendly and tasty. | £6-£13 | 2026-02-04 | Yes | Leicester | Sara M | 64

27 | google.com | Rooftop Lounge | Amazing skyline views | 4 | Drinks are pricey but the sunset panorama is worth it. Food is decent for a rooftop bar. | £10-£30 | 2026-02-03 | No | Bournemouth | James K | 178

28 | zomato.com | Bistro Verde | Seasonal produce, great flavours | 5 | Menu changes each week; fresh vegetables shine. Staff knowledgeable about menu. | £22-£45 | 2026-02-01 | No | Exeter | Maya V | 39

29 | facebook.com | The Lantern Eatery | Cozy spot with great soups | 4 | Perfect for a rainy day — soups rich and warming. Cakes looked tempting. | £4-£12 | 2026-02-02 | Yes | Swansea | Dylan R | 60

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