How to Track iTunes Podcast Rankings Automatically with Google Sheets, Xpath and RSS Feeds

Edit March 12, 2018: The iTunes xml that this method uses to fetch the data seems to work again. The method should we valid as is but be aware that if the iTunes feed breaks or they change something, you won’t get data anymore.

Edit, February 24, 2018: The iTunes xml that I used to fetch the data from has apparently been changed. A URL such as https://itunes.apple.com/fi/rss/topaudiopodcasts/limit=100/genre=1301/xml is no longer valid, so the method fails. If you find a working…