Question
HI! Does anyone know how to get the .mp3 URL <enclosure /> out of an RSS feed, so I can use it as a direct link in a spreadsheet? =importfeed does not support this. Thank you
Presumably with ARRAYFORMULA and REGEXEXTRACT. Could you give sample RSS feed?
avishayp@avishay-p
Presumably with ARRAYFORMULA and REGEXEXTRACT. Could you give sample RSS feed?
sure. https://anchor.fm/s/7b7c2ec/podcast/rss
**Nicholas Pretorius**@nicholas-preto5:54pm
I did not know the answer to this, but remembered there is an IMPORTXML formula. Did some reading and figured this out:
=IMPORTXML("https://anchor.fm/s/7b7c2ec/podcast/rss","//enclosure/@url")
**Thomas Dahm**@thomas-dahm6:38pm
thank you for the amazing tip!! I looked into it before but got always an error. this worked for me. =IMPORTXML("https://anchor.fm/s/7b7c2ec/podcast/rss"; "//enclosure
") hat to use a ";" instead of a comma. Now I can finish my dream app.