Problem with FILTERXML

Copper Contributor

Hello Guys!

I have a problem with the FILTERXML function.

(please note that my code is in German)

 

I'm trying to get the current follower amount of our companies social media channels with the FILTERXML-function.


I've tried it insode Excel & Google Sheets, but neither seems to work, also with X path & full x path
Maybe there is someone out here who could help me with this as i'm completely frustrated :D

Excel:
=XMLFILTERN("https://www.instagram.com/skinbaronde/";"//html/body/div[1]/section/main/div/header/section/ul/li[2]/a/span")
>Result: #Value!

Google Sheets:
=IMPORTXML("https://www.instagram.com/skinbaronde/";"/html/body/div[1]/section/main/div/header/section/ul/li[2]/a/span")
>Result: #N/A

Thanks in advance!

0 Replies