How to get YouTube's channel subscriber count in Google Sheet with IMPORTXML

I want to get the number of subscribers of a YouTube Channel into a Google Sheet without using the YouTube API.

I did some research and found some examples but I'm still stuck.

The output I want is: 39.1 million

In a Google Sheet I tried with IMPORTXML like these:

=IMPORTXML($A1,"//meta[@property='og:description']/@content")

and I can get the property of the page but as soon as I do the right XPath for the subscriber count (which works in the browser's console):

=IMPORTXML($A1,"//*[@id=""subscriber-count""]")

I always get an Error "Imported content is empty".

Looking at other examples in Stackoverflow I also found this:

=QUERY(FLATTEN(IMPORTDATA(A1)),"where Col1 starts with 'subscriberCountText:'",0)

And I receive this output:

subscriberCountText:{"accessibility":{"accessibilityData":{"label":"39.1 million subscribers"}}

But can't extract "39.1 million" properly from that.

Any help would be much appreciated.

Solution

=REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(A1)),"where Col1 starts with 'subscriberCountText:'"),"([0-9,.,\s,a-z]+)subscriber")

Result: 39.1 million