IMPORTDATA in Google Sheets where result limit exceeded and constrained function does not contain desired data

Question

I am trying to import the Market Cap data point from the page https://taostats.io/subnets/1/chart into a Google Sheets cell.

IMPORTXML and IMPORTHTML functions previously failed.

The closest I can get so far is by way of contraining an output of some of the page data using the function =ARRAY_CONSTRAIN(IMPORTDATA("https://taostats.io/subnets/1/chart"), 1, 300). This function only outputs some of the page data (by way of not exceeding Google Sheets limitations), yet, the output does not contain the desired data point.

Subsequently, I am seeking to import other values from the page, such as data values for Circulating Supply, Alpha in Pool, TAO in Pool, Alpha in Pool (%), TAO in Pool (%), etc. Thusly, a reconfigurable function is sought.

Any practical solution(s) will be greatly appreciated.

Answer 1

Web scraping using Google sheets

After trying different ways to scrape the given website using other ways in Google sheets and even in Google Apps Script, it seems that it is not possible to accomplish your goal by just utilizing Google sheets functions or the website that you are trying to use implements some type of anti-scraping mechanisms. With that, you will need to look for alternatives like using different tools see this or using alternative websites.

Following @Tedinoz comment, it is indeed that the website uses Javascript to render dynamic websites. We can confirm that by disabling JavaScript on the web browser, in my case, Google Chrome. See below

After disabling JavaScript

The image above suggests that the website uses JavaScript to render most of its data which are the data that you are interested in.

References:

Disable JavaScript