Parser Upgrades and Downgrades Forecasts with Yahoo Finance

POT ON THE WORLD (budget specified to fill the cell)

TECHNICAL TASK
to develop upgrades and downgrades forecasts by Yahoo Finance

You want to develop a upgrades and Downgrades forecasts parser from Yahoo Finance pages that are updated once a day by sampling tickers from the side of the page.
The main task of the parser is to clearly present in the table the forecast of analysts on the ticker. The more predictions for the day on the ticker, the higher the ticker line in the table.
The data should be collected in a Google table (ready to consider alternative ways of collecting data - excel, gui python, mobile application, etc.)

Key requirements:
Data should be collected in a Google table (or a suitable alternative).
2. The data should be updated once a day, and the ability to run the table update manually (also, the automatic update time should be set up).
3. Sample columns in the table: docs.google.com/spreadshe...
4. The ticker list should be loaded from the side of the page (Google table) and the possibility of expanding the ticker list (in test development - with the NASDA (capital market) - 1567 tickers (www.nasdaq.com/market-act...
5. Data can come from api - query1.finance.yahoo.com/... or directly from the site - finance.yahoo.com/quote/C...
6. A link from the table should be made to the companys page (ticker) on the finance.yahoo.com/quote/C website...