your question is a bit too broad, but here is my suggestion:
1. The Python standard library provides a `urllib` module, which can, among other things, download pages from an HTTP source. That might solve your first problem of downloading data from a website.
2. The Python standard library provides a `csv` module to handle CSV data, which can be manually loaded into a spreadsheet. How to extract data from the HTML page and convert it into CSV depends on the kind of data you are dealing with. The Python standard library has a `html` package that can parse HTML pages.
3. The Python standard library provides a `smtplib` package that deals with sending e-mails. That would solve your third problem.
If you give some other details on the kind of data you are dealing with, I might give you a better answer.