# 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 | Chelsea, London | 4.5 | 1,842 | £40-£70 | 2026-02-02 | Available (book online)

2 | justeat.co.uk | Pizzeria Roma | Pizza | Camden, London | 4.2 | 548 | £8-£18 | 2026-02-03 | Takeaway only

3 | deliveroo.co.uk | Bao House | Street Food | Shoreditch, London | 4.6 | 1,220 | £6-£14 | 2026-02-04 | Delivery & Collection

4 | yelp.co.uk | The Botanist | Cocktail Bar | Covent Garden, London | 4.3 | 732 | £12-£30 | 2026-02-01 | Limited (call venue)

5 | zomato.com | Shoryu Ramen | Japanese | Soho, London | 4.4 | 2,013 | £10-£22 | 2026-02-04 | Available (online)

6 | squaremeal.co.uk | Aqua Shard | Fine Dining | London Bridge, London | 4.7 | 1,105 | £65-£120 | 2026-02-03 | Fully booked (waitlist)

7 | designmynight.com | Dirty Martini | Bar | Mayfair, London | 4.1 | 899 | £10-£25 | 2026-02-02 | Available (reserve table)

8 | timeout.com | Dishoom Covent Garden | Indian | Covent Garden, London | 4.6 | 6,412 | £12-£30 | 2026-02-03 | Timed tickets (limited)

9 | google.com | Franco Manca | Sourdough Pizza | Brixton, London | 4.5 | 3,204 | £6-£14 | 2026-02-04 | Walk-ins & takeaway

10 | berlinfoodstories.com | Kossa | Vegan | Mitte, Berlin | 4.4 | 412 | €9-€18 | 2026-02-02 | Available (online)

11 | tripadvisor.co.uk | Sketch (Lecture Room) | Fine Dining | Mayfair, London | 4.8 | 2,950 | £95-£220 | 2026-02-01 | Requires deposit (booked out weekends)

12 | justeat.co.uk | Curry Leaves | Indian | Leeds City Centre | 4.0 | 214 | £7-£16 | 2026-02-04 | Takeaway only

13 | deliveroo.co.uk | Sushi Daily | Sushi | Liverpool Street, London | 4.3 | 1,004 | £4-£12 | 2026-02-03 | Delivery & Collection

14 | yelp.co.uk | The Black Dog | Gastropub | Battersea, London | 4.2 | 387 | £15-£35 | 2026-02-02 | Recommended to book

15 | zomato.com | Padella | Pasta | Borough Market, London | 4.7 | 8,120 | £7-£20 | 2026-02-04 | Queue system (no reservations)

16 | squaremeal.co.uk | Gymkhana | Indian Fine Dining | Mayfair, London | 4.6 | 1,345 | £45-£90 | 2026-02-03 | Available (peak times limited)

17 | designmynight.com | Nobu | Japanese | Shoreditch, London | 4.5 | 2,201 | £40-£80 | 2026-02-02 | Private dining & reservations

18 | timeout.com | Dabbous | Contemporary | Fitzrovia, London | 4.4 | 1,010 | £50-£110 | 2026-02-01 | Open (limited weekend availability)

19 | google.com | Franco's Trattoria | Italian | Islington, London | 4.1 | 289 | £12-£28 | 2026-02-04 | Walk-ins recommended

20 | berlinfoodstories.com | Mustafa's Gemüse Kebap | Kebab | Kreuzberg, Berlin | 4.5 | 5,320 | €3-€8 | 2026-02-03 | Street queue (no reservations)

21 | tripadvisor.co.uk | Hawksmoor Seven Dials | Steakhouse | Covent Garden, London | 4.6 | 3,780 | £35-£75 | 2026-02-02 | Booking required

22 | justeat.co.uk | Katsu King | Japanese | Birmingham City Centre | 4.0 | 156 | £8-£16 | 2026-02-04 | Takeaway & delivery

23 | deliveroo.co.uk | Honest Burgers | Burgers | Clapham, London | 4.4 | 2,450 | £9-£18 | 2026-02-03 | Collection & delivery

24 | yelp.co.uk | Barrafina | Tapas | Soho, London | 4.5 | 2,890 | £20-£45 | 2026-02-01 | Counter seating (limited)

25 | zomato.com | Maison Bertaux | Bakery & Cafe | Soho, London | 4.0 | 1,072 | £3-£12 | 2026-02-04 | Walk-ins only

26 | squaremeal.co.uk | The Ledbury | Fine Dining | Notting Hill, London | 4.8 | 3,600 | £85-£200 | 2026-02-02 | Fully booked (cancellations possible)

27 | designmynight.com | Nightjar | Speakeasy | Old Street, London | 4.4 | 1,480 | £8-£18 | 2026-02-03 | Reservation advised (limited seats)

28 | timeout.com | Roka | Japanese Robata | Aldwych, London | 4.5 | 1,950 | £30-£65 | 2026-02-01 | Available (pre-book recommended)

29 | google.com | Gail's Bakery | Bakery | Fulham, London | 4.3 | 1,130 | £2-£10 | 2026-02-04 | Walk-ins & click & collect

30 | berlinfoodstories.com | Curry 36 | Fast Food | Kreuzberg, Berlin | 4.1 | 2,100 | €3-€7 | 2026-02-02 | Counter service (no reservations)

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