ImportXML Function on Google Sheets

Question

I'm having a tough time pulling info in on Google Sheets using the ImportXML function. I want to pull in the price of a crypto coin so that I have a real-time feed. The link that I'm hoping to pull from is:

https://www.dextools.io/app/uniswap/pair-explorer/0x40f0e70a7d565985b967bcdb0ba5801994fc2e80

I've tried out a lot of different formulas and keep getting an #N/A or an error. Some of the ones I've tried:

Copy XPATH fully: =IMPORTXML("https://www.dextools.io/app/uniswap/pair-explorer/0x40f0e70a7d565985b967bcdb0ba5801994fc2e80","/html/body/app-root/div[3]/div/main/app-uniswap/div/app-pairexplorer/app-layout/div/div/div[2]/div[2]/ul/li[2]/span")

Shortened XPATH (also tried deleting the second backslash before 'li' but that didn't work): =IMPORTXML("https://www.dextools.io/app/uniswap/pair-explorer/0x40f0e70a7d565985b967bcdb0ba5801994fc2e80","//li[2]/span")

Include class: =IMPORTXML("https://www.dextools.io/app/uniswap/pair-explorer/0x40f0e70a7d565985b967bcdb0ba5801994fc2e80","//li[2]/span[@class='ng-tns-c93-2 ng-star-inserted']")

Does anyone have thoughts? Thanks!

The page's source doesn't seem to have too much html on it, so it's likely doing an API call or something. You might try to open the Network Monitor and see if you can find the URL that's fetching the data. — Calculuswhiz

player0 player0 · Accepted Answer · 2021-02-15T20:11:48

upon disabling JavaScript the site is empty = can't be scraped by Google Sheets by any import formula.

ImportXML Function on Google Sheets

2 Answers