Aug 24 2021 04:25 AM
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!