# 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 | Cosy spot with great pies | 4.0 | Warm atmosphere, excellent steak and ale pie. Service was friendly though a little slow at peak time. Good selection of local ales. | ££ | 2026-02-02 | No | Bristol, UK | Emma J | 86

2 | yelp.co.uk | Saffron Street Kitchen | Authentic flavours, generous portions | 4.5 | Vibrant curry dishes and fresh naan. Heat levels spot on. Staff very helpful with allergy queries. | ££ | 2026-02-03 | Yes | Leeds, UK | Owen P | 142

3 | just-eat.co.uk | Bella Pasta | Perfect takeaway pasta | 4.0 | Arrived hot and on time. Carbonara was creamy and portions large. Garlic bread could be crispier. | £ | 2026-02-04 | Yes | Manchester, UK | Sophie L | 219

4 | deliveroo.co.uk | Green Fork | Fresh salads, speedy delivery | 4.2 | Great for a healthy lunch — textures and dressings balanced. Delivered within 25 minutes. | ££ | 2026-02-03 | Yes | London, UK | Marcus R | 57

5 | google.com | The Harbour Grill | Top seafood and riverside views | 4.6 | Impressive scallops and attentive sommelier. Bit pricey but worth it for special occasions. | £££ | 2026-02-01 | No | Plymouth, UK | Hannah W | 374

6 | zomato.com | Flat Iron & Co | Great steaks for the price | 4.3 | Quality steak and simple sides. Minimal desserts but overall excellent value for money. | ££ | 2026-02-02 | No | Edinburgh, UK | Callum S | 198

7 | facebook.com | The Old Mill Café | Lovely brunch spot | 4.1 | Friendly staff and a relaxed vibe. Eggs Benedict exceptional. Busy on weekends so book ahead. | £ | 2026-02-04 | No | Bath, UK | Lara N | 61

8 | time-out.com | Neon Bao | Trendy bao with punchy sauces | 4.0 | Fun sharing plates and creative cocktails. Loud on Friday nights but excellent flavours. | ££ | 2026-02-01 | Yes | Birmingham, UK | Time Out Reviewer | 312

9 | thefork.co.uk | Maison de Pierre | Elegant dining, small portions | 3.8 | Beautifully plated dishes but portions were on the small side. Service polished. | £££ | 2026-02-02 | No | Oxford, UK | Claire M | 89

10 | squaremeal.co.uk | The Roof Terrace | Stylish venue for cocktails | 4.4 | Superb city views and inventive cocktails. Food menu is limited but tasty. | £££ | 2026-02-03 | No | Cardiff, UK | Dylan K | 144

11 | foodhub.co.uk | Spice Villa | Reliable curry takeaway | 4.1 | Consistently good curries and generous rice portions. Friendly driver and well packaged. | £ | 2026-02-04 | Yes | Leicester, UK | Maya T | 128

12 | tripadvisor.co.uk | Seaside Bistro | Great Sunday roast by the sea | 4.5 | Roast beef cooked perfectly with crisp roasties. Excellent children's menu and view. | ££ | 2026-02-02 | No | Brighton, UK | Alan G | 203

13 | yelp.co.uk | Mama's Dumplings | Best dumplings in town | 4.7 | Handmade dumplings bursting with flavour. Queue is worth the wait. | £ | 2026-02-03 | Yes | Liverpool, UK | Priya S | 321

14 | just-eat.co.uk | Burrito Brothers | Fast, filling and tasty | 4.0 | Fresh tortillas and generous fillings. Salsa packs give it a nice kick. | £ | 2026-02-04 | Yes | Newcastle, UK | Tom H | 76

15 | deliveroo.co.uk | Woodfire Pizzeria | Authentic Neapolitan pizza | 4.6 | Thin crust and blistered edges; authentic toppings and melt-in-mouth mozzarella. | ££ | 2026-01-31 | Yes | Bristol, UK | Isabel Q | 412

16 | google.com | The Vegan Orchard | Creative plant-based tasting menu | 4.2 | Inventive dishes that even non-vegans enjoyed. Slightly long waiting times between courses. | £££ | 2026-02-01 | No | Brighton, UK | Noah K | 95

17 | zomato.com | Tokyo Lane | Sushi masters at work | 4.8 | Exceptionally fresh fish and precise rice. Intimate setting and knowledgeable staff. | £££ | 2026-02-02 | No | London, UK | Yuki M | 527

18 | facebook.com | The Green Dragon | Classic pub, friendly locals | 4.0 | Great selection of ales and pub grub. Quiz night is a fun community event. | £ | 2026-02-03 | No | York, UK | Gareth P | 73

19 | time-out.com | Midnight Noodles | Late-night comfort food | 4.3 | Perfect for post-concert cravings. Bold broths and generous portions. | £ | 2026-02-02 | Yes | Manchester, UK | Time Out Reviewer | 188

20 | thefork.co.uk | Olive & Thyme | Charming bistro with seasonal menu | 4.5 | Seasonal produce shines. Service attentive and wine pairings recommended. | ££ | 2026-02-04 | No | Cambridge, UK | Juliette R | 156

21 | squaremeal.co.uk | Brass & Barrel | Modern British dishes, well executed | 4.1 | Clean flavours and contemporary plating. Slightly loud interiors but good for groups. | ££ | 2026-02-01 | No | Birmingham, UK | Ethan L | 132

22 | foodhub.co.uk | Curry Corner | Spicy and satisfying | 3.9 | Decent spice levels but presentation inconsistent. Generous portions for the price. | £ | 2026-02-03 | Yes | Sheffield, UK | Aisha R | 54

23 | tripadvisor.co.uk | Luna Tapas | Great for groups and sharing | 4.4 | Tapas plates are flavourful and varied. Booking recommended on weekends. | ££ | 2026-02-04 | No | Bristol, UK | Marco D | 278

24 | yelp.co.uk | Pancake Haven | Sweet and savoury pancakes | 4.2 | Incredible breakfast menu with creative toppings. Service friendly and quick. | £ | 2026-02-02 | No | Glasgow, UK | Fiona B | 101

25 | just-eat.co.uk | Asia Express | Reliable Chinese takeaway | 3.8 | Good value for money though some dishes arrived a bit soggy. Flavours still decent. | £ | 2026-02-03 | Yes | Milton Keynes, UK | Kevin S | 64

26 | deliveroo.co.uk | Falafel House | Crispy falafels and fresh hummus | 4.5 | Perfectly seasoned falafels and creamy hummus. Packaging kept everything intact. | £ | 2026-02-04 | Yes | Leicester, UK | Rita H | 210

27 | google.com | The Garden Terrace | Peaceful spot for afternoon tea | 4.3 | Lovely garden setting and delicate sandwiches. Scones were slightly dry but overall charming. | ££ | 2026-02-01 | No | Winchester, UK | Simon V | 68

28 | zomato.com | Burger Atelier | Gourmet burgers with flair | 4.6 | Excellent buns and inventive toppings. Sides well seasoned and generous. | ££ | 2026-02-02 | Yes | Bristol, UK | Leah F | 334

29 | facebook.com | The Little Deli | Great sandwiches and cakes | 4.0 | Homemade cakes and artisanal sandwiches. Small seating but friendly proprietors. | £ | 2026-02-04 | No | St Albans, UK | Diane O | 46

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