I am trying to import the Market Cap data point from the page 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(";), 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.

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.

• google-sheets
• google-sheets-formula

• I think you will find that this page is populated dynamically using javascript. You can't extract the values using conventional "import" functions. – Tedinoz Commented yesterday

1 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