How to Make Youtube Playlist with Google Spreadsheet
How to Make Youtube Playlist with Google Spreadsheet

Easily Make Youtube Playlist with Google Spreadsheet with the simple and easy guide that will help you to easily make a collection of your favorite media in a single click. So follow the below guide to proceed.

If you are on the internet then this is sure that you might have used up the Youtube also, and if you are familiar with the usage of youtube then there is one function of youtube through which you can make up your own playlist so that your favorite videos can be stored in that. Now making up the playlist on youtube could be very easy, just go through some options in your account and then get up your playlist created. But what if you wish to create it through the Google Spreadsheets? This would sound stupid as Google Spreadsheets is a very different kind of computer application that has no relation to the youtube, but wait this could be done in reality. Here in this article, we have discussed a unique method through which you can create up the Youtube playlist using up the Google Playlist! Just read the rest of the article to know about that method. The method that will work with URL tweaks that is simple URL combinations and you can easily create your desired playlists and directly use them right from your Google spreadsheet. So have a look at complete guide discussed below to proceed.

Also Read: 10 Amazing Tricks Every YouTube Addicts Need To Know

How to Make YouTube Playlist with Google Spreadsheet

Below is the complete step by step guide that you need to follow that will help you to make youtube playlist with Google Spreadsheet. So have a look at steps below.

Also Read: 6 Helpful Websites for Quick Info About your PC and Android

Steps to Make Youtube Playlist with Google Spreadsheet:

1. First of all, open up the Spreadsheet application on your computer and then create up a new Google Sheet, then after that put up the URL address of your desired youtube video in column A ( one video per cell and start with the column A3 of the sheet). After you put in the video URL to the cell A, then the column B shows up the Video ID and the column C will show you the video thumbnail.

2.  Now put up in the cells the video URL’s of your desired videos that you wish to show in your youtube playlist and then you will see that your new youtube playlist shall be updated to the account. You can then share up the Google Sheet with URL’s to anyone so that they can collaboratively join with your playlist.

3. Now you might be thinking how does it happen? The thing is that the REGEXTRACT formula of spreadsheets uses to extract up the youtube video ID from the URL you pasted in the cells and then once the Video ID is available the image formulae applies up to find up the thumbnail of the video.

REGEXTRACT Formulae: =REGEXTRACT(A3,”yotu(?:.*VvVI *v=I.beVI.*?embedV)([A-Za-z0-9_\-]{11})”)

Image Formulae: +IMAGE(“https://i3.ytimg.com/vi/”&B3&”/hqdefault.jpg”,4, 80, 120)

4. At last the formulae that generate up to the Youtube playlist as well as make up the live link with the Youtube:

+HYPERLINK(“https://www.youtube.com/watch_videos?video_ids=”&join(“,”,B3:B);”Link”)

Make Youtube Playlist with Google Spreadsheet
Make Youtube Playlist with Google Spreadsheet

Note: Your Youtube videos you put in your playlist won’t get synced to your Google account through using up the Google Spreadsheets so you need to manually update them if you want to sync the live videos feeds in your spreadsheet.

Also Read: How to Fix Youtube Videos not Playing on Android, iPhone, PC or MAC

Now you have got up the method through which you can actually make the youtube playlist with the Google Spreadsheet. Still, this thing could feel like unusual to you and you might not be believing in all that, but the truth is that you can actually do that up. To become sure about the method you should try to apply it up by yourself and create the youtube playlist through the Google Spreadsheets. And hope you like the guide, do share it with others too and leave a comment below if you have any related queries with this as techviral team will be always there to assist you in your issues.



AUTHOR

Karanpreet Singh is the Co-Founder of Techviral. He writes about how to, tutorials especially on Android, iPhone, Computer, Internet, Social Networks, etc. Apart from this, he is an Ec-Council CEH (Certified Ethical Hacker) and a Digital Marketing Expert. He loves to share his knowledge with others through blogging.