I need a Python Web Scraping Script

Hi,
I am new to python and I am having difficulties creating my own web scraping.
I have all the necessary libraries installed (Pandas, requests, beautifulsoup).

1 - I need python to iterate the news websites defined in the "Channels" tab
2 - Download news headlines, date, time, company in the news and classify the time (available in the "classification" tab)
3 - Match the company in the news with the company ticker
4 - Create a sentiment score*

The outputs need to in the "sheet1" tab and saved in an excel file locally

*Available here:
https://medium.com/the-handbook-of-coding-in-finance/sentiment-analysis-of-stock-market-in-python-part-2-estimating-sentiment-scores-with-nltk-292d8ec7d69e