build a scraper to keep updated a google spreadsheet with data from a web
Project detail
Build a scraper that keeps updated a google spreadsheet sheet with the data of 10 different products being published in a classified ads website.
– retrieve the data for 3 different products/keywords, each one in a different sheet of the spreadsheet. Sheet 1, keyword search “BMW”, Sheet 2 keyword search “xiaomi note 6”, Sheet 3 keyword search “ipad mini 3”.
– check for a new result every 5 minutes and add the new products in a new row on the top of the table.
The data from the items/products that should be in the table:
– publish/posting date
– item title
– item description
– item price
– item image url
– item url
– seller name
– seller image url
-seller url
Example:
https://docs.google.com/spreadsheets/d/13q5_5exF1POTg8jJLeOqVp85Bgou0UcrMnoKNVtVZIk/edit#gid=0