You can automatically get a list of your blog articles from your RSS feed into Google Sheets, and have Google Analytics pull traffic information for those articles on a schedule to update the spreadsheet. The secret sauce is Zapier's automated app workflows that tie RSS, Google Sheets, and Google Analytics together. To set this up, you'll need a paid account in order to use it, but you can try out the 14-day free trial to see if it saves you time and agony. You'll also need to create a new Google Sheets spreadsheet with the fields from your RSS feed, set up a Zap to start whenever there's a new item in an RSS feed, format the blog URL for Google Analytics, add a delay action for the period you want to collect traffic for, run the Google Analytics report, and update the Google Sheets row with the Google Analytics number. You can also repeat these steps for additional timeframes if needed. Once set up, every time a new post goes up on your blog, it'll automatically be entered into a spreadsheet and you'll get automated traffic reports within that spreadsheet.