# Track coffee prices in cafes across Lisbon

Track café coffee prices across Lisbon effortlessly — gain insights without tedious manual checks or spreadsheets

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

Build this in Jsonify: https://factory.jsonify.com/setup?q=Track+coffee+prices+in+cafes+across+Lisbon

## Goal

Track coffee prices in cafes across Lisbon

## Sources

- cafeslisboa.com

- tripadvisor.com

- yelp.com

- google.com

- portugal.com

- mercadolivre.pt

- olx.pt

- ecommerceportugal.pt

## Sample data

id | Source | Cafe | Item | Size | Price | Original Price | Available | Rating | Reviews | Last Updated

1 | cafeslisboa.com | A Brasileira | Bica (Espresso) | Single | €1.20 |  | Yes | 4.6 | 1240 | 2026-01-18

2 | tripadvisor.com | Café Nicola | Cappuccino | Regular | €2.50 | €2.80 | Yes | 4.4 | 893 | 2026-01-17

3 | yelp.com | Hello, Kristof | Flat White | Regular | €2.90 |  | Yes | 4.7 | 412 | 2026-01-19

4 | google.com | Fábrica Coffee Roasters | Single-Origin Pour Over | 250ml | €4.50 |  | Limited | 4.8 | 1021 | 2026-01-19

5 | portugal.com | Pois Café | Latte | Large | €3.60 | €3.90 | Yes | 4.5 | 678 | 2026-01-16

6 | mercadolivre.pt |  |  | 250g | €5.99 | €7.49 |  | 4.3 |  | 2026-01-18

7 | olx.pt |  |  | 1 pc | €3.50 |  |  |  |  | 2026-01-15

8 | ecommerceportugal.pt |  |  | 1kg | €14.90 | €19.90 |  | 4.6 |  | 2026-01-18

9 | cafeslisboa.com | Pois Café | Espresso Macchiato | Single | €1.80 |  | Yes | 4.5 | 310 | 2026-01-17

10 | tripadvisor.com | Nicolau Lisboa | Cold Brew | 350ml | €3.80 |  | Seasonal | 4.3 | 540 | 2026-01-16

11 | yelp.com | The Mill | Piccolo Latte | Small | €2.50 | €2.70 | Yes | 4.2 | 284 | 2026-01-19

12 | google.com | Camélia | Iced Latte | Medium | €3.20 |  | Yes | 4.1 | 156 | 2026-01-18

13 | portugal.com | Fabrica Coffee Roasters - Campo de Ourique | Espresso Tonic | Single | €3.90 |  | Limited | 4.7 | 201 | 2026-01-19

14 | mercadolivre.pt |  |  | 350ml | €6.49 | €9.99 |  | 4.0 |  | 2026-01-17

15 | olx.pt |  |  | n/a | €120.00 |  |  |  |  | 2026-01-16

16 | ecommerceportugal.pt |  |  | 250g | €6.50 | €8.00 |  | 4.9 |  | 2026-01-18

17 | cafeslisboa.com | Leitaria | Café com Leite | Regular | €1.70 |  | Yes | 4.0 | 198 | 2026-01-19

18 | tripadvisor.com | Fauna & Flora | Mocha | Large | €4.20 | €4.50 | Yes | 4.3 | 732 | 2026-01-18

19 | yelp.com | Copenhagen Coffee Lab | Aeropress | One Cup | €3.00 |  | Yes | 4.6 | 129 | 2026-01-17

20 | google.com | Dear Breakfast | Filter Coffee | 250ml | €2.20 |  | Yes | 4.2 | 412 | 2026-01-16

21 | portugal.com | Satan's Coffee Corner | Cortado | Single | €1.50 |  | Yes | 4.6 | 980 | 2026-01-19

22 | mercadolivre.pt |  |  | 500g | €9.99 | €12.99 |  | 4.1 |  | 2026-01-18

23 | olx.pt |  |  | n/a | €450.00 |  |  |  |  | 2026-01-15

24 | ecommerceportugal.pt |  |  | 250g | €5.20 | €6.50 |  | 4.4 |  | 2026-01-19

25 | cafeslisboa.com | Hello, Kristof | Mocha Iced | Medium | €3.90 |  | Yes | 4.7 | 221 | 2026-01-18

26 | tripadvisor.com | Pastéis de Belém (Cafe) | Espresso | Single | €1.10 |  | Yes | 4.5 | 2500 | 2026-01-17

27 | yelp.com | Fábrica Coffee Roasters - LX | Cold Brew Bottle 500ml | 500ml | €5.50 |  | Limited | 4.8 | 412 | 2026-01-19

28 | google.com | The Mill - Santos | Iced Americano | Large | €2.80 |  | Yes | 4.2 | 198 | 2026-01-18

29 | portugal.com | A Brasileira - Chiado | Specialty Espresso | Single | €1.60 |  | Yes | 4.6 | 1340 | 2026-01-16

30 | mercadolivre.pt |  |  | 350ml | €7.90 | €11.90 |  | 4.2 |  | 2026-01-18

## Additional fields

## Dashboard widgets

- {"id": "d162c7ba", "size": "small", "type": "metric", "title": "Total Cafes Tracked"}

- {"id": "5895de26", "size": "small", "type": "metric", "title": "Lowest Coffee Price Today"}

- {"id": "7fc0bc3f", "size": "small", "type": "metric", "title": "Average Coffee Price"}

- {"id": "e49de8c1", "size": "large", "type": "line", "title": "Coffee Price Trend Over Last 6 Months"}

- {"id": "267e71e8", "size": "medium", "type": "bar", "title": "Top 5 Cafes by Average Coffee Price"}

- {"id": "51a1509e", "size": "medium", "type": "horizontal_bar", "title": "Price Distribution by Cafe Type"}

- {"id": "0d99ec82", "size": "medium", "type": "donut", "title": "Market Share by Cafe Brand"}

- {"id": "af1d7607", "size": "large", "type": "table", "title": "Detailed Coffee Prices by Cafe"}

- {"id": "3cd5f46c", "size": "large", "type": "area", "title": "Cumulative Price Changes Over Time"}

- {"id": "6ce6a10f", "size": "medium", "type": "insights", "title": "Coffee Price Analysis Insights"}

- {"id": "79bcff49", "size": "large", "type": "line", "title": "Price Comparison by Source (Tripadvisor vs Yelp)"}

- {"id": "bf03777f", "size": "medium", "type": "table", "title": "Recent Coffee Price Changes"}

## Alerts

- {"id": "price_change", "icon": "bi-tag-fill", "item": "Cappuccino at Café A", "title": "Price Change Detected", "source": "cafeslisboa.com", "enabled": true, "send_to": "email", "severity": "warning", "subtitle": "is now €3.50 (+€0.50)"}

- {"id": "new_listing", "icon": "bi-plus-circle-fill", "item": "Espresso at Café B", "title": "New Listing Appears", "source": "yelp.com", "enabled": true, "send_to": "slack", "severity": "success", "subtitle": "now available for €2.00"}

- {"id": "availability_change", "icon": "bi-exclamation-circle-fill", "item": "Latte at Café C", "title": "Coffee Unavailable", "source": "tripadvisor.com", "enabled": false, "send_to": "teams", "severity": "danger", "subtitle": "is currently unavailable"}

- {"id": "menu_updated", "icon": "bi-megaphone-fill", "item": "Mocha at Café D", "title": "Menu Updated", "source": "google.com", "enabled": false, "send_to": "webhook", "severity": "info", "subtitle": "new size options available"}

- {"id": "product_removed", "icon": "bi-dash-circle-fill", "item": "Cold Brew at Café E", "title": "Product Removed", "source": "mercadolivre.pt", "enabled": false, "send_to": "email", "severity": "danger", "subtitle": "is no longer listed"}

## Integrations

- google-sheets

- bigquery