How would I import YouTube video views into google sheets?

Question

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?

Hi, @player0 that solution doesn't work. I got this error message - Imported content is empty. — Razmik Badalyan, Sep 01 '22 at 12:00

score 1 · Accepted Answer · answered Sep 01 '22 at 12:52

1

try:

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

answered Sep 01 '22 at 12:52

player0

1 Answers1