How would I import YouTube video views into google sheets?

user_5907715 0
Viewed 38

I have a list of videos for which I want to easily see the number of views. Is there a way to do that with REGEXREPLACE, or some other way?

regex-replace web-scraping google-sheets youtube regex
1 Answers

try:

=REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(A1)); 
 "where Col1 starts with 'viewCount'"; ); "\d+")*1

enter image description here

user_56326290
Related