Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

google sheet problem with importxml, xpath from website - scrape data

on

I've read about importxml function in google sheets and tried some examples. They worked fine. but I went to get my target data experience level of first/all players from

https://www.clashofstats.com/clans/mega-empire-90808YUJ/members/

I tried this formula

=IMPORTXML("https://www.clashofstats.com/clans/mega-empire-90808YUJ/members/","//*[@id="app"]/div[22]/main/div/div/div[1]/div[4]/div[2]/div[2]/div[2]/div[2]/div/div/div[1]/div/div/div/div[4]/span[1]/span/span")

Result shows - #N/A

Is that site impossible to import or am I doing anything wrong? kindly help me plz

Comments

Post a Comment