Youtube API Project - How to Scrape Youtube Videos Data

Learn how to get data from Youtube videos and display the info in google sheets. You don't have to know how to code to do this and everything can be done right on your browser. You can look into the Youtube API to see more options to use. This is a beginner web scraping tutorial.

If you want to follow me along my coding journey, be sure to subscribe :)

Check out my website

Check out this awesome tech gear

Check out my other videos
Top 5 Website Designs You Must See

Make a React Real Estate Website

How to Make a Website using HTML, CSS, Javascript & GSAP

Make a Website using Gatsby & Graph QL

React Website using Styled Components and Smooth Scroll

Some links in the description are affiliate links, which means that if you click on them and make a purchase, I'll receive a small commission.

[ncurtisctop]

Fantastic video for a total beginner. Noticed the publishedAt did not display in the GoogleSheet but then noticed in the getRange function the 3 need to be a 4 to stop the videoStats overwriting this publishedAt column. Thanks again

[datawontlie]

I've made it! Thanks for sharing.

[sikandar-ali]

This is awesome. Is it possible to get all the video titles from a Specific channel?

[richardtvtv]

Very impressive! How come there was no API key needed or did I miss something? Is it because it's being coded in google sheets?

[LeKhang]

Thanks Brian this video is very useful and easy to understand.

But my code works only if the total number of columns of (results) equal that of (videoStats). In your video there is 3 columns in (results) and 3 columns in (videoStats) so it works perfectly.

When I add 1 more column "item.snippet.description" to (results). It shows error "Exception: The number of columns in the data does not match the number of columns in the range. The data has 3 but the range has 4."

Or, when I add into (videoStats) it'll show the opposite error "The data has 4 but the range has 3."

How can I solve this? Thank you very much.

[muhammadhilal]

Hey there, great video, but where did you passed the API key?

[rawadbader]

I think this is a good example but you did not explain the bits of code like this activeSheet.getRange(2, 1, results.length, what dos 2, 1 stand for?

[bantri]

Another challenging example:

How can I find duplicates on
all the play lists, by their
unique video ID's ?

(and then the script present
the option to choose
which of the two,

will be removed
from the playlist.)

[Dhiljo]

Great! I'm also working on a data scraper. But don't you think these projects infringe on youtube's terms of service? Would like to hear your take on it!

"Data Aggregation

Do not aggregate API Data except that you may only aggregate API Data relating to YouTube channels that are under the same content owner as recognized by YouTube pursuant to content licensing agreement(s) between YouTube and such content owner. Such aggregated API Data must only be viewable by that content owner."

[Tideco]

Thanks Brian, but It's only returning 5 results, even entering maxresults: 50. Do you know how to solve this?

[bantri]

How can I list ALL youtube playlists and
under EVERY playlist, to have a list of
ALL the videos, contained on it ?

(For some specific
youtube account.)

[ShortToKnow]

Hey thanks a lot for this content!
I did run into this error: ReferenceError: YouTube is not defined

Can somebody help out?🧠

[Tutorials-by-MuhammadUsman]

I really liked your video and it's very helpful and handy procedure to get data from YouTube using API 😄😄😄

[Tutorials-by-MuhammadUsman]

Can you please suggest a video from your channel or create a new video for embedding a video from YT to blogger using iframe.

[bearweethus]

I have written exactly the same code but mine does not show count, likes and dislikes (there are only two columns). Also, I want max results to be 1000 but it is only giving max 50 results. Please reply on it. I don't know coding at all.

[vincentfatato]

Hi Brian
I copied your code and every time I run it I get an error Exception: The number of rows in the range must be at least 1. The line of code where it errors is the last line of code = activeSheet.getRange(2, 4, videoStats.length, If I comment it out, the program will run. Can you help me with this?
Thanks.

[Labib_]

what if we want to extract duration, video quality, volume desivle, etc?

[Harsh-sd]

can we get transcript/caption of the YouTube videos also with this. If no how to get it?

[yousafdilshad]

Could anyone please teach me how to run this process on a list of youtube URLs instead of a search query?

[SliceofLife]

Is it possible to get all the video titles from a Specific channel?