CODEWITHSUNDEEP
youtubegoogle-sheets
EarlyPoster
EarlyPoster

Reputation: 1088

Is there a way to automatically pull a list of YouTube video viewcounts into a Google Doc spreadsheet?

I want to create a simple video dashboard for some of my teaching videos, to see what's trending etc.

Is there a way to pull video counts from your channel, directly (preferably programmatically) into a Google spreadsheet?

Upvotes: 2

Views: 254

Answers (2)

pnuts
pnuts

Reputation: 59450

Copied from Web Applications:

Please try:

=IMPORTXML("https://www.youtube.com/watch?v=j6RsJmelphk","//div[@class='watch-view-count']")

which should return something like 97,000 (views for a Colin Farrell - Road to Hell video).

Upvotes: 1

Hari Krishna Ganji
Hari Krishna Ganji

Reputation: 1677

I am guessing you can try and use Google App Script. I am sure Youtube has a HTTP REST API that you can query to pull the necessary information into a Google Doc.

There is a little coding involved here, but its a just an Idea that might work.

Update : Tutorial on Google Apps Script

Hope this helps, Cheers!

Upvotes: 0

Related Questions