# 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 Copper Kettle | Charming local pub with great pies | 4.0 | Warm atmosphere, helpful staff and the steak and ale pie was excellent. Busy weekend but service stayed friendly. Would visit again. | £10-£25 | 2026-01-31 | No | Bath, UK | EmmaHampshire | 48

2 | yelp.co.uk | Saffron Garden | Tasty curries but slow service | 3.5 | Flavours are authentic and portions generous. Wait for a table and food took longer than expected — still worth trying for the lamb bhuna. | £8-£18 | 2026-02-02 | Yes | Leeds, UK | MarkJ_85 | 132

3 | just-eat.co.uk | Bella Pizza | Hot and fast delivery | 4.5 | Margherita and quattro stagioni arrived piping hot within 30 minutes. Good crust and fresh toppings. Driver polite. | £6-£14 | 2026-02-03 | Yes | Manchester, UK | SophieR | 21

4 | deliveroo.co.uk | Green Spoon Vegan | Creative vegan dishes | 4.0 | Loved the jackfruit burger and quinoa salad. Packaging eco-friendly. Delivery window was accurate. | £7-£15 | 2026-02-03 | Yes | Bristol, UK | OliverV | 64

5 | google.com | Harbour Lights Bistro | Great views, average mains | 3.0 | Stunning waterfront setting but mains were a bit bland. Service attentive. Good for cocktails at sunset though. | £15-£35 | 2026-01-30 | No | Brighton, UK | Claire P | 256

6 | zomato.com | Taco Republic | Best tacos in town | 4.8 | Fantastic pork al pastor and zesty slaw. Friendly staff and lively music. Reasonable prices for the quality. | £6-£12 | 2026-02-01 | Yes | Birmingham, UK | FoodieTom | 198

7 | facebook.com | Nobu Lane | Elegant dining, splurge-worthy | 4.7 | Exceptional sushi and tasting menu. Perfect for special occasions. Reservations highly recommended. | £40-£90 | 2026-01-29 | No | London, UK | Aisha R | 89

8 | time-out.com | Smokestack BBQ | Authentic smokehouse flavours | 4.3 | Ribs fall-off-the-bone and brisket full of flavour. Sides are great; atmosphere casual and fun. | £12-£28 | 2026-02-02 | No | Glasgow, UK | TimeoutReviewer | 34

9 | thefork.co.uk | Le Petit Jardin | Romantic spot, seasonal menu | 4.6 | Delicate dishes, lovely wine list and attentive sommelier. A bit pricey but high quality. | £30-£60 | 2026-02-01 | No | Oxford, UK | JeanM | 74

10 | squaremeal.co.uk | The Victorian Tap | Reliable gastropub | 4.1 | Good Sunday roast and varied beer selection. Family friendly with great desserts. | £10-£30 | 2026-02-03 | No | Cambridge, UK | SimonL | 52

11 | foodhub.co.uk | Mama Leone | Large portions, authentic flavours | 4.4 | Generous pasta dishes and friendly owner. Delivery arrived warm and complete. | £7-£16 | 2026-02-03 | Yes | Newcastle, UK | NatalieG | 40

12 | tripadvisor.co.uk | Seaview Fish & Chips | Classic seaside chippy | 4.2 | Crispy batter and fluffy chips. Long queue but turnover quick. Great with a seaside stroll. | £5-£12 | 2026-01-30 | No | Scarborough, UK | PaulW | 310

13 | yelp.co.uk | Café Lumière | Cozy café with excellent coffee | 4.6 | Baristas know their craft; pastries fresh. Small seating but pleasant for a morning catch-up. | £3-£8 | 2026-02-02 | No | Edinburgh, UK | LenaK | 58

14 | just-eat.co.uk | Dragon Express | Quick takeaway, flavours hit the spot | 3.9 | Good value for money and speedy delivery. Some dishes lacked heat but overall satisfying. | £4-£14 | 2026-02-04 | Yes | Sheffield, UK | MohammedA | 17

15 | deliveroo.co.uk | Sushi Hana | Fresh sushi, neat presentation | 4.5 | Beautifully presented sushi platters. Delivery packaging prevented squashing. Perfect for lunch. | £10-£40 | 2026-02-03 | Yes | Liverpool, UK | YukiN | 145

16 | google.com | The Green Fork | Healthy, tasty bowls | 4.3 | Customisable bowls with lots of veg options. Efficient ordering and clear allergen info. | £6-£12 | 2026-02-01 | Yes | Bristol, UK | DanielleW | 67

17 | zomato.com | La Baguette | Perfect croissants and baguettes | 4.9 | Flaky pastries and crusty bread baked on site daily. Always a queue for morning pastries — worth it. | £1.50-£6 | 2026-02-02 | No | Bristol, UK | PierreL | 222

18 | facebook.com | The Old Vicarage | Lovely Sunday roast experience | 4.4 | Roast beef cooked to perfection with crisp roasties. Warm hospitality from staff. | £12-£27 | 2026-01-31 | No | York, UK | HannahS | 63

19 | time-out.com | Neon Dumpling | Inventive street-food style dumplings | 4.2 | Bold flavours and fun sauces. Great late-night option with a lively crowd. | £5-£11 | 2026-02-02 | No | London, UK | TimeoutEditor | 105

20 | thefork.co.uk | Casa Verde | Family-run Italian delights | 4.0 | Warm welcome and homely pasta. Simple desserts but very satisfying overall. | £10-£22 | 2026-01-30 | No | Reading, UK | MarcoF | 29

21 | squaremeal.co.uk | The Borough Grill | Consistent steaks and cocktails | 4.3 | Steak cooked to request and inventive cocktails. Noise levels high on weekends. | £20-£45 | 2026-02-03 | No | Bournemouth, UK | ClaireT | 81

22 | foodhub.co.uk | Punjabi Palace | Rich curries, great value | 4.5 | Deep flavours and good heat. Delivery arrived with all sides and chutneys. | £6-£16 | 2026-02-04 | Yes | Slough, UK | ArjunK | 37

23 | tripadvisor.co.uk | Riverside Brasserie | Elegant lunch by the river | 4.1 | Great salads and fish dishes. Service slightly formal but professional, good for business lunches. | £18-£40 | 2026-01-31 | No | Cambridge, UK | BusinessTraveller | 191

24 | yelp.co.uk | The Grain Store | Brunch destination | 4.7 | Creative brunch menu with standout shakshuka. Booking recommended on weekends. | £8-£20 | 2026-02-01 | No | Manchester, UK | AlexB | 154

25 | just-eat.co.uk | Falafel House | Fresh and flavourful wraps | 4.6 | Generous fillings and zesty tahini. Excellent for a quick lunch delivered hot. | £4-£9 | 2026-02-04 | Yes | Leicester, UK | Samiya | 28

26 | deliveroo.co.uk | Pasta Pronto | Comforting pasta for a weekday dinner | 4.0 | Simple but reliable carbonara and pesto options. Portions filling and well seasoned. | £7-£14 | 2026-02-03 | Yes | Coventry, UK | RajP | 76

27 | google.com | The Botanist | Stylish cocktails and small plates | 4.2 | Beautiful interior and inventive cocktails. Small plates are flavoursome but pricey. | £12-£30 | 2026-02-02 | No | Cardiff, UK | LydiaM | 138

28 | zomato.com | Kebabi | Quick kebabs after a night out | 3.8 | Generous kebab fillings and good sauces. Not the cleanest venue but great late-night fuel. | £4-£9 | 2026-02-01 | Yes | Bristol, UK | NightOwl | 92

29 | facebook.com | Miso Modern Asian | Beautiful plating, bold flavours | 4.5 | Dishes balanced and well executed. Friendly staff and good wine pairing suggestions. | £18-£45 | 2026-01-30 | No | Exeter, UK | Samantha_R | 55

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