# Extract and categorize data on bars and restaurants from websites

Extract valuable insights on bars and restaurants effortlessly — automated data collection that outshines manual efforts

Archived sample configuration. Sample data is illustrative, not live data.

Build this in Jsonify: https://factory.jsonify.com/setup?q=Extract+and+categorize+data+on+bars+and+restaurants+from+websites

## Goal

Extract and categorize data on bars and restaurants from websites

## Sources

- tripadvisor.co.uk

- justeat.co.uk

- deliveroo.co.uk

- yelp.co.uk

- zomato.com

- squaremeal.co.uk

- designmynight.com

- timeout.com

- google.com

- berlinfoodstories.com

## Sample data

id | Source | Restaurant | Category | Location | Rating | Reviews | Price Range | Last Updated | Reservation Status

1 | tripadvisor.co.uk | The Narrowboat Pub & Kitchen | Gastropub | Camden, London | 4.5 | 842 | ££ | 2026-02-02 | Available - walk-ins & bookings

2 | justeat.co.uk | Spice Garden Takeaway | Indian | Brixton, London | 4.2 | 1,204 | £ | 2026-02-03 | Delivery only - pre-order available

3 | deliveroo.co.uk | Mamma Rosa Pizzeria | Pizza | Shoreditch, London | 4.6 | 678 | ££ | 2026-02-01 | Collection & Delivery - no reservations

4 | yelp.co.uk | Green Table Vegan Cafe | Vegan | Manchester City Centre | 4.7 | 1,093 | ££ | 2026-02-04 | Recommended to reserve (limited seating)

5 | zomato.com | Sushi Harbor | Japanese | Bristol Harbourside | 4.4 | 415 | £££ | 2026-02-03 | Reservations required for weekend slots

6 | squaremeal.co.uk | Bistronomy at The Docks | Modern European | Leeds Waterfront | 4.3 | 232 | £££ | 2026-02-02 | Booked often - reserve online

7 | designmynight.com | Electric Rooftop Bar | Cocktail Bar | Birmingham City Centre | 4.1 | 989 | ££ | 2026-02-04 | Reservations available (tables limited)

8 | timeout.com | La Petite Brasserie | French | Edinburgh Old Town | 4.5 | 556 | ££ | 2026-02-01 | Recommended - book ahead

9 | google.com | The Green Fork | Healthy Cafe | Glasgow West End | 4.6 | 1,321 | £ | 2026-02-03 | Walk-ins preferred, phone bookings accepted

10 | berlinfoodstories.com | Kiez Kebap House | Street Food | Prenzlauer Berg, Berlin | 4.4 | 1,112 | € | 2026-02-02 | No reservations - counter service

11 | tripadvisor.co.uk | Harbourview Brasserie | Seafood | Brighton Marina | 4.2 | 742 | £££ | 2026-02-04 | Reservations recommended weekends

12 | justeat.co.uk | The Curry Pot | Bangladeshi | Tower Hamlets, London | 4.0 | 1,450 | £ | 2026-02-03 | Delivery & collection - no table service

13 | deliveroo.co.uk | Bao & Co. | Taiwanese | Central London | 4.8 | 2,034 | ££ | 2026-02-02 | Collection & delivery only

14 | yelp.co.uk | The Railway Arms | Pub Food | Oxford City Centre | 4.3 | 623 | ££ | 2026-02-01 | Walk-ins welcome, reserve for groups

15 | zomato.com | Café del Mar | Mediterranean | Nottingham Riverside | 4.1 | 378 | ££ | 2026-02-04 | Reservations accepted online

16 | squaremeal.co.uk | Oak & Ember | Steakhouse | Bristol City Centre | 4.6 | 489 | £££ | 2026-02-03 | High demand - book in advance

17 | designmynight.com | Neon Nights Club & Kitchen | Late-night | Leicester, St. George's | 4.0 | 311 | ££ | 2026-02-02 | Table bookings for events only

18 | timeout.com | The Conservatory | Afternoon Tea | Bath City Centre | 4.7 | 1,024 | ££ | 2026-02-03 | Reservation required

19 | google.com | Pasta Fresca | Italian | Cambridge City Centre | 4.5 | 842 | ££ | 2026-02-04 | Bookings advised for dinner

20 | berlinfoodstories.com | Brat & Beet | Modern German | Kreuzberg, Berlin | 4.3 | 506 | €€ | 2026-02-01 | Walk-ins & reservations

21 | tripadvisor.co.uk | The Botanist | Wine Bar | Cardiff Bay | 4.2 | 1,109 | ££ | 2026-02-02 | Bookable via site

22 | justeat.co.uk | Little Sichuan | Chinese | Sheffield City Centre | 4.1 | 934 | £ | 2026-02-03 | Delivery & collection only

23 | deliveroo.co.uk | Falafel Street | Middle Eastern | Leeds Hyde Park | 4.6 | 1,287 | £ | 2026-02-04 | Delivery, no reservations

24 | yelp.co.uk | Blue Lantern | Seafood Grill | Plymouth Hoe | 4.4 | 412 | £££ | 2026-02-02 | Recommended to reserve waterside tables

25 | zomato.com | Masala Dosa House | South Indian | Birmingham Jewellery Quarter | 4.5 | 721 | £ | 2026-02-01 | Walk-ins & telephone bookings

26 | squaremeal.co.uk | Skyline Teppanyaki | Japanese Grill | Manchester Spinningfields | 4.6 | 1,058 | £££ | 2026-02-03 | Reservations required for chef tables

27 | designmynight.com | Alba Social Club | Tapas Bar | Glasgow Merchant City | 4.0 | 287 | ££ | 2026-02-04 | Limited bookings - busy at night

28 | timeout.com | The Garrison | Brasserie | Norwich Cathedral Quarter | 4.3 | 398 | ££ | 2026-02-02 | Book online for dinner service

29 | google.com | Holy Grain Bakery & Cafe | Bakery | Brighton North Laine | 4.8 | 2,512 | £ | 2026-02-04 | Walk-ins only - counter service

## Additional fields

## Dashboard widgets

- {"id": "fa3af6e3", "size": "small", "type": "metric", "title": "Total Bars & Restaurants Tracked", "column": 0}

- {"id": "2261855e", "size": "medium", "type": "donut", "title": "Cuisine Type Distribution", "column": 0}

- {"id": "cad63c67", "size": "small", "type": "metric", "title": "Average Delivery Time (mins)", "column": 0}

- {"id": "d962d86d", "size": "medium", "type": "insights", "title": "Key Observations on Bar and Restaurant Trends", "column": 1}

- {"id": "4e629455", "size": "medium", "type": "horizontal_bar", "title": "Most Popular Bar Locations", "column": 1}

- {"id": "9c3b4b0c", "size": "large", "type": "line", "title": "Average Rating Trend Over Time", "column": 2}

- {"id": "321b0f4b", "size": "large", "type": "table", "title": "Detailed Listing of Restaurants", "column": 2}

- {"id": "3e80e8f2", "size": "medium", "type": "bar", "title": "Average Prices by Cuisine Type", "column": 2}

- {"id": "d5c0fa20", "size": "medium", "type": "bar", "title": "Top 10 Restaurants by Customer Reviews", "column": 3}

- {"id": "2ed4af4f", "size": "large", "type": "area", "title": "New Listings Growth Over Time", "column": 3}

- {"id": "e6c0f137", "size": "large", "type": "table", "title": "Top Rated Restaurants by Source", "column": 3}

## Alerts

- {"id": "new_listing", "icon": "bi-plus-circle-fill", "item": "The Gourmet Burger Kitchen", "title": "New Listing Appears", "source": "deliveroo.co.uk", "enabled": true, "send_to": "email", "severity": "success", "subtitle": "now available on Deliveroo"}

- {"id": "price_change", "icon": "bi-tag-fill", "item": "Fine Dining Experience", "title": "Price Change Detected", "source": "timeout.com", "enabled": false, "send_to": "slack", "severity": "warning", "subtitle": "is now £120 (+£20)"}

- {"id": "availability_change", "icon": "bi-box-seam", "item": "The Ivy", "title": "Reservation Status Changed", "source": "tripadvisor.co.uk", "enabled": false, "send_to": "teams", "severity": "warning", "subtitle": "now fully booked"}

- {"id": "new_venue_detected", "icon": "bi-plus-circle-fill", "item": "Nobu London", "title": "New Venue Detected", "source": "tripadvisor.co.uk", "enabled": true, "send_to": "webhook", "severity": "success", "subtitle": "listed on TripAdvisor"}

- {"id": "product_removed", "icon": "bi-dash-circle-fill", "item": "Pizza Express", "title": "Product Removed from Source", "source": "justeat.co.uk", "enabled": false, "send_to": "email", "severity": "danger", "subtitle": "no longer listed on Just Eat"}

## Integrations

- google-sheets

- email

- teams