Thanks for this share, I highly appreciate.How many blogposts are we talking about? You can do this using python.
Or you can try this tutorial https://oxylabs.io/blog/web-scraping-sheets
I don't own those sites;It depends if you own or not that site. For example with WordPress, you could easily query the WP-API and fetch the content with perfection
But if you don't own that site, you might be analyzing the HTML to see if there are some cues on it that clearly suggest you what is the main text, for example an article html tag. With python as already suggested and a library like BeautifulSoup you can accomplish this with certain degree of ease
Check this simple tutorial