# Get mp3 url link from a podcast rss feed in a spreadsheet **URL:** \ **Category:** Ask for Help\ **Created:** [January 19, 2020, 10:50pm UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781 "2020-01-19T22:50:28Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Francois1](https://avatars.discourse-cdn.com/v4/letter/f/c67d28/32.png) [@Francois1](https://community.glideapps.com/u/Francois1)\ **Post date:** [January 19, 2020, 10:50pm UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781/1 "2020-01-19T22:50:29Z")
I’ve just read this tutorial: > **[Creating a podcast app](https://makerpad.zapier.com/posts/creating-a-podcast-app)** 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 only shows these data (title, author, episode link, created date and description) ![mp3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b90f120cf210a7f440fb80cd22e38561b67346a6.png) I have tried with 3 other podcast rss feed and it still only shows these data… How to get the .mp3 link? Thanks! ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [January 19, 2020, 10:52pm UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781/2 "2020-01-19T22:52:47Z")
This is not a Glide specific question, but has to do with how transistor serves its podcast MP3 files. Do you have an example link to a podcast MP3? It probably looks something like the links that are already in your sheet, I’m guessing with a .MP3 extension. ---
**Author:** ![Francois1](https://avatars.discourse-cdn.com/v4/letter/f/c67d28/32.png) [@Francois1](https://community.glideapps.com/u/Francois1)\ **Post date:** [January 19, 2020, 11:05pm UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781/3 "2020-01-19T23:05:11Z")
Thanks for the quick feedback David. I’ve tried with 3 different rss feed, so it is not only related to this example. In my sheet, there is no .mp3 url link. In the tutorial, he managed to get the .mp3 url link but he didn’t mention how. This is his sheet: ![podcast](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1bd3fc50678992f3c9bc3302733130af58498828.png) I know this is not Glide related tho… it’s just the step before Glide 🙂 I’ll build an app with this info. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [January 19, 2020, 11:34pm UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781/4 "2020-01-19T23:34:00Z")
Again, can you post just one example of an MP3 link for the podcast you’re trying to build? I’m looking for a pattern between the links that are actually in your sheet, and the link you want. If we discover the pattern, it’s may be easy to generate the MP3 links from the links you already have. I’m not familiar with the Podcasts that you’re working with, so I have no way to know where they store the MP3 files. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [January 19, 2020, 11:35pm UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781/5 "2020-01-19T23:35:15Z")
For example, it could be as simple as appending .MP3 to the end of the links you already have. In that case we would just use a template column to do this. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [January 19, 2020, 11:42pm UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781/6 "2020-01-19T23:42:25Z")
I was able to get the mp3 links with: ``` =IMPORTXML("https://feeds.transistor.fm/forloop-pod", "//enclosure/@url") ``` ---
**Author:** ![Francois1](https://avatars.discourse-cdn.com/v4/letter/f/c67d28/32.png) [@Francois1](https://community.glideapps.com/u/Francois1)\ **Post date:** [January 20, 2020, 12:12am UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781/7 "2020-01-20T00:12:05Z")
Thanks very much David. You got it 🥰 ---
**Author:** ![Mike\_Woods](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_woods/32/10670_2.png) [@Mike\_Woods](https://community.glideapps.com/u/Mike_Woods)\ **Post date:** [July 15, 2020, 12:50am UTC](https://community.glideapps.com/t/get-mp3-url-link-from-a-podcast-rss-feed-in-a-spreadsheet/3781/8 "2020-07-15T00:50:41Z")
Wow. Super big help to find this move to extract episode links to a spreadsheet. THANKS!