Download YouTube Video Comments To Google Sheets (Source Code Included) 

You will need to email RU-vid support for this one.

Glad the video helped!

A few workaround: 1) chunk the request across multiple days since the free quota is reset each day or 2) ask for quota increase if you have a valid reason.

Change this row

@@jiejenn thank you!

​@@robi3228Hi there, did you limit your number of comments to 200 and how.

It just means you are giving the app to do things within certain platforms on your behalf. Liability thing.

The max requests you can make is 10,000 requests. Each request can return 100 comments. So the total comments you can return per day is 10000 * 100 = 10,000,000, which should be more than enough. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NcIB6lGw380.html

I fixed it, but now a new error. The new error message is because I exceeded tge quota for the RU-vid Data API. Google applies usage limits (quotas) to each API to control the resources allocated to it. Each API request consumes a portion of my quota.

Hmmm. Don't know what going on there. Just tried it for the first time and it works just like the video shows

I know understand what went wrong with you. You need to add a new tab named "Input". Otherwise it won't match with the script

Don't have a solution right now.

@@jiejenn No problem. It helped me very much. Ty

I don't think that's possible unless you own the videos.

@@jiejenn shoot ok. Thank you for the quick reply. I really wish there was a way I could watch a privated video I used to watch all the time when it was unprivated.

There is a reason they are labeled "private".

@@jiejenn oh trust me I completely understand. I just wish the video creator when he had originally had the video for us to see, that he let his viewers know that he would eventually be privating. Or better yet, I wish youtube would let us know who it belongs to so I could reach out to them for access. It was a short scary story video but man I loved that video more than any other video I've ever seen on RU-vid.

Solved haha thank u again for the video!

Exactly

@@lizzy_shada how did you solve it?

Add the input tab mentioned in the video and put the video ID there and not on sheet 1. I missed that part of the video too since he should have put it at the beginning of the video but put it after the code thing 1:30 minutes into the video. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-A_i8aXsyQec.html

It can be valuable for many purposes. Like to study what moment of the video was more interesting to people or something like that.

Text analysis

It's mainly for brands to study and get insight into the market opinion about a particular topic. instead of going from house to house, and street to street asking people what they think about a particular topic, you can just come to youtube, search for that particular topic, and then read the comments on the videos found in that niche. but reading these comments can be really tiring, and boring, because most times you have to go through so much less important data, to get to the important ones. but with this wonderful video, I've just downloaded over 2900 comments from a particular video, which is talking about a theme I am about to create marketing content for. The next thing I am about to do, is to take that google sheet and feed it into an Artificial intelligence semantic analyzer like monkey learn, which would categorize these comments into positive, negative, and neutral. this process would save 24hr work to just 2 hours max. . . Thanks jie jenn, look forward to buying you coffee someday.

There are a lot of videos that are discussions or interviews. Audience reaction is worth its weight in gold. Vox populi vox dei. You can monitor and react to the situation ahead of time and thus influence the development of the events