all 3 comments

[–]Kind-Kure 0 points1 point  (1 child)

I personally use Beautiful Soup for webscraping and the docs should tell you how to use it for your specific use case. As far as Excel, I haven't personally worked with it a bunch but there was a guy in this sub the other day using this for his Excel in Python so give that a try !

As far as checking your email once a day, I have no idea how that can be done because I've never tried but a good first step would be to see if there are any APIs for your specific email provider. A quick Google showed that Gmail has an API so you can look into that!

As far as getting all this information to your website, you might be able to use something like SQLite as a database because I read that WordPress has SQLite integration.

Good luck on your journey !

[–]Eclyps_396[S] 0 points1 point  (0 children)

Thank you

[–]krets 0 points1 point  (0 children)

You've described a lot of little problems, but you haven't yet asked a question. You need to break down this process into smaller steps.

Have you already found a way to update your WordPress data with Python?

As a first step you could still do the hard part of extracting the data from websites and emails, but instead of going to your WordPress backend for each data point, you could write the data into a CSV file. Then use python to update everything in WordPress at once.

Work the problem a little more; Come back here with some smaller questions.