Tripadvisor scrape to google sheets

Job ID: 31193556

Budget: $250 – $750 USD

Hi.
I am looking for someone to help with 2x scraping projects:

I. Tour Rank sheet
I have an existing script that tracks the rank of my tripadvisor listings on various lists published by tripadvisor (eg "best 25 things to do in X" etc). Server used is Heroku. Output sheet: https://docs.google.com/spreadsheets/d/1RQcMG3KztfiMCEzjPZBKfnaPRroTvGZqhTnK7hl5TFg/edit?usp=sharing

I need the following work carried out:
1) Sheet does not seem to be currently working. Eg "PRIVATE Saona Island Cruise - from $395 PER GROUP (max 7 people)" - 2nd item in list. Seems to have stopped at 23rd June 2021.

2) add dots to the graph for each view received for that listing. view can be 1, 2, 3, 4 or 5 stars. Need different coloured dot for each view number

3) need a dropdown on the output sheets that let us change time period shown on graph (1 week, 1 month, 6 months, 1 year, all)

4) currently line goes up when rank is low, and goes down when rank goes up (eg 1st position). This needs to be inversed so line is at the top if chart if listing is in first place.

II. Tripadvisor destination scraper.
This sheet collects info about all tour providers within a specified location: https://docs.google.com/spreadsheets/d/129tczCEhYflAlwfyEL0dga9G25E2ZXoLTN-ffYYoEiY/edit?usp=sharing

Work to be carried out:
1) Sometimes it seems the sheet does not collect all the entries on an underlying tripadvisor list. Eg there are over 1000 tour providers in Dominican Republic, but only 800 or so tour providers have been recorded on the sheet. I would like this fixed.

Access to source files can be given. Please send me a quote for each of the two projects I. and II. above. Happy to answer any questions to help you reach a quote.

Thanks!