Podcast rss feed to Spreadsheet (and Glide)

I’ve just read this tutorial

And I want to know what is the formula to get the .mp3 of each episode

When I enter =importfeed("https://feeds.transistor.fm/forloop-pod"), it ony shows these data (title, author, episode link, created date and description)

rssfeed

How did he get the .mp3 link?

Thanks!

I found the answer on Glide community :grinning:

The formula is:

=IMPORTXML("https://feeds.transistor.fm/forloop-pod", "//enclosure/@url")

4 Likes

haha awesome!! I remember struggling with that one for aaaaaaaaages before I found a formula - this tutorial was submitted by a community member (also a Glide expert)

2 Likes