# 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 spot with great pies | 4 | Lovely old pub atmosphere, steak and ale pie was perfectly seasoned. Service was friendly though waited 15 mins for a drink. Cosy beer garden. | £12-£25 | 2026-02-02 | No | Bristol, UK | Hannah T | 48

2 | yelp.co.uk | Saffron & Smoke | Bold flavours, small portions | 3 | Food well seasoned — incredible lamb chops — but portions are on the small side for the price. Lovely decor and attentive staff. | £20-£40 | 2026-02-03 | No | Manchester, UK | Owen R | 112

3 | just-eat.co.uk | Pasta Fresca | Quick delivery, fresh pasta | 5 | Ordered tagliatelle bolognese and garlic bread. Arrived hot within 28 minutes. Generous portion and authentic flavour. Will order again. | £8-£15 | 2026-02-04 | Yes | Leeds, UK | Maya S | 256

4 | deliveroo.co.uk | Bao & Bros | Soft baos, punchy sauces | 4 | Great variety of baos and sides. Delivery was on time, packaging kept things intact. Would like more vegan choices. | £6-£18 | 2026-02-03 | Yes | London, UK | Calum P | 389

5 | google.com | The Harbour Grill | Seafood excellence | 5 | Fantastic seafood platter and crisp chips. Friendly sommelier suggested perfect wine pairing. Slightly pricey but worth it. | £30-£60 | 2026-02-01 | No | Edinburgh, UK | Aisha K | 78

6 | zomato.com | Green Spoon | Healthy and tasty bowls | 4 | Build-your-own bowls are fresh and vibrant. Nice selection of dressings. Staff were helpful with allergen info. | £7-£13 | 2026-02-02 | Yes | Birmingham, UK | Liam J | 94

7 | facebook.com | The Old Lantern | Great Sunday roast | 5 | Sunday roast was exceptional — crisp roasties and succulent beef. Warm service and child-friendly. Will return next month. | £10-£22 | 2026-02-01 | No | Norwich, UK | Emma L | 63

8 | time-out.com | Neon Noodle | Trendy spot, long queues | 3 | Very Instagrammable interior. Flavours are solid but waited 40 minutes for a table. Good for a one-off visit. | £9-£18 | 2026-02-04 | No | London, UK | Sofia M | 134

9 | thefork.co.uk | Bistro 47 | Excellent service, great value | 5 | Three-course set menu excellent value. Staff attentive and helpful, desserts were a highlight. | £18-£35 | 2026-02-02 | No | Oxford, UK | Daniel W | 41

10 | squaremeal.co.uk | Cedar & Stone | Refined dining experience | 4 | Impeccable plating and interesting flavour combinations. Wine list impressive. A touch formal for casual nights. | £35-£70 | 2026-02-03 | No | Bath, UK | Priya N | 27

11 | foodhub.co.uk | Curry Cottage | Reliable takeout, bold curries | 4 | Spicy vindaloo hit the spot. Packaging kept rice separate. Delivery arrived within the promised window. | £6-£20 | 2026-02-04 | Yes | Leicester, UK | Ravi S | 198

12 | tripadvisor.co.uk | The Lantern Café | Perfect brunch spot | 5 | Avocado toast and flat white were superb. Relaxed vibe and friendly staff. Limited parking but worth a visit. | £6-£14 | 2026-02-02 | No | Cambridge, UK | Zoe H | 89

13 | yelp.co.uk | Tap & Smoke | Great craft beers, decent food | 4 | Excellent selection of local beers. Burgers were juicy; fries could be crispier. Lively atmosphere on weekends. | £10-£25 | 2026-02-03 | No | Brighton, UK | Marcus B | 221

14 | just-eat.co.uk | Falafel Corner | Fresh and fast | 5 | Falafel wrap was crunchy and full of flavour. Extras arrived as requested. Brilliant for a quick dinner. | £4-£9 | 2026-02-04 | Yes | Glasgow, UK | Nora G | 310

15 | deliveroo.co.uk | Sizzle Street | Satisfying late-night burgers | 4 | Burger stack was juicy and delivered hot. Fries were salted perfectly. Took slightly longer due to busy service. | £8-£16 | 2026-02-03 | Yes | Sheffield, UK | Ethan C | 143

16 | google.com | Maison du Pain | Exceptional patisserie | 5 | Delicious croissants and tarts, flaky pastry and great coffee. Small seating area but turnover is quick. | £3-£8 | 2026-02-02 | No | Bournemouth, UK | Claire V | 52

17 | zomato.com | Burger Atelier | Creative burger combos | 4 | Interesting toppings and good vegetarian options. Service friendly but kitchen was slow during peak time. | £9-£20 | 2026-02-01 | Yes | Newcastle, UK | Samir D | 167

18 | facebook.com | The Botanist | Lovely cocktails & atmosphere | 5 | Cocktails inventive and well balanced, staff explained ingredients. Great for celebrations or dates. | £12-£28 | 2026-02-04 | No | Cardiff, UK | Fiona P | 205

19 | time-out.com | Spice Route | Vibrant flavours, bit noisy | 4 | Authentic regional dishes with bold spices. Restaurant gets loud at peak times but the food is the star. | £15-£30 | 2026-02-03 | No | Nottingham, UK | Oliver K | 76

20 | thefork.co.uk | Harbourview | Stunning views, solid menu | 4 | Great location overlooking the marina. Seafood mains fresh; desserts were a little over-sugared for our taste. | £25-£55 | 2026-02-02 | No | Southampton, UK | Leah M | 34

21 | squaremeal.co.uk | Oak & Ember | Robust grilling and great service | 5 | Perfectly grilled steaks and smoky sides. Staff knowledgeable about doneness and pairings. | £28-£60 | 2026-02-01 | No | York, UK | Gareth S | 58

22 | foodhub.co.uk | Mama's Kitchen | Comfort food like home | 5 | Homely portions and friendly owner. Shephard's pie felt homemade — a true comfort meal. | £7-£14 | 2026-02-04 | Yes | Portsmouth, UK | Molly R | 142

23 | tripadvisor.co.uk | La Piccola | Authentic Italian, warm staff | 4 | Handmade pasta was excellent; tiramisu rich and creamy. Cosy interior, booking recommended on weekends. | £18-£36 | 2026-02-03 | No | Oxford, UK | Marco B | 95

24 | yelp.co.uk | Sushi Harbor | Fresh sushi and quick service | 5 | Sashimi melt-in-mouth fresh. Friendly chefs and efficient front-of-house. Great for both lunch and dinner. | £10-£30 | 2026-02-02 | Yes | London, UK | Yuki N | 276

25 | just-eat.co.uk | Pizza Pronto | Hot pizza, generous toppings | 4 | Thin crust margherita with extra basil was crisp and flavourful. Delivery driver polite. A little oily but tasty. | £6-£14 | 2026-02-04 | Yes | Swansea, UK | Connor H | 184

26 | deliveroo.co.uk | Vegan Vibes | Innovative plant-based dishes | 5 | Creative menu and satisfying textures. Great for new vegans and seasoned plant-eaters alike. | £8-£18 | 2026-02-03 | Yes | Bristol, UK | Ameera Z | 211

27 | google.com | The Ivy Cottage | Cosy afternoon tea | 4 | Lovely selection of sandwiches and scones. Tea refill generous. Table near window was chilly though. | £15-£30 | 2026-02-01 | No | Winchester, UK | Patricia Q | 69

28 | zomato.com | Tandoori Trails | Classic curries, bold spice | 4 | Rich sauces and tender meat. Rice could be fluffier but overall very satisfying. Good value for portions. | £9-£22 | 2026-02-02 | Yes | Hull, UK | Imran H | 123

29 | facebook.com | The Green Fox | Family-friendly and tasty | 5 | Kids menu generous and the adult mains were fresh. Nice outdoor play area and friendly staff. | £9-£20 | 2026-02-04 | No | Milton Keynes, UK | Sara D | 88

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