Google Apps Script for Beginners Youtube Automation

[@jhciedev1729]

Waiting for more easy to understand tutorial like this! Thank you so much Chanel! :)

[@saperis]

Glad it was helpful! By the way I have an online course where I have many more Google Apps Script videos. You might want to check it out: courses.saperis.io

[@QwinBro]

I am just starting to view your many resources (thank you!) I am needing a simple solution: I need to convert a range of cells (say D2:E10) that contain various three- or four-digit numbers into 24-hr time (830 to 08:30 or 1715 to 17:15) I would also like to make the cells change the number when entered (it is easier to enter the data on the number pad and not have to enter the ":" each time. I have seen this question out on the net quite a bit - so I thought I would ask you for a possible short? Many thanks!! Daniel

[@allybaster7961]

Great stuff....I really like the way you present your content. Can I maybe suggest that you post more small Google Appscript projects. Thatnks for all the great content so far!

[@saperis]

Hi Ally. Thanks for the feedback! I post a Google Apps Script video tutorial every month. I sometimes work through a project and sometimes show how to do a specific action like the different options of getting a spreadsheet.

[@allybaster7961]

@@saperis Do you have anything on Udemy?

[@saperis]

No, I don't (and won't) offer anything on Udemy. But I do have my own online course for Apps Script. Check it out: courses.saperis.io

[@brucejuli4655]

Thanks for your video. I wonder how do you fix error at 19:03. In my case there is no items array at response value.

[@saperis]

In my case I didn't have to do anything. I simply ran the code again and it worked. Debugging is always very case specific. What is the error message? If you run the code in debugging mode it can give you more insight in where the source of the problem is. Check out my video on what to do when your code isn't running: kzbin.info/www/bejne/gmW5YmiQra6deLM

[@ubeydg]

Thanks. With this video, I've learned the name for the concept: "text interpolation".

[@saperis]

Happy to hear that. 😀

[@excelcut1135]

That sentence, when you said we should capture what you are doing and what will be the output.. Methods and Procedures was a good insight for learners. Instead of copy paste we need to understand the core concept

[@saperis]

Happy you liked it.

[@rbfreitas]

Great video! Clear and straight to the point

[@thinkthinktechs1119]

Thanks saperis for your awesome work

[@saperis]

My pleasure! 😀

[@ИльяСултанов]

Thanks for you videos and hello from Moscow!

[@saperis]

You're very welcome! Check out my Google Apps Script online course: courses.saperis.io Greetings, Chanel

[@tienvan6574]

Do you have new version for this. It happen 3years ago and I do like everything you say in this video but the code is not showing subscriber or view count

[@saperis]

We don't publish any Apps Script or Google Workspace videos on this channel anymore.

[@FernandoCervone]

Excelente vídeo, parabéns e obrigado !!!

[@saperis]

I'm happy you liked the video. Thank you for watching. 😀

[@VladArnoldner]

Can I use this script tool to clean Watch Later list, which has reached its limit of 5,000 items? Yes, youtube has no menu option to clean Watch Later list!

[@saperis]

Hi Vladimir. I've never done what you're trying to do so I can't answer the question based on experience. Have a look at the KZbin API: developers.google.com/youtube/v3/docs/playlists From what I can see in the documents you can create, update and delete playlists you create. The "Watch later" playlist, though, is a system playlist generated by KZbin. I could imagine that you can't modify this through the API. But you can try.

[@VladArnoldner]

@@saperis thank you! I will try Selenium Webdriver with Python :)

[@saperis]

That might actually be a good option. 👍

[@excelcut1135]

@@saperis Actually, Vladimir already had that answer... he just want to show off his knowledge... hahaha

[@nastromagnetico]

Dear Chanel. Is there some reason for which Google App Script fills a spreadsheet fields too slowly (during the information retrieve process from a youtube channel, or something like that)?? Some other way to prevent this latency? Thanks so much

[@saperis]

There are ways to optimize the run time of a script. For instance, you can loop through data and write row by row. Or you could loop through data, push it to an array and then write the whole array in one step to a range in a sheet. The second option is faster.

[@nastromagnetico]

@@saperis with a two-dimensional array, I think. Thank you Chanel.

[@karthicka371]

I'm looking to write a code that can track KZbin views for a particular video every 5 minutes and save the data along with the time in the cloud. Can you please help with that? I tried writing but couldn't find enough resources. Kindly guide mam

[@saperis]

We share our Google Apps Script knowledge through our video tutorials. But we don't write actual script for any of our customers. But you might find this video tutorial to be helpful: kzbin.info/www/bejne/nqCmmadpoN-BbdU

[@nastromagnetico]

Thanks a lot for your videos!! They're very helpful for me. My only trouble is how to get the duration of a single youtube video. Any suggestions for my problem? Thank you :)

[@saperis]

Thank you for the feedback. When using an API you always have to check the official documentation to find out what data you can get through that specific API. So have a look at the KZbin API documentation. I think what you're looking for might be the contentDetails.duration property. For details reference the documentation: developers.google.com/youtube/v3/docs/videos

[@nastromagnetico]

@@saperis You were so kind! Your suggestion solves my problem. Thank you for your help :)

[@christianpabunan6005]

Hello Mam Saperis! I'm your new subscriber from the Philippines. I found out all your videos are resourceful and absolutely helpful. If you don't mind Can I ask a favor? ^_^ ....tha If you can make a tutorial to make a hotel room booking with calendar reservation and with automated email response... Thanks in advance. More power to your channel.

[@saperis]

Hi Christian. Thanks for watching the videos and learning with the community. I try to keep these videos as interesting as possible for all the viewers. Your request is rather specific for your needs. So I won't be able to create a video like the one you're requesting. But if you need help from an Apps Script developer to build that script for your hotel have a look here: www.upwork.com/hire/google-spreadsheet-freelancers/

[@christianpabunan6005]

@@saperis thanks a lot for giving attention of my request. ^^

[@heidisimon1686]

Great presenter!

[@saperis]

Glad you think so!

[@salmanbinabduljabbar3651]

Hello Teacher, For me the debugging is not working. Any Idea why its not moving forward to 3rd line? the debugger can't debug on third line. Any help? I wasted 3-4 HOURS of my Life doing Debugging but Alas!!

[@saperis]

Sorry, no idea why the debugging isn't working for your script.

[@reboundpolychem2145]

Dear Madam, please suggest a VDO on mail merge

[@saperis]

Here's my video on how to do a mail merge with Google Apps Script: kzbin.info/www/bejne/paKQdXx3fceHgq8

[@ozegaming]

very Good

[@saperis]

Thanks 😀

[@AlbertoLoBruno]

Bravissima!

[@saperis]

Grazie Alberto! 😀

[@excelcut1135]

Hey Saperis, it's not working... showing error in that response variable declaration line.

[@saperis]

Well in that case it's time to debug. Check this video to see how you can find error in your code: kzbin.info/www/bejne/gmW5YmiQra6deLM

[@excelcut1135]

@@saperis thanks. its working.