'Pulling Data For A List Of URLs Using The Google Analytics Sheets Add-On

I've been looking into The Google Analytics Spreadsheet Add-on, however, currently, it pulls the data for the entire account, I want to pull the data only for specific URLs (new blog posts uploaded which will be updated once a month).

I understand I could use something like "ga:pagePath=~^/blog/" however, this would only show the total number of sessions for the "/blog/" section and not for individual posts, ideally, I want the format to be like this:

enter image description here

Is this possible?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source