# 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 Pot | Excellent neighbourhood gem | 5 | Fantastic food and friendly service. The fish pie was rich and the portion generous. Cosy atmosphere and reasonable wine list. | ££ | 2026-02-02 | No | Bath, UK | Emma J. | 124

2 | yelp.co.uk | Spice & Sizzle | Vibrant flavours, quick service | 4 | Great Indian tapas style dishes. Spicy lamb chops were outstanding. A little noisy but service was swift. Would return. | ££ | 2026-02-03 | Yes | Bristol, UK | Liam R. | 58

3 | just-eat.co.uk | Pasta Fresca | Reliable midweek dinner | 4 | Pasta al pesto arrived warm, portion size good. Garlic bread a touch oily but tasty. Delivery within estimated time. | £ | 2026-02-01 | Yes | Leeds, UK | Sophie M. | 212

4 | deliveroo.co.uk | Green Fork | Healthy and fresh | 5 | Salad bowl was crisp with a great dressing. Avocado smash very freshly prepared. Packaging kept everything intact. | ££ | 2026-02-04 | Yes | London, UK | Oscar D. | 89

5 | google.com | The Old Lantern | Charming venue, attentive staff | 5 | Beautifully presented mains and a knowledgeable sommelier. Dessert was the highlight. Book ahead at weekends. | £££ | 2026-02-03 | No | Edinburgh, UK | A. Patel | 341

6 | zomato.com | Burger Barn | Classic burger done well | 4 | Juicy beef patty and crisp bun. Sweet potato fries were excellent. Could improve on milkshake consistency. | £ | 2026-02-02 | Yes | Manchester, UK | Dean K. | 176

7 | facebook.com | La Trattoria Roma | Family favourite | 5 | Authentic flavors, generous portions and friendly staff. Kids menu appreciated. Parking nearby. | ££ | 2026-02-01 | No | Glasgow, UK | Maria G. | 47

8 | time-out.com | Skyline Rooftop | Great views, slightly pricey | 4 | Stunning panoramic views. Cocktails are creative but on the expensive side. Food quality justifies the splurge occasionally. | £££ | 2026-02-02 | No | Brighton, UK | Time Out Critic | 22

9 | thefork.co.uk | Harbour Bistro | Perfect for date night | 5 | Intimate setting, attentive wait staff and beautifully plated seafood. Tasting menu recommended. | £££ | 2026-02-03 | No | Norwich, UK | Claire H. | 64

10 | squaremeal.co.uk | The Gable | Consistently good modern British | 4 | Menu changes seasonally. Lamb main was tender and well seasoned. Service professional. | ££ | 2026-02-04 | No | Oxford, UK | Restaurant Reviewer | 39

11 | foodhub.co.uk | Kebab King | Great value late-night option | 4 | Generous portions and sauces packed with flavour. Meat well seasoned. Perfect after a night out. | £ | 2026-02-02 | Yes | Sheffield, UK | Jordan P. | 98

12 | tripadvisor.co.uk | Seaview Grill | Fresh seafood with a view | 5 | Scallops were perfectly seared. Friendly staff and excellent local wine pairings. A bit windy on the terrace. | £££ | 2026-02-01 | No | Cornwall, UK | Nina T. | 289

13 | yelp.co.uk | The Vegan Spoon | Creative vegan menu | 5 | Innovative dishes that even non-vegans will love. The jackfruit tacos were a highlight. Lovely ambience. | ££ | 2026-02-04 | Yes | Bristol, UK | Harpreet S. | 74

14 | just-eat.co.uk | Sizzle House | Fast and tasty takeaway | 3 | Food was hot and flavoursome but rice was slightly dry. Delivery driver polite. Reasonable value for portions. | £ | 2026-02-03 | Yes | Newcastle, UK | Tom W. | 153

15 | deliveroo.co.uk | Dim Sum Corner | Authentic small plates | 5 | Delicate dumplings and silky sauces. Arrived promptly and still hot. Great for sharing. | ££ | 2026-02-02 | Yes | London, UK | Yi L. | 205

16 | google.com | The Rustic Fork | Warm welcome and hearty food | 4 | Hearty pies and seasonal veg. Service was friendly but slightly slow on a busy evening. | ££ | 2026-02-01 | No | York, UK | David K. | 198

17 | zomato.com | Sushi Maniac | Fresh sashimi, neat presentation | 5 | Sashimi melts in your mouth. Rice texture spot on. Could expand hot dish selection but excellent overall. | £££ | 2026-02-03 | Yes | Cambridge, UK | Aiko H. | 132

18 | facebook.com | The Ale House | Great pub food and craft ales | 4 | Excellent selection of local ales and a tasty pie. Live music nights add to atmosphere. | £ | 2026-02-04 | No | Cardiff, UK | Ben S. | 56

19 | time-out.com | Nomad Street Food | Street food with a gourmet twist | 5 | Bold flavours and fast service. Perfect for quick lunches. Portions generous and innovative. | £ | 2026-02-02 | Yes | Manchester, UK | Time Out Editor | 18

20 | thefork.co.uk | Olive & Thyme | Quiet gem, beautiful starters | 5 | Starter selection was outstanding. Great vegetarian options and attentive team. Ideal for celebrations. | ££ | 2026-02-03 | No | Winchester, UK | Rachel P. | 77

21 | squaremeal.co.uk | The Conservatory | Stylish venue for menus and events | 4 | Stylish interior and polished service. Food presentation excellent, prices reflect quality. | £££ | 2026-02-01 | No | Birmingham, UK | Venue Specialist | 31

22 | foodhub.co.uk | Pizza Piazza | Wood-fired perfection | 5 | Thin crust and smoky flavour. Toppings generous and delivered hot. Great family option. | £ | 2026-02-04 | Yes | Southampton, UK | L. Adams | 421

23 | tripadvisor.co.uk | Highland Deli | Authentic Scottish flavours | 4 | Haggis bon bons were surprisingly delicate. Excellent whisky selection. Cozy atmosphere in colder months. | ££ | 2026-02-02 | No | Inverness, UK | Gordon M. | 67

24 | yelp.co.uk | Curry Leaf | Bold spice, friendly staff | 5 | Rich, well-balanced curries and fluffy naan. Staff gave great recommendations. Booking recommended on weekends. | ££ | 2026-02-03 | Yes | Leicester, UK | Aisha K. | 204

25 | just-eat.co.uk | Falafel House | Tasty and affordable | 4 | Falafel wrap packed with flavour. Sauce portions generous. Delivery slightly late but still warm. | £ | 2026-02-01 | Yes | London, UK | Omar N. | 344

26 | deliveroo.co.uk | Pancake Parlour | Brunch done right | 5 | Fluffy pancakes and creative toppings. Coffee strong and well made. Quick delivery preserved texture. | ££ | 2026-02-02 | Yes | Brighton, UK | Hannah L. | 158

27 | google.com | Bistro Lumière | Elegant French cooking | 5 | Refined flavours and polished service. The duck confit was memorable. Great for special occasions. | £££ | 2026-02-04 | No | St Albans, UK | Marc R. | 263

28 | zomato.com | Tapas Terrace | Variety and vibrant sharing plates | 4 | Good mix of small plates to share. Some dishes were saltier than expected, but overall enjoyable. | ££ | 2026-02-01 | Yes | Liverpool, UK | Sofia V. | 91

29 | facebook.com | The Tea House | Lovely afternoon tea | 5 | Selection of sandwiches and scones was fresh. Service attentive and ambience relaxing. Perfect gift idea. | ££ | 2026-02-03 | No | Canterbury, UK | Eleanor D. | 142

30 | time-out.com | Fjord Seafood | Scandinavian influences shine | 5 | Clean flavours and minimalist presentation. Fish sourced sustainably and cooked to perfection. | £££ | 2026-02-02 | No | Norwich, UK | Time Out Reviewer | 27

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