# 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 Ivy Chelsea Garden | Modern British | Chelsea, London | 4.5 | 2,134 | £45-£80 | 2026-02-02 | Available (Online booking)

2 | justeat.co.uk | Poppy's Fried Chicken | Fast Food | Shoreditch, London | 4.2 | 412 | £6-£18 | 2026-02-03 | Delivery only

3 | deliveroo.co.uk | Chez Nico - French Bistro | French | Soho, London | 4.6 | 289 | £20-£55 | 2026-02-04 | Accepting reservations via phone

4 | yelp.co.uk | The Narrowboat Pub | Pub | Hackney, London | 4.0 | 198 | £8-£30 | 2026-02-01 | Walk-ins preferred

5 | zomato.com | Khana & Co. | Indian | Brixton, London | 4.3 | 564 | £10-£30 | 2026-02-02 | Available (table booking)

6 | squaremeal.co.uk | Aqua Shard | Fine Dining | London Bridge, London | 4.4 | 1,021 | £70-£150 | 2026-02-03 | Limited availability

7 | designmynight.com | Moxy Rooftop Bar | Bar | Kings Cross, London | 4.1 | 154 | £7-£25 | 2026-02-04 | Tickets for events

8 | timeout.com | Bao Morgan | Taiwanese | Covent Garden, London | 4.5 | 832 | £6-£25 | 2026-02-01 | Queue on arrival

9 | google.com | La Vina Tapas | Spanish | Notting Hill, London | 4.6 | 2,450 | £18-£45 | 2026-02-04 | Available (Google booking)

10 | berlinfoodstories.com | Currywurst Corner | Street Food | Kreuzberg, Berlin | 4.2 | 1,102 | €4-€10 | 2026-02-02 | Not applicable (street stall)

11 | tripadvisor.co.uk | Smith & Whistle | Gastropub | Islington, London | 4.3 | 678 | £12-£40 | 2026-02-03 | Recommended (online booking)

12 | justeat.co.uk | Bella Pizza | Pizza | Manchester City Centre | 4.0 | 1,215 | £7-£22 | 2026-02-04 | Delivery & collection

13 | deliveroo.co.uk | Green Wok | Vegan | Belsize Park, London | 4.7 | 341 | £9-£24 | 2026-02-02 | Delivery only

14 | yelp.co.uk | The Vinyl Bar | Cocktail Bar | Camden, London | 4.4 | 279 | £10-£30 | 2026-02-01 | Advanced booking advised

15 | zomato.com | Saffron Spice | Indian | Leeds, West Yorkshire | 4.1 | 432 | £11-£35 | 2026-02-03 | Available (phone)

16 | squaremeal.co.uk | Riverfront Brasserie | Modern European | Bristol Harbour | 4.2 | 214 | £25-£60 | 2026-02-04 | Available (online & phone)

17 | designmynight.com | Neon Nights Club & Kitchen | Late-night | Shoreditch, London | 4.0 | 489 | £12-£40 | 2026-02-02 | Table packages

18 | timeout.com | The Seafood Shed | Seafood | Brighton Marina | 4.5 | 1,003 | £20-£65 | 2026-02-03 | Peak times booked

19 | google.com | Mama's Dumplings | Chinese | Manchester Northern Quarter | 4.3 | 1,807 | £6-£28 | 2026-02-04 | Walk-ins & delivery

20 | berlinfoodstories.com | Nordic Smokehouse | Scandi | Prenzlauer Berg, Berlin | 4.6 | 389 | €15-€45 | 2026-02-01 | Reservations open online

21 | tripadvisor.co.uk | The Glasshouse | Rooftop Bar | Birmingham City Centre | 4.2 | 556 | £8-£35 | 2026-02-03 | Booking recommended

22 | justeat.co.uk | Sushi Express | Sushi | Liverpool, Merseyside | 4.1 | 897 | £5-£22 | 2026-02-02 | Takeaway & delivery

23 | deliveroo.co.uk | La Casa Mexicana | Mexican | Brixton, London | 4.4 | 623 | £9-£30 | 2026-02-04 | Delivery & reservations

24 | yelp.co.uk | Old Stone Coffeehouse | Cafe | Bath, Somerset | 4.7 | 322 | £3-£15 | 2026-02-01 | No reservations (counter service)

25 | zomato.com | The Greek Taverna | Greek | Cambridge, Cambridgeshire | 4.0 | 278 | £12-£35 | 2026-02-03 | Available (phone/online)

26 | squaremeal.co.uk | Harvest Table | Farm-to-Table | Oxford, Oxfordshire | 4.5 | 407 | £30-£70 | 2026-02-04 | Limited weekend availability

27 | designmynight.com | Basement Jazz Bar | Live Music Bar | Brixton, London | 4.3 | 191 | £8-£28 | 2026-02-02 | Tickets & table bookings

28 | timeout.com | Mount Street Deli | Delicatessen | Mayfair, London | 4.6 | 1,144 | £6-£30 | 2026-02-04 | Pre-order recommended

29 | google.com | El Mercado Tapas | Spanish | Birmingham, Jewellery Quarter | 4.2 | 658 | £10-£40 | 2026-02-03 | Online booking available

30 | berlinfoodstories.com | Prenzlauer Beer Garden | Beer Garden | Prenzlauer Berg, Berlin | 4.4 | 2,005 | €3-€12 | 2026-02-02 | Walk-ins and group bookings

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