# 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 European | King's Road, London | 4.5 | 1,324 | £45-£75 | 2026-02-03 | Available (online)

2 | justeat.co.uk | Pizzeria Vesuvio | Pizza | Camden High St, London | 4.2 | 412 | £8-£18 | 2026-02-02 | Collection & Delivery only

3 | deliveroo.co.uk | Bao Sisters | Street Food | Shoreditch, London | 4.7 | 2,018 | £6-£25 | 2026-02-01 | Delivery only (busy)

4 | yelp.co.uk | The Rum House | Cocktail Bar | Soho, London | 4.3 | 678 | £10-£35 | 2026-02-04 | Limited (phone only)

5 | zomato.com | Bird of Smithfield | Brasserie | Smithfield, London | 4.1 | 289 | £20-£50 | 2026-02-03 | Available (book online)

6 | squaremeal.co.uk | Sketch (The Gallery) | Fine Dining | Mayfair, London | 4.8 | 1,945 | £95-£150 | 2026-02-02 | Fully booked (waitlist)

7 | designmynight.com | Nightjar | Speakeasy | Old Street, London | 4.6 | 1,102 | £12-£40 | 2026-02-01 | Reservations required

8 | timeout.com | Padella | Italian | Borough Market, London | 4.4 | 3,210 | £9-£22 | 2026-02-04 | Queue/walk-in only

9 | google.com | Dishoom Covent Garden | Indian | Covent Garden, London | 4.5 | 12,450 | £15-£35 | 2026-02-03 | Available (online & phone)

10 | berlinfoodstories.com | Bratwurst & Bier | German | Prenzlauer Berg, Berlin | 4.2 | 156 | €8-€22 | 2026-02-02 | Walk-ins preferred

11 | tripadvisor.co.uk | The Botanist | Brasserie | Oxford Circus, London | 4.0 | 823 | £18-£40 | 2026-02-04 | Available (limited slots)

12 | justeat.co.uk | Sushi Express | Sushi | Brixton, London | 4.3 | 237 | £6-£28 | 2026-02-02 | Delivery & Collection

13 | deliveroo.co.uk | Green Heart Kitchen | Vegan | Notting Hill, London | 4.6 | 589 | £7-£22 | 2026-02-01 | Takeaway & Delivery

14 | yelp.co.uk | The Anchor Tap | Pub Food | Hammersmith, London | 4.1 | 342 | £6-£20 | 2026-02-03 | Walk-in (busy evenings)

15 | zomato.com | El Camino Real | Mexican | Brixton, London | 4.0 | 198 | £10-£30 | 2026-02-04 | Available (phone booking)

16 | squaremeal.co.uk | Core by Clare Smyth | Fine Dining | Notting Hill, London | 4.9 | 2,334 | £120-£220 | 2026-02-01 | Fully booked (reservations only)

17 | designmynight.com | Fabric Cocktail Bar | Nightclub Bar | Farringdon, London | 4.0 | 910 | £8-£30 | 2026-02-02 | Table booking (late slots)

18 | timeout.com | Hoppers | Sri Lankan | Soho, London | 4.5 | 1,078 | £9-£28 | 2026-02-03 | Queue & online booking

19 | google.com | Flat Iron | Steakhouse | Covent Garden, London | 4.4 | 6,780 | £20-£35 | 2026-02-04 | Walk-in (often busy)

20 | berlinfoodstories.com | Kreuzberg Curry | Street Food | Kreuzberg, Berlin | 4.1 | 412 | €4-€9 | 2026-02-02 | No reservations

21 | tripadvisor.co.uk | Aqua Shard | Modern British | London Bridge, London | 4.3 | 2,120 | £60-£120 | 2026-02-01 | Available (advance booking)

22 | justeat.co.uk |  Bombay Bites | Indian | Wembley, London | 4.2 | 154 | £7-£25 | 2026-02-03 | Delivery & Collection

23 | deliveroo.co.uk | Little Bao | Asian Fusion | Soho, London | 4.6 | 1,890 | £6-£30 | 2026-02-04 | Delivery (fast) & Dine-in limited

24 | yelp.co.uk | Seven Dials Market Stall 3 | Food Market | Covent Garden, London | 4.2 | 254 | £4-£12 | 2026-02-02 | No reservations (market)

25 | zomato.com | Franco Manca | Pizza | Borough High St, London | 4.0 | 3,456 | £6-£14 | 2026-02-01 | Walk-in & App booking

26 | squaremeal.co.uk | Restaurant Story | Modern British | Southwark, London | 4.7 | 1,021 | £75-£140 | 2026-02-03 | Reservations required

27 | designmynight.com | Bar Termini | Italian Bar | Soho, London | 4.4 | 734 | £6-£20 | 2026-02-04 | Limited (small groups)

28 | timeout.com | Gymkhana | Indian | Mayfair, London | 4.6 | 4,201 | £35-£70 | 2026-02-02 | Available (online booking)

29 | google.com | Dish & Spoon | Brunch | Hackney, London | 4.3 | 512 | £8-£22 | 2026-02-01 | Walk-in & Reservations

30 | berlinfoodstories.com | Café Anna Blume | Café | Kollwitzplatz, Berlin | 4.5 | 678 | €5-€18 | 2026-02-04 | Reservations (weekend busy)

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